cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yuras2022
Frequent Visitor

Filter ODATA for two Sharepoint lists

Hello!

 

I use two Sharepoint lists for storing app data:

Yuras2022_0-1660384155953.png

and

Yuras2022_1-1660384223130.png

 

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:

Yuras2022_3-1660385628108.jpeg

 

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.

 

 

4 REPLIES 4
RobElliott
Super User
Super User

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

 

Rob
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?

Yuras2022_0-1660387136678.png

 

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

Announcements
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)