question

ShriGowthamTharunReddyAbbireddy-5016 avatar image
0 Votes"
ShriGowthamTharunReddyAbbireddy-5016 asked MayankBargali-MSFT answered

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

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShriGowthamTharunReddyAbbireddy-5016

Welcome to Microsoft Q&A! Thanks for posting the question.

Please confirm if my understanding is correct. Users can create the item in the SharePoint list (how you want your user to create the item, from SharePoint itself, Microsoft form, or any other input) but you want a workflow that approves the input value of the user through the approval email before the item is created in the SharePoint list?

0 Votes 0 ·

1 Answer

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered

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


image.png (7.2 KiB)
image.png (22.2 KiB)
image.png (7.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.