cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patty789
Helper V
Helper V

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

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Wait wait wait...

Try this ODATA expression instead

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

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

14 REPLIES 14
efialttes
Super User
Super User

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

 

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



CFernandes
Super User
Super User

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

 

CFernandes_0-1600886176489.png

 

From a high level your solution will look like the screenshot below(I have highlight the action in which you need to apply filters).

 

CFernandes_1-1600886338190.png

 

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.

Hi!

Items created today? If so I would try with

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

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

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

Thanx



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

 

patty789_0-1600956026382.png

 

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!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@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 

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

Wait wait wait...

Try this ODATA expression instead

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

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

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,760)