Power Automate Flow to Remove Delimiters from Form Responses Fails

(1) Share

Report

Posted on by BBC_Astha

Hi everyone,
I’m trying to clean delimiters (like apostrophes) from Microsoft Forms responses using Power Automate.

The flow trigger: “When a new response is submitted” (Microsoft Forms)

Then I am using a Compose to check the logic and its response - Substring(ColumnVal,1) to remove the delimiter as shown in the image

But I get an error, because it seems that delimiter is not read in Compose

Can anyone guide me how to handle this case?

I need to:
1. Remove unwanted character (', extra spaces)
2. Preserve valid content (numbers in this case)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

You should use Trim() to remove leading and trailing spaces and Replace() to remove the single quotes or hyphens. The results will be in string format so if you need numeric you should use float() or int() to translate the strings to number format.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
BBC_Astha 6 on at

Like (0)

Report

@Pstork1

When I am retrieving the cell data in power automate, I do not see '4, it comes up as 4 without the delimiter and when I use any function it is working on 4 not on '4. I am not able to proceed from here. can you guide me where I am going wrong?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

So where is the '4 showing up if its not in Power Automate? Is the question setup as a number question in MS Forms or a String?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No