cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
giustis5
New Member

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
Samuel
Power Apps
Power Apps

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?

@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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,620)