Flow to email sharepoint list

[Anonymous]

Hello everyone,

So I have a sharepoint list that is updated throughout the day, by multiple people, from 7am until 6am next day.

I would like to be able to email the entries that were created between that time, once a day at 6:30 am, to a group of people.

My head hurts from trying to figure it out on Flow.

Any help will be great.

Thank you

[v-micsh-msft]

Hi @Anonymous,

How would you like the entries to be sent, in a HTML table, or each one with an Email?

In addition, for the created, do you mean the newly created items?

If not, would you please explain a bit for the requirements?

There should be two options for you to filter the SharePoint Get Items Action, check the thread below:

Obtaining a filtered SharePoint list based off a column

1. First, use OData query under the Get Items Action->Advanced options, 

2, Second, use the Filter Array Action.

Then use the Create HTML table Action to generate the Table and send it via Email.

As you would like to filter the items within a time range, so here the only option left is to use the Filter Array Action, as the DateTimeRangesOverlap is not supported under SharePoint list OData query.

I will make some tests regarding the condition, and share the results once I finished.

Regards,

Michael

[Anonymous]

Hello @v-micsh-msft

I'm not sure what is the correct nomenclature, but I have a sharepoint list (think of it as excel table) and every row is a new entry. The columns are: Name, Location, Date, Details, Follow Up, Created by, Created, Modify by, Modified

New rows will be added throughout the day by various users. at the end of the day (at a specific time) I would like an email summary to be sent out to a group with all of the new entries that were made on the last 24h from the time the email should be sent, which is 6:00am.

The information I want on the email is the Name, Location, Date, and Details. Nothing else is needed, but I don't mind if theres more, or even everything.

I hope that this makes more sense.

Thank you!

[v-micsh-msft]

Hi @Anonymous,

Thanks for the updates. 

I think the Create HTML table Action is suitable in such a situation.

I will perform seom tests regarding the date filter, and will update here once I finished.

Regards,

Michael

[v-micsh-msft]

Hi @Anonymous,

I have some updates for you:

Whole logic for the following flow is:

Whe nthe corresponding Schedule triggered flow,  UTCNow() function would return today's time, which then we could take use to filter the Created field of the SharePoint list.

And currently it is not available for SharePoint connection to select the columns, if you would like this to be added in future Flow release, then please consider submit it as an idea.

Check following Flow configuration:

Things should be noticed:

1. For the Recurrence, the Start Time would be in UTC format, you need to convert your local time into UTC format (Time Zone is not helpful here), make sure the Start Time equals to 5:00 am at local time.

2. Add the SharePoint Get Items action, specify the corresponding Site Address and list name, no more settings with this action,

3. Filter Array action, Select the value from the Get Items action, then under the Condition, click Advanced, copy and paste the following:

@And( 
    lessOrEquals(
              int(formatdatetime(item()?['Created'],'yyyyMMddHHss')),
              int(concat(utcnow('yyyyMMdd'),'0600'))
                ),
    greaterOrEquals(
              int(formatdatetime(item()?['Created'],'yyyyMMddHHss')),
              int(concat(Adddays(utcnow(),-1,'yyyyMMdd'),'0700'))
               )
)

Formula here is used to filter with the Created field, the formula here uses UTCNow() function to get the proper day, concating with the time needed, then compare with the Created Field.

Function used is documentated in the following article:

Workflow Definition Language Schema for Azure Logic Apps

4. Add the Create HTML table Action, use the Filter Array Body as the Input, click Advanced option, choose the include headers as Yes.

5. Then add the Send an Email Action, use the Output of the Create HTML table as the Email Body field, specify the Group Email Address and the Subject, then click Advanced option, set the Is HTML option as YES.

Save it.

Regards,

Michael

[v-micsh-msft]

Hi @Anonymous,

What is your current situation?

Does the configuration work for you?

If you need any further assistance, please post back.

Regards,

Michael

[UB400]

@v-micsh-msft My apologies for reviving this old thread.

I have a sort of similar requirement, though mine is less complicated. I need to check the date in a Sharepoint Column (on a daily basis) and then send an e-mail on that date.

I have a PowerApps App that tracking upcoming activities (Using Sharepoint lists as a DataSource and one of those lists is called "Email" in which there is a Column for persons to send the e-mail to, Subject, Body etc. One of the columns is "EmailAlert" that contains the date that the e-mail needs to be sent out on.

Reading the above posts, it looks like we need to format the date  in the Sharepoint column to match the UTC format and then compare it to the current UTC Date and if it's a match to trigger the e-mail.

I'm adding an image of what I've done so far in my flow, I would really appreciate it if you could help with the code to format and compare the dates.

[Anonymous]

Thank you for your reply, and I'm sorry for the very late response.

The configuration did not work for me and that project was canceled due to other current limitations in PowerApps. 

I'm currently working on the app only without auto email.

Thank you for your time and assistance!