Forum Discussion
Solved
PNP Filters and Microsoft Forms
I have a PNP web part which is connected to a SharePoint list. The list is populated automatically via Power Automate when a Microsoft Form is submitted. Two of the questions in the form allow multi-...
- 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.
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.