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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,817)