Forum Discussion
Converting sharepoint items into readable format to send email?
Charles665 I assume you are using a Choice column for the Attended/Did Not Attend in your SharePoint list. That's what I've added to my list and the Course column is also a Choice column.
My flow is simpler than yours in that you don't need a Switch as there are only 2 outcomes for the attended column, Attended or Did Not Attend, so you can use a Condition. Also, you only need 1 Get Manager (V2) which you can use earlier in the flow. And you only need 1 Send an email action. So the flow looks like this:
Next we add 2 Office 365 User actions to get the profile of the user and their manager:
Next we add a Compose control and select Attended Value as the input. We then have a condition to check if the Attended column has been changed
If it hasn't then take no action, but if it has then send an email. It's the same email whether the user attended the training or not but uses the outputs of the Attended Compose control to add either Attended or Did Not Attend.
The email result looks like this:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Charles665 I assume you are using a Choice column for the Attended/Did Not Attend in your SharePoint list. That's what I've added to my list and the Course column is also a Choice column.
My flow is simpler than yours in that you don't need a Switch as there are only 2 outcomes for the attended column, Attended or Did Not Attend, so you can use a Condition. Also, you only need 1 Get Manager (V2) which you can use earlier in the flow. And you only need 1 Send an email action. So the flow looks like this:
Next we add 2 Office 365 User actions to get the profile of the user and their manager:
Next we add a Compose control and select Attended Value as the input. We then have a condition to check if the Attended column has been changed
If it hasn't then take no action, but if it has then send an email. It's the same email whether the user attended the training or not but uses the outputs of the Attended Compose control to add either Attended or Did Not Attend.
The email result looks like this:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Wow, yes your flow is way more simpler than mine. I appreciate you helping me out. Can I ask you one more question?
After the form is submitted, the trainer will go in and add the training class and time to the Microsoft list. Once he does that i have an email sent out stating Bill is signed up for "this training" on "this day".
Then after or during the training he will enter the attendance information like we previously discussed.
The problem I'm having is when he enters the Attendance it sends 2 emails instead of just the attendance one. So it will send another email stating they are signed up and then one that states they did or did not attend. I'm assuming the flow i need to fix is the "Signed up" one. How can i make it only send an email if the Date is added or modified?
Thank you.
RobElliott Actually after re reading i think your method will fix my "signed up" flow as well. Many thank yous!!!
