Answered

weekly get newly entered data in sharepoint list and send email

(0) Share

Report

Posted on by crugamba

Hi All,

So, I am trying to create a flow that will check a SharePoint list every week on Friday and send an email if there is any new items that have been added that week. It should be able to send those newly added items via email.

Anyway that can be done?

Thanks.

Cedric

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Hi @crugamba ,

Please refer to my below demo flow:
1. Recurrence trigger:

2. Get items action:

add filter query here:
Created gt 'expression'
For the expression part, please use below furmula:
addDays(startOfHour(utcNow()),-5)

4.Condition:

Expression:
length(outputs('Get_items')?['body/value'])
5.Create HTML table: select the value dynamic content like below snap

6. In the email to be sent, please just add the HTML table dynamic content:

Best Regards,
Hen Wang

Was this reply helpful? Yes No
crugamba 14 on at

Like (1)

Report

Thank you, Hen.
This was exactly what I needed.
But I'm running into an issue when I test the flow.
It's giving me this error at the Get items level:
The expression "Date Submited gt '2023-05-05T07:00:00.0000000Z'" is not valid. Creating query failed.
clientRequestId: 0ee137cc-b806-4bd7-a1e8-7561091b204b
serviceRequestId: 0ee137cc-b806-4bd7-a1e8-7561091b204b

I'm guessing it has to do with the way the date is saved in my list maybe:
How can I fix the error?
Thanks again for your flow btw.

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (1)

Report
Hi @crugamba ,

Please use below expression inside your filter query:
formatDateTime(addDays(utcNow(),-5), 'yyyy-MM-dd')

Best Regards,
Hen Wang

Was this reply helpful? Yes No
crugamba 14 on at

Like (0)

Report

Unfortunately, it didn't work.
I even changed the expression to the exact same date format as the one in my file but still throwing an error.
Here is the expression I set:
formatDateTime(addDays(utcNow(),-5), 'MM/dd/yyyy')
Here is the error:
The expression "Date Submited gt '05/05/2023'" is not valid. Creating query failed.
clientRequestId: 14aed01b-d57f-47f9-9bee-0d53a5f94fdf
serviceRequestId: 14aed01b-d57f-47f9-9bee-0d53a5f94fdf

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (1)

Report

Hi @crugamba ,

I think it's related to your field logic name, please go to your list and click setting icon (gear icon) on top right side and click list setting:

Then you need to find the column you want to compare and click on it:

Then in the URL of browser, you will find its real name after the FieldId=:

For me, it's submitdate here, please check it from your side and use it instead of "Submit Date".

Was this reply helpful? Yes No
crugamba 14 on at

Like (1)

Report

It's working perfectly now!
Thank you! Your help was very appreciated!

Was this reply helpful? Yes No