I have been battling this and even with Copilot I am not getting a past it.
Scenario:
I have several SharePoint Libraries with documents against which there are several multi-select columns that lookup from the Term Store.
I want to create a list of new items in those libraries along with the selected terms to issue to people based on their choice of which terms they are interested in.
In principle I have a flow that does this, however, the table contains the Terms as Objects as image below:
I want to display these as a simple list like:
Site Prep. and Logistics, Hoarding, Site Compound
At the moment the flow that extracts these items and put it in a table looks like this:
Taking 'Subject' as the example. The setup looks like:
The Compose then looks like:
I have tried to put in a Loop after the Select with a Compose to create a String from the Select - Subject output and then append it to a temporary Variable that I can write to the Array. Like so:
But this just shows an error on inputs and runs so long I have to crash it out to stop it.
I tried a host of other things Copilot suggested, most of which seem to be expressions that don't work in Power Automate. So I'm at a loss as to what to do. The output of the Select under the original flow looks like:
So, how do I convert that to:
Site Prep. and Logistics, Hoarding, Site Compound?
