
Announcements
Hello,
I'm using Encodian to convert create a PDF from a SharePoint list item. Basically creating an HTML and converting that to PDF. All works except the column that has multiple choice where a user can choose more than one value. It does not display that field in the PDF and if I choose the column (value) it want to create an "Apply to all" which will not work.
Thanks in advance.
This is standard Power Automate functionality.
When the SharePoint column type is choice and it is configured to allow multiple values... an array is returned as there could be more than one value.
Consider the following:
The SharePoint list is configured with a column called 'Choices' which is configured as follows:
As only a single value is allowed, when you use the column via dynamic data the following happens:
If the column configuration is changed to allow multiple values:
And do the same thing...
As the column now contains multiple values a loop is auto created.
If you need to enable multiple choices and you want to use the values singularly with an action in Power Automate you need to condense the array values to a single value, a very basic example is below:
This could be done more elegantly with either the concat or join expression but this example depicts the principle.
HTH
Jay