cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Use Shaerpoint Get item and Get Items and use ODATA filter in Get Items

I have thow SharePoint lists.  Order list is With order heading, and Orderline is the orderlines for each order. In Orderlines list the column OrderID is set to the ID Field for the acutal order heading.  I have problem using ODATA filter in "Get items" and to filter only items where Orderlines/OrderID = Order/ID.   Any idea how to handle this ?

 

Order: 

IDCustomer NameAdress
1Customer ASweden

 

Orderline:

IDOrderIDTextPrice
11Wheel 500
21Door1500
31Seat500

 

Only order lines for the selected order should be in a HTML table.  Here is the flow. 

 

ODATA filter.jpg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Use Shaerpoint Get item and Get Items and use ODATA filter in Get Items

Hi @TrulsB 

 

Under the filter query set the query as below

 

OrderID eq Dynamically map Id from Order (Header)

 

If Order Id is not numeric then set

 

OrderID eq Dynamically map id in single quotations.

 

image.png

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Use Shaerpoint Get item and Get Items and use ODATA filter in Get Items

Hi @TrulsB 

 

Under the filter query set the query as below

 

OrderID eq Dynamically map Id from Order (Header)

 

If Order Id is not numeric then set

 

OrderID eq Dynamically map id in single quotations.

 

image.png

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Use Shaerpoint Get item and Get Items and use ODATA filter in Get Items

Hi @TrulsB how are you? 

Regarding your question, the solution provided by @abm is correct. You can add a filter on the "Filter Query" in the format :

 

<Lookup attribute name> eq <value>

 

Another sample with my Employee list and Employee Skill.

 

Filtering by the ID passed:

 

12.jpg 

Please let me know if this helped on your question.

 

Thanks for using our community forum.

 

Regards.

 

Rodrigo Hentz

Microsoft Support Engineer

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,805)