Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Extract and search list and record

Hi all,


I am trying to extract  and search the List and Records from JSON column.


Here is my query steps so far and below is the explaination of one row



1. Here is the record for each row



2. In the each record there are few values.




3. I need to search only in the Notes. It is a 'List' .




4. In each list there are multiple records it can goup to 50.

In this example, there are 18 case notes left.


5. Here is the structure for each record. In the each record, I have to look for "Conversation with" row and need to search for a string "RTB", if 'RTB' existing then the original row it should display 1. In this example, 63207 should have 1



Can I get some guidance to proceed further pls?





Super User
Super User

I think you can add a new custom column along the lines of

if List.MatchesAny( [CaseJson][Notes], each _[ConversationWith] = "RTB") then 1 else 0 end

The syntax may not be quite right but I think the general principle will work

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors