web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate "Insert Row to Sheets"...

Power Automate

Unanswered

"Insert Row to Sheets" adds "'" to cell

(0) Share

Report

Report

Posted on by xtrac_n00b

My flow is working except towards the last step. When I use "Insert Row" to a connected Google Sheets, the string variable gets inputted into the new row cell.

This string variable contains: =IMPORTRANGE("@{outputs('Clean_URL')}","Sheet1!A1:A12")

=IMPORTRANGE("@{outputs('Clean_URL')}","Sheet1!A1:A12")

However, when I review the output in the Sheet, the string variable is successfully outputted as above, with a "'" (apostrophe).

'=IMPORTRANGE("@{outputs('Clean_URL')}","Sheet1!A1:A12")

'=IMPORTRANGE("@{outputs('Clean_URL')}","Sheet1!A1:A12")

Therefore the command isn't executed.

Troubleshooting I've done:

I have used the raw output of "=IMPORTRANGE("@{outputs('Clean_URL')}","Sheet1!A1:A12")" in the cell and ran the flow. A new row is still created with the additional ' at the beginning.
I have manually tested the command and it works in sheets.
I have used Zapier to test the flow and it works.

The issue I'm noticing is the "Insert Row" (Google Sheets) action is generating the single apostrophe. Any ideas on what I could do?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Looks like it is occurring from the Google sheets side that is adding the apostrophe.
If the manual way of removing them is this then maybe as a programmatic way you can use Google script as mentioned in this direct link to the post here.

Was this reply helpful? Yes No

Join the conversation