SOLVED

Converting sharepoint items into readable format to send email?

Occasional Contributor

Hey everyone,

 

I have an Training MS list that uses flow to pull data from a form when someone signs up. I have an attendance column where the trainer, after the training, can specify if the said person attended. I then have a flow that detects when the item was modified and will send an email to the supervisor. everything works great except the out put of the email is scrambled from the sharepoint item. 

 

Billy Bob was scheduled for [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Amazon"}] and DID NOT ATTEND.

 

How can I convert this to just say Amazon? I believe it is an object. Below is my flow.

Charles665_0-1613659057008.pngCharles665_1-1613659140298.png

 

5 Replies
best response confirmed by Charles665 (Occasional Contributor)
Solution

@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.

0-SPList.png

 

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:

1-Flow.png

 Next we add 2 Office 365 User actions to get the profile of the user and their manager:

2-Flow.png

 

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

3-Flow.png

 

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.

 

4-Flow.png

 

The email result looks like this:

5-EmailResult.png

 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!!!

Thank you @RobElliott. This worked perfectly. Appreciate you taking time to help me with this!! 

@Charles665 no problem, glad you got it to work.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User