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

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

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

Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

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

Power Automate Video Tutorials

View solution in original post

Highlighted
Microsoft
Microsoft

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,326)