Basics - Get Row from Google Sheet

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I believe I need what "Get a Row" for Excel has but I want it in "Get a Row" for Google Sheets.

I have a table of clients in a google sheet. It has ClientID, ClientEmail and lots of other columns.

In my flow I have ClientID from elsewhere. I just want to look up the ClientEmail.

"Get a Row" for google sheets has: File, Worksheet, and Row id. It seems that the Row id is the actual row number of the sheet. Yet the "Get a Row" step for Excel has the ability to give it a Key Column and Key Value. Why doesn't the Google Sheets "Get a Row" have those?

How else can I get fields (columns) from a google sheet? If the answer is to pull the whole table in with "Get Rows", please point me to some instructions on how to do that in a way where I can access my ClientEmail using my ClientID.

Thanks very much.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

The Row id field accept the unique identifier of the Google Sheet row, it is a string of code like "ab0d8f70f096482aace272794c61089f,2".

If you want to filter out rows with specified ClientID in ClientEmail column, you could use Get Rows + Filter array to find these rows, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-litu-msft ,
This is progress however I don't know how to retrieve the client email. The Dynamic Content doesn't show the fields in the google sheet table. Here is my sheets table and my flow and the dynamic content. Can you help? Thank you!

Here are the Dynamic contents available from the body of the "Email NewFormat Notice" step

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

You could try to use an expression to extract the Email address:

item()?['Email_x0020_Address']

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Solved! WELL, MAYBE NOT. SEE BELOW. IT STOPPED WORKING.

Thanks for your help @v-litu-msft. I figured out my problem. Row 1 in my sheet was hidden and served other purposes. The "Get Row" and "Get Rows" for google sheets requires the 1st row to be the headers (column names). Once I corrected that the steps worked as expected and I could nicely see the field (column) names.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is getting very frustrating. Sorry folks. This solution no longer works for me.
Now when I try to use "Get Rows" or "Get Row" on a google sheet the column names no longer show. Even if I don't have any hidden rows and the header row is row #1.

Can anyone please explain how I can accomplish the simple simple (seemingly simple) task of pulling a row from a google sheet matching a criteria? All I am trying to do is get a Client's email from my client profile table when given the client ID. This shouldn't be so difficult. Sorry I'm frustrated. In excel and google sheets this simple function is vlookup(). How do I do that in power automate?

The "Get Rows" and "Get Row" steps do not allow me to filter by columns in my table. WHY NOT?

Thanks.

Was this reply helpful? Yes No