Power Platform Community Forum Thread Details

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?