Forum Discussion
Removing characters from questions uploaded to a SharePoint list
Hi,
Is there way to remove the [" "] characters that surround an answer to questions that are on Forms when n they are submitted and uploaded to SharePoint
The reason I'm asking is when I create a PowerApp with a filter function and to try and eliminate Delegation warning, I use StartsWith. I have to put a hint text to prefix every search with ["
Any idea how if this can be removed or how to deal with it from a PowerApp side??
1 Reply
- Rob_ElliottBronze Contributor
Chris_Clark1968 in your flow in Power Automate that creates the list item you just need to add a couple of Compose actions. In this example form there is one multi select question for the engineer(s) who performed a car service.
In your flow, the expression in the first compose is json( then you select the question about the engineer and the expression looks like this
json(outputs('Get_response_details')?['body/re5b63d5a2fe441fd8b650fb66c22fc7d'])The expression for the second compose is join( then you select the outputs of the previous compose and add a ,' , '
join(outputs('Compose-Convert_Engineer_to_JSON'),', ')
Then in the create item action, for the engineer column the outputs of the second compose have been selected from the dynamic content box.
The first item in the list below didn't have the compose actions. The second one did and you'll see it's stripped out the special characters.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)