Google Sheet 'Get rows' action error when saving flow; "Unable to use or create id column 'PowerAppsId'. Create this column manually in your Google Sheet and try again. "

(0) Share

Report

Posted on by RBoneck

405

I have a flow with just a manual/click trigger and a Google Sheet 'Get rows' action. In the File field of 'Get rows' I have the ID of the sheets file, and in the Worksheet field I have selected the sheet I want to use. But when I try to save the flow, I get an error at the top of the screen.

"Unable to use or create id column '__PowerAppsId__'. Create this column manually in your Google Sheet and try again. "

I don't understand this error because I'm not trying to do anything with PowerApps nor have I specified anything with columns at all. Is this some kind of internal requirement for reading a Google Sheet in PowerAutomate? Is there some other way to read rows from a Google Sheet if given the URL or the ID of the sheet?