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

1 Comentarios

Juntos aprendemos más, vamos deja tu comentario.