Get row from Google Sheet



Hi Team Power Automate this time I want to share with you how you can get row from google sheet. Some days ago I was looking into a class how to get a specific row from a google sheet and then I create a google sheet a column called ID with unique idenfiers and for my surprise when I try to get a row an error appears and says Row with key '2' not found. 

Then I try to change the column format, create again the excel, crearte a new connection and nothing works. Finally I decide to use get rows and I see a propertie called ItemInternalId and Bamp thats the solution.

Please allow me to share wih you the solution.

1.- You need to create an excel sheet here is mine


2.- Then create a flow using first get rows and see you have in your flow output a propertie called ItemInternalId, please copy that internal ID.


3.- Finally in your flow in the action get row just paste that Internal ID and let the magic runs.


You are now able to get a specific row from google sheets using power automate.

I hope this article could help you any coments you can leave it down. See you next time.


Publicar un comentario

0 Comentarios