How I can build a string from the Title values return from Get Items action?

Question

I have a Get Item action to return list items. then I want to build a comma separated string for all the titles. I tried this:

join(outputs('Get_items')?['body/value']?['Title'],';')'

and this:

join(outputs('Get_items')?[Title],';')

but it did not work. any advice?

I don't think you will be able to do it using join function. You will have to do it using apply to each loop. — Ganesh Sanap - MVP, Commented Mar 31, 2023 at 14:02
You can use select to create an array in this format: ['Title 1', 'Title 2', 'Title 3']. Then you can use join function. Let me add one example in answer. — Ganesh Sanap - MVP, Commented Mar 31, 2023 at 14:14

Ganesh Sanap - MVP · Accepted Answer · 2023-03-31 14:22:39Z

1

Use flow like this:

Expression in compose action:

join(body('Select'), ';')

Output:

answered Mar 31, 2023 at 14:22

46.4k22 gold badges31 silver badges63 bronze badges

Add a comment |

1 Answer 1