Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Filter ODATA for two Sharepoint lists



I use two Sharepoint lists for storing app data:





The RequestID from the second table is equal to the ID from the first table.


It needs to change ApprovalStatus when Status2 was updated. But one Request can have some Challenges


To get necessary Challenges, I have leveraged the next ODATA filter:



As result, I get all Challenges with ApprovalStatus that equal "New". The first part of filter does not work.


What should I do in given situation? Could you write me the correct ODATA request?


Thank you in advance.



Super User
Super User

You've got an incorrect single ) in the first part of the filter.


Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Hello, Rob.

What is incorrect single?



Here, RequestID is the value from the second table and ID is the value from the first table.

Could you tell me correct ODATA request?

It's the closing bracket/parenthesis on the far right of your image in your previous post. There isn't an equivalent opening bracket so it will give an error.

Thank you.

However, it is another problem here. Which? I do not know...

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (13,903)