Hi @Anonymous,
Could you please share a bit more about your scenario?
Do you want to extract data from SP list into HTML file using PowerApps?
I assume that you use PowerApps to extract data from SP list into HTML File, is it true? If you generate an app from your SP list, the multi-value column (e.g. Choice type column, which enable multiple selections) would be decorated as a Combo box control within your app.
If you want to pull data from a Combo box control (enable multiple selections), you could consider take a try to concatenate these values within the Combo box control into a single one string value (using Concat function).
I have created a SP list as below:
Note: The Category column is a Choice type column, which enables multiple selections option.
I have made a test on my side, please take a try with the following workaround:
In order to pull data from above Combo box control (DataCardValue8) and concatenate these selected values into one tring value, please take a try with the following formula:
Concat(DataCardValue8.SelectedItems,Value&"|")
Note: The DataCardValue8 represents the Combo box control.
More details about the Concat function in PowerApps, please check the following article:
Concat function
In addition, if you want to achieve your needs using Microsoft Flow, you must concatenate the multiple options within the Multiple value column (on my side, it is Category column) into one string value firstly. I have made a test on my side, please take a try with the following workaround:
Within the "Compose 2" action, type the following formula:
concat(items('Apply_to_each_2')?['Value'],' | ',variables('CategoryString'))
Within the "Compose" action, type the following json formula:
{
"CourseName": @{item()?['CourseName']},
"Teacher": @{item()?['Teacher']},
"Category":@{variables('CategoryString')}
}
Within "Set variable 2" action, Value field set to null expression.
The flow works successfully as below:
More details about using expression in flow actions, please check the following article:
https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/
Best regards,
Kris
