Sharepoint Flow Creation Based on Date Field

[sanagnos]

I have a SharePoint site which has data added daily. I am looking to setup a Flow that runs daily at a certain time. The flow would run at X time and would send an email alert depending on if any new items were added to the site. The Flow should use todays date as its trigger for weather or not an email alert should be sent out. I am able to create a flow with a recurrence and condition. But I am not able to add an initial step for the actual SharePoint site and list. If it select the sharepoint site, i can create the condition but not the recurrence of the check. 

Thanks!

[Jcook]

Hello @sanagnos 

Could you share a screenshot of your flow.

[sanagnos]

This is a simple one created. The goal is to be able to tie it into a SharePoint list.

[Jcook]

Hi @sanagnos 

When you say if an item has been added to the SharePoint site. Are you referring to a certain List, Document Lib, or both? 

[sanagnos]

It would be to a list. 

The condition would depend on the date. The email step would be sent only if the value under date is not equal to "today" .

[Jcook]

Okay @sanagnos 

I am building a POC for you. Last question. What is the format of your date in the date column

[sanagnos]

Thanks

[Jcook · Accepted solution]

@sanagnos 

Here is my POC:

First I initialize a string variable for itemDetails -- This will be used in the send email action, so we can send one email for all the new items

Next I have a Convert time zone action, This we use the expression utcnow() expression as our base time, and use the Short date pattern as our format

** Change your Destination time based on your Time zone or the time Time zone your SharePoint site is in **

Next add a Get items action, use a filter based on the image below: Date eq ' '

Next add a condition, we will use the expression length() to check if the Get items value is greater than 0

My expression looks like this:

length(body('Get_items')?['value'])

Now inside the true block:

Add an apply to each loop, and inside the loop add an append to string variable. This is to construct what you want your email to look like. ***IF you want separate emails for each item, ignore this step and add the send email action inside the loop ***

Now outside the loop use your Send email action and put the Variable in the body

Let me know if you run into any problems

[sanagnos]

I will take a look and let you know if I run into any issues, thank you!