Unanswered

Excel Online get value of a cell

(0) Share

Report

Posted on by HohesHaus

Hello there,

I have a problem with my Desktop Flow. First of all I have a Excel Liste in my Sharepoint. There are Columns A B and C and rows 1 2 and 3. I want my desktop flow to get the Value out of A1 that is "Test". Though the action requires a "key value" and I have no idea what that is nor where I can get it. I'm using the command "Get Row".

Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

To use Get a row, you need to provide a column that is used for identification of which row you want, and then a value in that column. You cannot get a row by using an index using this action.

Instead, use List rows present in a table. This will return a list of all rows. You can then get the first one by using 0 as the index.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
HohesHaus 6 on at

Like (0)

Report
Copy link

Link copied!

Sorry I don't get it.
When I use List rows present in a table I get this
https://excelonline-gn.azconn-gn-001.p.azurewebsites.net/$metadata#drives('b%21ljO8BMlWTkO7InWCmh5ahnlOsjcWR5tFtEHJoialMCKDNSS5-ciuR6rY22Yw8Gz_')/Files('01L4WBF4FXNVC2TVC3QVAJPSVXCWMHDORP')/Tables('%7BF16E827F-6549-4DE0-A7C2-935CD4050D96%7D')/items

as result a variable.

By Get Row I told the command with "Key Column" in that it needs to search in Column A.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you use Get a row, you need to provide a value from the Key Column (in your case Column A) to filter the row you want to retrieve. It's not like it will retrieve a value from column A. It will filter all rows by the value in column A that you provide as input. So, that won't work for your use case.

Can you share a screenshot of the result of List rows present in a table instead of a URL?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
HohesHaus 6 on at

Like (0)

Report
Copy link

Link copied!

Sure here you go

12

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The .value property will store an array of rows. Use that.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
HohesHaus 6 on at

Like (0)

Report
Copy link

Link copied!

Sorry for still not getting it. That's my value for List rows present in a table.value . I struggle with it, what to do with this. It looks like that it gives me an CSV form.

I don't get the logic behind the Office 365 connectors. It's so **bleep** easy to get cell value from Desktop Excel, but as soon as I try to use the online connectors I fail all the time.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It's not CSV, it's JSON. You get an array of objects, where each object is a JSON element with key:value pairs. The keys represent the column names in Excel.

So, if you want to get the "ItemInternalId" value of the first element, use %GetItemsResponse.value[0]['ItemInternalId']%. The 0 in there indicates the item index in the list. It's 0-based, so you need to use 0 to get the first item. And then you can just use a column name to get a specific value.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No