I am trying to get a list compiled and emailed to me of all items that were modified since the last version. I can get alerts or flows created to send individual emails but I would rather have a list emailed of all the items modified. Can you help me set this up?

Hi @ Tim Doriot , You could run it with the last Modified date/time (from the Get Items) Leave the Until field blank since you want all the changes. In the results of the action each column will have a True/False and a Value field. If it was changed in that version it will be marked as True. Those are the ones you want to report on. If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment" . Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Microsoft List/Power Automate - create a list of all modified items into one email

Accepted answer

RaytheonXie_MSFT 38,111 Reputation points Microsoft Vendor

2025-01-07T02:44:48.8666667+00:00

Hi @Tim Doriot,

You could run it with the last Modified date/time (from the Get Items) Leave the Until field blank since you want all the changes. In the results of the action each column will have a True/False and a Value field. If it was changed in that version it will be marked as True. Those are the ones you want to report on.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
RaytheonXie_MSFT 38,111 Reputation points Microsoft Vendor

2025-01-09T01:00:31.2166667+00:00

Hi @Tim Doriot,

Have you tried the solution I proposed?

If you have any questions or progress, you can contact me in time.

Looking forward to your reply

Have a lucky day!

Tim Doriot 25 Reputation points

2025-01-09T13:57:40.5433333+00:00

Sorry for the delay and thanks for your time, I will be trying it this morning and I will post the outcome

Tim Doriot 25 Reputation points

2025-01-09T14:06:34.52+00:00

Your solution worked, How do I get it to send an email with only the changes in certain columns? Also, I noticed when I setup the rule to send me changes every hour it sends the exact same changes for each update, how can I set it up to send the changes only once?

RaytheonXie_MSFT 38,111 Reputation points Microsoft Vendor

2025-01-10T02:53:00.75+00:00

Hi @Tim Doriot,

You could try to use add(float(triggerOutputs()?['body/{VersionNumber}']),-1) like the following article to get specific columns change

https://community.powerplatform.com/forums/thread/details/?threadid=043e7667-1338-4396-9a37-a7f750640a79

Since our forum focus on SharePoint, I am not familiar with Power Automate related technologies. If this solution does not meet your requirement, I would recommend you to raise a new ticket in Microsoft Power Automate Community. This is a Microsoft forum dedicated to discussing Power Automate. You might get some more professional advice there. Thanks for your understanding.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Microsoft List/Power Automate - create a list of all modified items into one email

0 additional answers

Your answer