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,
join(body('Get_items')?['value'][0]['field_9'], '; ')
This is what we have so far for the flow itself. (The apply each gets automatically added. It used to happen for the multiple-value options, but that issue should have been solved for at least the two columns we fixed. )
"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: Challenges:
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'], '; ')
2) Because we use "Get Items" instead of "Get Item" or because of the "Apply to Each" block at the bottom, files get created for ALL the lines in our list every time we run the flow. Ideally it would only automatically affect the last file when created.
3) Now, when I try to open the file created directly from SharePoint, Word gives me an error message saying: (This may be completely unrelated. Showed up afterwards, but might as well mention it here.)
And then:
Which generally freezes.
References for Multiple-value Columns:
