cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

query does not work

 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: query does not work

Hi @Anonymous,

 

I think the issue here should be related with your Flow trigger. 

Saw your another posts talking about this same issue.

If here you are using the "When a new item is created" trigger, and would like to filter the item newly created, we should just add a condition, specify the title field and Sales value, then under the yes part, add the send Email action, see:

55.PNG

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Anonymous
Not applicable

filter query problem

Hello! Have a problem with a query. Need to get data from items which have title='Sales' and send its to the e-mail. Use action 'Get items' and there try to write Filter Query. I'm writing Title eq 'Sales' to identify that i want only items with this title! How should I write!Help me please!Безымянный.png

 

 

 

 

Community Support Team
Community Support Team

Re: query does not work

Hi @Anonymous,

 

The filter Query is following the OData filter structure, so the formula should be:

Title eq 'Sales'

Just as you specified.

If the Get items returns blank, then please check the value part, make sure it matches exactly(including the space).

52.PNG

 

Further, for the OData query elements, please check:

Use OData query operations i nSharePoint REST requests

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: query does not work

Thanks for your answer, but i do like this Безымянный.png

and when i create a new item in my list i always get an e-mail even if my title is not 'Sales'. All titles are right for this query, but i need only get e-mails where title='Sales'

Community Support Team
Community Support Team

Re: query does not work

Hi @Anonymous,

 

I think the issue here should be related with your Flow trigger. 

Saw your another posts talking about this same issue.

If here you are using the "When a new item is created" trigger, and would like to filter the item newly created, we should just add a condition, specify the title field and Sales value, then under the yes part, add the send Email action, see:

55.PNG

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 345 members 4,247 guests
Please welcome our newest community members: