web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate joining values from an...

Power Automate

Unanswered

joining values from an array into a single excel cell

(2) Share

Report

Report

Posted on by hpayne1993

49 Season of Giving Solutions 2025

I have a flow containing an array of claim records and have filtered the array to group these records by member id (second image). I need to enter the grouped records into a row in an excel table but this requires me to join the values of the items in the filter array. i.e. If the filtered array contains 3 items I need to put all 3 meeting dates into one cell.

The report should look something like this:

How do I do this?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

PowerDeveloperTP 453 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

You can first extract the meeting dates from the filtered array where you filter using meeting ID and then use join to make it single entry.

Use Select to extract only the dates

1. Add Select

From :body('Filter_array')

Map

Key Value

Date item()?['MeetingDate']

Output becomes: [
"01/02/2026",
"15/02/2026",
"01/03/2026"
]

2 . Join the array into a string

Add Compose (or directly inside Excel step)

Expression:

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

Result:

01/02/2026, 15/02/2026, 01/03/2026

You can also use: join(body('Select'), '\n')

to place them on separate lines in one Excel cell.

Hope this helps

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No

Join the conversation