cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yjamous
Advocate II
Advocate II

Filtering using OData

Hi

I'm trying to build a flow that will check the SharePoint list for two things:

1) Is the AlertStatus Active?

2) Is the AlertQTY >= DeliveredQTY?

 

If both conditions are met, then an email will be sent to alert someone that they need to re-stock.

yjamous_0-1630549646836.png

 

I've created a flow to achieve the above.

The challenges I'm facing:

1) Though I can filter Get Items with Odata to get only entries where "AlertStatus" is Active, I can't filter also items where "AlertQTY" >= "DeliveredQTY".

2) I've created HTML Table to be added to the email to be sent to the customer, but the problem is, the HTML table contains also items where "AlertQTY" is NOT greater than or equal "DeliveredQTY". This is because of issue in step 1.

 

So, what I would like to achieve is HTML table that contains ONLY items that meets this criteria:

AlertStatus is Active

AlertQTY >= DeliveredQTY

 

Screenshots from my flow

 

Overall flow

yjamous_1-1630550225603.png

 

Get Items and Compose Details:

yjamous_0-1630551706245.png

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks @ekarim2020 

I found another way which was posted here by @Paulie78 

Solved: GetItems ODATA compare two SharePoint list number ... - Power Platform Community (microsoft....

Using Filter Array was an easy way to implement what I wanted it. 

 

 

 

View solution in original post

3 REPLIES 3
ekarim2020
Resident Rockstar
Resident Rockstar

Your query should resemble like this:

ekarim2020_0-1630595916717.png

the and operator seems to only work if the conditions are placed within brackets.

 

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Thanks @ekarim2020 

I found another way which was posted here by @Paulie78 

Solved: GetItems ODATA compare two SharePoint list number ... - Power Platform Community (microsoft....

Using Filter Array was an easy way to implement what I wanted it. 

 

 

 

View solution in original post

You must be the person that commented on my unlisted video this morning! Glad you got it sorted.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,435)