How can i create a reminder flow when an item is created in a Sharepoint list

[patty789]

Hello,

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?

[efialttes]

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

[patty789]

@efialttes thank you for your quick response, how can i schedule it to go out only once a day? 

[efialttes]

Hi!

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

https://powerusers.microsoft.com/t5/General-Power-Automate/Create-Daily-Summary-of-Files-Uploaded-to...

https://www.chakkaradeep.com/2018/05/02/building-html-tables-in-your-flows/

Happy flowing!

[CFernandes]

@patty789 

Hey Mate, 

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!

[patty789]

@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]

Hi!

Items created today? If so I would try with

Division eq '1' and Created ge '@{utcNow('yyyy-MM-dd')}'

Hope this helps

[patty789]

@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. 

[efialttes]

Please share a screenshot with your current flow design, remember to expand the action blocks so we can see their inputs

Thanx

[patty789]

@efialttes I get an empty email not showing the values using the filter query. Is there another workaround i can do?

[efialttes]

Hi again!

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'...?

Thanx!

[patty789]

@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 

[efialttes]

Hi again

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

https://alextofan.com/2019/08/22/how-to-get-more-than-5000-item-from-sharepoint-online-in-flow/

Hope this helps

[patty789]

@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. 

[efialttes · Accepted solution]

Wait wait wait...

Try this ODATA expression instead

Created ge '@{utcNow('yyyy-MM-dd')}'

Hope this helps