Answered

Flow needed to email any modifications to a list

(0) Share

Report

Posted on by dmooreii

I am looking for a way to check a SharePoint list for any modifications performed on the current date and email list entries found to users in a single email message

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Hi @dmooreii ,

Seems you are looking for a daily scheduled flow that filter the modified column based on date and then do the email job.

Let's say that you want to check the modified items in current day at the end of the work day. This example took all the modified items from yesterday end of work day (18:00) until today() (when the flow is scheduled to run), convert the data (ID item and link to the item) is a HTML table and send the results to whom you need.

Hope it helps !

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report

When I enter the filter string as you have it, I get "the expression is invalid"

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@dmooreii ,

there are two small qoutes ‘ before and after. Have you use it ?

Modified gt ‘ formula ‘

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report

InvalidTemplate. Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '14629': 'The template language function 'addDays' expects a timestamp as the first parameter, the number of days to add as the second parameter, and an optional format string as the third parameter. The function was invoked with '0' parameter(s). Please see https://aka.ms/logicexpressions#adddays for usage details.'.

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report

I was able to get this to work.
Just one issue left.
One of my fields is a status dropdown.
When I receive the email it shows like this:
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Available"}
Is there a way to parse out just the value of the field ?

Was this reply helpful? Yes No