@MVCuser
To resolve the issue where the same notification is sent two days in a row, you can modify the filter query expression in your Power Automate flow. Here's a suggested modification:
1. Open your Power Automate flow and locate the action that retrieves the files added to the library.
2. Edit the filter query expression to compare the modified date against the last sent notification timestamp. You can achieve this by storing the last sent notification timestamp in a variable or in a SharePoint list column.
Example:
- Assume you have a variable named `LastNotificationSentTime` that holds the last sent notification timestamp.
- Modify the filter query expression to compare the modified date against `LastNotificationSentTime`:
modified gt 'formatDateTime(variables('LastNotificationSentTime'), 'yyyy-MM-ddTHH:mm:ssZ')'
Note: Adjust the format of `LastNotificationSentTime` to match the expected date and time format in your filter query.
3. After retrieving the files, update the `LastNotificationSentTime` variable or SharePoint list column with the current timestamp to mark the time of the latest sent notification.
Example:
- Set the `LastNotificationSentTime` variable to the current timestamp using the expression:
formatDateTime(utcNow(), 'yyyy-MM-ddTHH:mm:ssZ')
By comparing the modified date of the files against the `LastNotificationSentTime`, you ensure that only files modified after the previous notification are included in the current notification. This prevents duplicate notifications for the same files.
Make sure to save and test your modified Power Automate flow to ensure that it sends notifications correctly and avoids duplications based on the modified date comparison.
If I have answered your question, please mark your post as Solved If you like my response, please give it a like |
