cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
giustis5
Level: Power Up

How can i filter?

I am creating a Flow that sends an email when a new item is added to a SharePoint list, i only want to send the email however if a specific value is in one of the columns within the sharepoint list item.  I have configured the step as the image below but it sends the email whenever any item is created irrespective of my filter. 

 

My SharePoint list is called Accidents.  It has a choice column in it called Description.  The choices available are:

 

Minor Accident

Major Accident

Serious Accident

 

I want to send the email only when the value selected is Serious Accident.  As well as the below Filter i have also tried:

Filter( Accidents, Description = "Serious Accident")

but this did not work either.  Any help would be appreciated, thanks.

 

screenshot.png

2 REPLIES 2
Power Apps Staff Samuel
Power Apps Staff

Re: How can i filter?

In theory you'd type in something like "Description eq 'Serious Accident'". Some good articles for sharepoint odata syntax here (http://www.trigent.com/blog/introduction-to-rest-api-with-odata-operators-in-sharepoint-2013/) and here (https://msdn.microsoft.com/en-us/library/office/fp142385.aspx#bk_supported).

 

However, I personally couldn't get this to work. @SameerCh, any idea if these query strings actually make it through to the sharepoint endpoint?

Highlighted
efialtes
Level 8

Re: How can i filter?

@Samuel

I couldn't make filters work on Office 365 Calendar Get Events, filter examples I tried are posted at https://powerusers.microsoft.com/t5/Flow-Forum/Is-Office-365-Get-Events-Filter-Query-working/m-p/223...

 

Then I found a post on powerapps forum detailing similar filter problems with Sharepoint Get Items. According to response given last 25-april, "filter functionality has not been implemented yet. It's in the plan to support filter query. We don't have a timeline right now." No feedback since then. This second post can be found at:

 

https://powerusers.microsoft.com/t5/PowerApps-Forum/Logic-Flow-Get-Items-Filter/m-p/632/highlight/tr...

 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,426)