Greetings Power Automate Powerusers,
I hope this message finds all of you well.
Could you please help me with the final steps of this flow?
Background:
We are trying to extract values from a SharePoint list and populate a Word Template. The first issue we encountered was that we had two columns in the list that required the possibility of multiple values to be selected.
After reading a few of the posts from users here (see links at the bottom), my group developed code for those ones. Namely,
"For a Selected Item" block:
For the "Get Items" block: (We have not done anything for the advanced options)
"Apply to Each 2" Block:
(Guess: Another possible cause for the apply to each could be double values we have for some cells, like the one below:)
Lastly for the mapping portion, the cells where we have used the join expression pasted above:
For completion, here is the "Apply to Each" block:
1) However, this is the sort of output I would get:
Where all the propersties of the variable seem to show up. Is it because there is no "/value" after the "field_9"?
join(body('Get_items')?['value'][0]['field_9'], '; ')
And then:
Which generally freezes.
References for Multiple-value Columns:@Anonymous
This is expected behaviour.
You are using "Get Items" which is an array of items. Therefore it creates an apply to each to cycle through each item that you are getting. And since you inserted the Populate Word file into the apply to each, it populates a template for each of those values.
I don't follow what you are actually trying to achieve to be honest.
WarrenBelz
146,658
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional