Retiring SharePoint 2013 Workflows - Introducing Power Automate

(0) Share

Report

Posted on by MB-12021125-0

Hello, due to the deprecation of SharePoint 2013 on April 2, 2026, I'd appreciate your help in providing a solution using Power Automate to send emails to specific user groups when new items are added or when existing items are updated. The automation in Power Automate that sends notifications about added items is temporarily unavailable. As a result, this notification will only occur once a day at 12:00 AM and will summarize all changes (new items added, old items edited). Another item on my SharePoint list is linked to another list using the "Lookup" display type. Regarding the display of values in emails, here's what I'd suggest: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":84,"Value":"H319 Serious eye damage/eye irritation, category 2"}]

I want to be notified in an email like this: H319 Serious eye damage/eye irritation, category 2

Thanks in advance for your help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

It looks like lookup column is multi select column. Use "Select" action and pass the lookup col as its input. Set Value property in the map parameter. The output of select action will an array of lookup col values. In the email, use join expression with comma to join output of select action array with comma separated string.

If this reply helps & solves the problem, pls mark it as accepted solution.

Thanks,
Manish Solanki
Manish Solanki | LinkedIn

Microsoft Power Platform - Use Cases and Solutions

Manish Solanki - YouTube

Was this reply helpful? Yes No
Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
If I am following the thread correctly, you have a multiple-choice column and you want the choices formatted as comma-separated values in the e-mail. If so, do this:

Create an Array variable with the default value of [] (setting the default to this is important to prevent errors).

Add an apply to each action.

Set the output from previous step field in the apply to each action to the multiple choice column, but not the one that has value after its name.

Add an Append to array variable to the apply to each.

Append the variable created in step 1 with the multiple choice column, but this time use the one that has value after the name.

Outside of the apply to each action, add a Compose action.

Use this expression to join the values in the variable you created: join(variables('YourVariable'), ', ')

It will look like this:

Then use the variable in the e-mail action.

Was this reply helpful? Yes No