Convert single record choice column to text

(0) Share

Report

Posted on by R Bakker

725

Hi everyone

I do have a working flow, which is grabbing a record from a Sharepoint list and emailing it as a Pdf, however one of the columns in my Sharepoint list is a multiselect choice column. I would like the values for the chosen record as text in my Pdf.

Any help would be appreciated

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Kabilesh 177 on at

Like (0)

Report
Copy link

Link copied!

Hi @Corissandageri

Can you share the PDF Sample?

Best Regards,
VK

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!
This is the html before it is converted.
<!DOCTYPE html> <html> <head> <style> table, th, td { border: 1px solid black; border-collapse: collapse; } </style> </head> <body> OPC Packaging Arrival Report for Order number <table border="1" cellpadding="1" cellspacing="1" style="width:500px"> <tbody> <tr> <td>Company</td> <td>Date</td> </tr> <tr> <td><Company></td> <td>@{formatDateTime(utcNow(),'dd-mm-yyy')}</td> </tr> <tr> <td>Product</td> <td>Qty</td> </tr> <tr> <td>@{outputs('Get_item')?['body/PType']}</td> <td>@{outputs('Get_item')?['body/PQty']}</td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td>Wrapped Acceptably</td> <td>@{items('Apply_to_each')?['Value']}</td> </tr> <tr> <td>UnDamaged</td> <td><UnDamagedYes/No></td> </tr> <tr> <td>Free of Vermin</td> <td><Free of VerminYes/No></td> </tr> <tr> <td>Stacked correctly</td> <td><Stacked correctlyYes/No></td> </tr> </tbody> </table>   Notes: @{outputs('Get_item')?['body/PNotes']} Packaging assessed by: @{outputs('Get_item')?['body/AssessedBy']} Signature: <Signature> Photos: </body> <html>@{items('Apply_to_each')?['Value']}
Some fields are not yet populated

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Here's a quick example where I get the values from my multi-select choice column then join them together.

The SharePoint item I'm retrieving is ID = 4 in the following list. I'll retrieve all the Country values.

See full flow below. I'll go into each action.

Get item retrieves the item from the list.

Select takes in the Countries from Get item, and uses the following expression to extract the values. Note that I'm also using Text mode (see arrow on screenshot below).
item()?['Value']

Join takes the output from Select and joins each of the items using ", ".

This would give the following output.

If you didn't want to use a Join action (as above) and just use an expression to join them, you could do the following.
join(body('Select'), ', ')

Once you have the values joined, you can add them to your PDF.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Hi Grant
Thank you for your time
I can't seem to get past Select, in the Map field, it does not seem to matter whether I choose InwardPCondition Value or InwardPCondition Item or InwardPCondition. It is still asking for valid json.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
You should just be using InwardPCondition (not Item or Value).

When you run your flow can you look to see what JSON comes back for that field? For my Countries field (multiselect Choice field) I get the following:

[ { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 0, "Value": "USA" }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 1, "Value": "Canada" }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 2, "Value": "China" }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 4, "Value": "England" } ]

Is this similar to your field?

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Hi Grant,
Thank you very much, it is working now.

Was this reply helpful? Yes No