I have a sharepoint list with a multi select column and I need to get that data and add it to an Adaptive Card as a single line of text. I can't use variabes and append each value to a string because I have an "Apply to each" loop runnning concurrently with a degree of 50, so the variables get caught each up with each other.
The output of the column to the adaptive card should be something like "x, y, z".
With the following expressions you should be able to show the value of Multi select column of the first three options separately. In my example MultiChoice is the name of the multi select SharePoint column.
outputs('Get_items')?['body/value']['MultiChoice']['Value'] outputs('Get_items')?['body/value']['MultiChoice']['Value'] outputs('Get_items')?['body/value']['MultiChoice']['Value']
Just out of curiosity, is there any dynamic way of doing this?
And would I put that expression in a "compose" block or something else?
Try to do the following
For each item, you may have single or multiple choice selected so you have to go with the Apply to each for the choice column to pull the values dynamically. Try it out and let me know.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!