Unanswered

Use SPO Get Items to build string variable from all list entries

(0) Share

Report

Posted on by vbbvbb Microsoft Employee

Hi all, just want to check if this is viable scenario - if we take a SPO list with 2 columns: "user name" and "email", for example:

Column SPOName: John Doe , Jane Doe

Column SPOEmail: john.doe@contoso.com, jane.doe@contoso.com

Initialise string variable ListItems
Get items - point to SPO list;
Apply to each > Set Variable ListItems with value: "SPO name - <at>SPOEmail</at>, "
Use ListItems as dynamic content to insert into adaptive card.

It works fine but in the final card, only 1 entry is getting added, while Flow run showing list of these values:

And final result is just "Jane Doe - @Jane.doe@contoso.com".

How to make all "Apply to Each" variable results to be output into continuous text string like : "Jane Doe - @Jane.doe@contoso.com, John Doe - @John.doe@contoso.com,"?

I suspect that some Compose action is needed but what would be espression to add all these variables in the string?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (1)

Report

Hi!
You can either use 'Append to string' variable
or
Declare your variable as Array, use 'Append to Array', and once 'apply to each' is finished, convert it into a string by means of join() function
More info here
https://powerusers.microsoft.com/t5/Building-Flows/Put-spaces-between-people-names/td-p/506563
Hope this helps

Was this reply helpful? Yes No
vbbvbb Microsoft Employee on at

Like (0)

Report

So if I want to use Append to String, how does the logic works here:

Does it stay inside Apply to each? I tried that now - doesn't seem that it likes the output already inside the adaptive card.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!
I an afraid It's difficult to suggest anything without having context info about the adaptive card design
Please share Adaptive Card json definition if possible
Thanx!

Was this reply helpful? Yes No
vbbvbb Microsoft Employee on at

Like (1)

Report

I guess i just have to use Compose with append to string variable results and then use these in adaptive card body where i want these text strings to be inserted?

UPS: Yup, that solved it 🙂 Thanks for valuable advice!

Was this reply helpful? Yes No