I Have a workflow that sends a beautifully formatted html table in the body of email, using the columns from a SharePoint list. Works very well, as i only intended the one item in the list. Requirement has changed, so there may be many items in the list. Again, this works beautifully, however it also generates a separate email for each item entered, as expected.
I want to now restrict the email that goes out to just a single email that shows JUST the current week items (one row). There is a date column called "WeekStart" that I want to filter by to enable this, however i cant seem to get anything suitable.
The week start is every Friday, (Which is the "WeekStart" Date column, and the workflow is recurring every Thursday at PM. Works very well, however - too many emails.. Perhaps i used an incorrect method?
Fairly new to power-automate, and am learning exponentially. Should i have used a different approach?
Thank you..