cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasmine2020
Microsoft
Microsoft

Query for a result within a result using Logic Apps

I have a JSON document within CosmosDB that looks like this

{
"id":"1234-11111-22222-2222"
"Feedbacks": [
{ "id": "abc"
}
]
}


I would like to first find all the documents where the ids are >15 and then loop over and find all the feedbacks that are associated with this result. How would I do this using the LogicApp? I have an idea and this is what I have done so far:

 

jasmine2020_0-1597107113766.png

 

 

 

 

 

I am not sure what the next step should be? Should I perform another query? if so, what would this be?

Select c.Feedbacks from ...?

 

Because now that I have my first result from query 1, I need to query within this result for all of the Feedback ids


Any help or suggestion is appreciated.

1 REPLY 1
vikulkar
Community Support
Community Support

Hi @jasmine2020 ,

 

After you get the json output from a previous action in flow. You can make use of Filter array action to query the results further 

vikulkar_0-1597241760361.png

 

Hopefully this helps.

 

Thanks and Regards,

       Vikas

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,566)