Forum Discussion

Chris_Clark1968's avatar
Chris_Clark1968
Brass Contributor
Aug 30, 2023

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??

Forms Responses
sharepoint
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Sep 07, 2023

    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)

Resources