Hi Team,
I am building a flow to get planner tasks into an excel. I am getting stuck on the task #4 below. I have multiple assignees for each tasks and I want them to be combined in just one cell, separated by ";". Check what I did:
Step 1: Manually trigger a flow:
Step 2: List rows present in a table
step 3: apply to each (delectes content in the table)
step 4: list planner tasks
step 5: Foreach 2
*Select an output from previous steps: Value (Planner)
Compose 1. Inputs: items('Apply_to_each_value')['assignments']
For each 3 (nested within foreach 2)
Select an output from previous steps: Outputs (from compose 1)
Compose 2 Inputs: join(outputs('Compose_1'), ';')
Add a row into a table