I am really new to the power automate. Yet i am trying to set a schedule to run when an item is created in a SharePoint list based on a condition of a column value. I don't know how to accomplish this. Any ideas on how to start this?
Solved! Go to Solution.
You mean when an item is created, send an email notification if the value asigned to column X is Z?
You need to add trigger 'When an item is created' and assign values to its inputs
NExt, add a Condition action block, assign to its left side the column name to be evaluated from the dynamic content menu, assign to the right side the expected value, select operator equals
Now, on the true branch of the Condition action block add a 'Send an email' action block and assign values to its inputs
Hope this helps
So you need a different trigger (REcurrence), you need a 'Get items' action block, you need to filter its results, and I believe you expect a single email reporting all items whose column value matches your condition right?
If so, two great examples here
Please consider @efialttes valuable insight, especially the link which will help you apply filters.. As you are new to Power Automate, I just though of creating a small demo.
You can use the recurrence Trigger,
From a high level your solution will look like the screenshot below(I have highlight the action in which you need to apply filters).
I hope this helps our inputs help you get started.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
@CFernandes, @efialttes thank you both for the great help. I have one more question. When i use the Filter Query i am trying to get two conditions, but when i test the flow i get the expression that i am putting is not valid. EX. Division eq'1' and Created eq'utcNow'. Am i doing something wrong? I am trying to get only for division 1 and then created current date.
@efialttes I put that formula yet when i test the flow i don't get anything back. The email comes out blank. And i have 4 records that where created today.
How many items do you have in your SP list? More than 100?
Your SP list has a column called 'Division'. IS it of type 'single line of text', 'number', 'choice', 'lookup'...?
@efialttes Yes its more than 100 that is the reason why i am filtering by only one division and only for the current date. the division column is a choice
More than 100? 'Get items' default response is max 100 elements. If you do not specify 'Order by', it will grab the oldest 100 items, which were probably created months ago. So this explains why your Filter output is empty.
You need to increase the limit: either up to 5,000 by setting this value as 'Top count' input or even higher by activating pagination
Great article explaining both options here
Hope this helps
@efialttes It is just super strange that i just created the exact same flow but to point to another different list and just added the filter query to Created eq'utcNow'('yyyy/MM/dd')' and i created some fake data for today and i am getting blank on the email and this list does not have many records at all. To me that expression is the problem.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
The Super User program for 2022- Season 2 has kicked off!