I'm struggling with my flow construction, probably because I'm such a newbie at this...
Here's the context...
I have a Sharepoint list of items - each is a project status update including the project name, current status and current activity and the date the information was entered, normal and blocking issues, etc etc.
The project managers will input to the list every week, using a powerapp. Then I want to trigger a flow (probably a recurring schedule) that sends an email to the various project sponsors with the latest inputs for each project, the current status of the project and the current activity.
I scoured around and experimented, but have failed to develop a successful flow.
Any help gratefully received.
If you could put a column in the SharePoint list with the various project sponsors' emails, this could achieve easily with a flow like this:
Put the project sponsors' emails in the To field and the sharepoint columns in the Body.
thanks Mona... my problem is that the information will come from more than one item in the list and I wish to filter by most recent entry by project name, grab the specific 'cells' from each 'row', join those into one html or string and email that to the sponsor group.
Am I right in thinking that your suggestion means that each sponsor would get the results of one item per email, and that they would get an email for every 'row' for the project, not just the most recent entry.
What do you think?
As requested by matthew_B, here's how I ended up...
STEP 1 - Set up your Trigger. Mine's a Recurrence at 12noon and 5 pm every Friday.
STEP 2 - Get Items. input your Site Address and your List Name as prompted. So far, so good.
STEP 3 - Filter that array. In the From box select "value" from sharepoint
The magic happens in the equation, which looks like this:
For this to work, you will need columns in your sharepoint that calculate the start of the week for each create date column.
You'll also need columns for each day of the week. For example, MonText is a column in the sharepoint that is a textstring of a column that calculates the date for Monday of that week (based on the Date Created column). With me so far?
STEP 4: Use "Select". "From" is "Body". Map the key and values you wish to include in your email.
STEP 5: Use "Create HTML table"
STEP 6: use "Send an email" and set the Body to "Output"
Clouds part, angels sing.
Although, seriously, if that is still a bit mysterious, reach out at email@example.com
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!