How to replace Column name with single quote in power Automate

(2) Share

Report

Posted on by vijaya9090

I have a column header name Yesterday_s_Deficiency .How can I replace that column with Yesterday's Deficiency in my Power Automate flow by using replace expression.

Please suggest?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

AnthonyAmador 2,553 Moderator on at

Like (1)

Report

Hi,

If your question is about how to use the replace expression, here is a video that explains it very well: https://www.youtube.com/watch?v=7g0z48hGuS0

If you want to replace a column title in a table, we will need more context to help you.

Hope this help.
Anthony.

Was this reply helpful? Yes No
Suggested answer

AnthonyAmador 2,553 Moderator on at

Like (2)

Report
Hi,

After reading it again, I understood your question. You have to set the expression like this to add the apostrophe:

replace(dynamicContent,'Yesterday_s_Deficiency','Yesterday''s Deficiency')

Basically, you have to use two single quotes where the apostrophe/quote is in your word.

Hope this helps.
Anthony

Was this reply helpful? Yes No
vijaya9090 26 on at

Like (1)

Report

I have a column header name Yesterday_s_Deficiency I want to relace that with new text(Yesterday's Deficiency) in my output CSV file.

Tell me know what context do you need?

As of right now I am using replace(output('Compose ),'Yesterday_s_Deficiency', 'Yesterdays Deficiency')'

But the new text should be Yesterday's Deficiency.

Was this reply helpful? Yes No
vijaya9090 26 on at

Like (1)

Report

Yes,that is write.I am going to try that.

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on at

Like (1)

Report

You have to use two single quotes '' not double quotes ", let me know if that works for you!

Was this reply helpful? Yes No
vijaya9090 26 on at

Like (1)

Report

It worked for me. Thankyou Amador!

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on at

Like (1)

Report

Great! Please mark the answer as verified so other users with the same question can find it more easily!

Best.

Anthony!

Was this reply helpful? Yes No