How to read multiselect column in sharepoint list and input the value into to a mail using logic app

2021-05-04T10:18:27.347+00:00

I have created sharepoint list where it has a column where user can select multiple values (x,y). Now i need to send an approval mail using logic app and in mail body it has to show the values user selected , values need to be comma separated. I need help on how to achieve this.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,820 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 49,711 Reputation points Microsoft Employee
    2021-05-13T09:05:45.09+00:00

    @Shri Gowtham Tharun Reddy Abbireddy Thanks for sharing more details in a private comment. If your column has "Allow Mutiple Selection" then to get the individual value selected you need to loop in through the column as the response will be a list for that column.

    For testing, I have created three columns in my list as below screenshot. "MultiValue" is the column name that has enabled "Allow Mutiple Selection". Below is the inserted value

    96323-image.png

    The first loop is for the n number of items that is received from the sharepoint trigger. The second loop is to loop in through the "MultiValue" column. Below is the Logic App Workflow

    96316-image.png

    Output:

    96220-image.png

    Now you can use this output variable in your email content. You can modify it according to your business needs.
    Hope this helps you to resolve the issue. Feel free to get back to me if you need any assistance.

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

    No comments