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!



Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,475)