cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShadowTech
Post Prodigy
Post Prodigy

Encodian html to pdf conversion with multi choice columns in SharePoint list

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Jay-Encodian
Community Champion
Community Champion

@ShadowTech 

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:

z.jpg

 The SharePoint list is configured with a column called 'Choices' which is configured as follows:

z1.jpg

 As only a single value is allowed, when you use the column via dynamic data the following happens:

z2.jpg

 If the column configuration is changed to allow multiple values:

z4.jpg

 And do the same thing...

z5.jpg

 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:

z6.jpg

 This could be done more elegantly with either the concat or join expression but this example depicts the principle.

HTH

Jay

View solution in original post

1 REPLY 1
Jay-Encodian
Community Champion
Community Champion

@ShadowTech 

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:

z.jpg

 The SharePoint list is configured with a column called 'Choices' which is configured as follows:

z1.jpg

 As only a single value is allowed, when you use the column via dynamic data the following happens:

z2.jpg

 If the column configuration is changed to allow multiple values:

z4.jpg

 And do the same thing...

z5.jpg

 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:

z6.jpg

 This could be done more elegantly with either the concat or join expression but this example depicts the principle.

HTH

Jay

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,297)