Forum Discussion
eahbxecrfash3q
Mar 11, 2024Brass Contributor
Re: PNP Filters and Microsoft Forms
Fixed by adjusting the Power Automate flow. For each multi-select question I added a Compose action with:
json(replace(replace(replace(outputs('Get_response_details')?['body/r314fbee50e9c42fb87b5f5efe78c77cb'], '[', '[
{
"Value": '), ',', '
},
{
"Value": '), ']', '
}
]'))
It takes the response from the form and replaces a few characters to it matches the syntax needed to add each option as a separate value.
json(replace(replace(replace(outputs('Get_response_details')?['body/r314fbee50e9c42fb87b5f5efe78c77cb'], '[', '[
{
"Value": '), ',', '
},
{
"Value": '), ']', '
}
]'))
It takes the response from the form and replaces a few characters to it matches the syntax needed to add each option as a separate value.
No RepliesBe the first to reply