What is "Excel - Get Row" action's "Row id" ?

(1) Share

Report

Posted on by yoshihirok

1,724

I want to use my Table's value on my Excel file.

My Table:

Table Name: "Table1"

Row 1 = Columns Name "Name", "Age"

Row 2 = Values "A", 10

Row 3 = Values "B", 20

I try "Row id" = 1, Faild

Body
{
"status": 404,
"message": "No row was found with Id '1'.",
"source": "127.0.0.1"
}

and also "Row id" = 2, Failed

Body
{
"status": 404,
"message": "No row was found with Id '2'.",
"source": "127.0.0.1"
}

What value do I set "Row id" ?

Regards,

Yoshihiro Kawabata

Categories:

General topics

I have the same question (0)

All responses (18)

Answers (1)

Verified answer

Jaden Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

Currently, the "Row ID" represents an ID which is different from the "Row Number", which you happen to be trying.

Once you create a connection to an Excel table, you will notice your table will now have a "__PowerAppsId__" column - that is where you find the ID for that row, that you can later specify in a Flow.

Was this reply helpful? Yes No
yoshihirok 1,724 on at

Like (0)

Report
Copy link

Link copied!

Great thank you, @Jaden

I done edit my flow, and this work well.

Best Regard,
Yoshihiro Kawabata

Was this reply helpful? Yes No
gmkafafi 6 on at

Like (2)

Report
Copy link

Link copied!

Hi Jaden. How would I go about specifying __PowerAppsId__
I see it in my table but it dosen't show up as dynamic ontent when editing my flow.

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

Like (3)

Report
Copy link

Link copied!

Hi @Jaden

Regarding "Once you create a connection to an Excel table, you will notice your table will now have a "__PowerAppsId__" column - that is where you find the ID for that row, that you can later specify in a Flow."

I have a catch 22 problem. How do I create a connection? The flow will not let me create a connection because of the original issue of not finding the row ID.

@gmkafafi, did you figure it out?

Thanks in advance

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

Like (2)

Report
Copy link

Link copied!

I'm having the same problem. I'm trying to create a Flow, but it needs a Row ID. How do I find that?

Was this reply helpful? Yes No
chabader-jarvis 8 on at

Like (3)

Report
Copy link

Link copied!

I don't know if it's the right way to go about doing this but I was able to copy the column from another table that had it.
The document that I was able to grab this from was a document I was using in Flow with an Insert action which seems to generate the __PowerAppsId__ column automatically. It seems that the Get/Update actions don't create the column automatically. You should be able to add this to your table manually.

The column title is: __PowerAppsId__
The row data for the ID looks like a random, unique 11 character base64 number. I was able to generate some using this tool.

I hope this helps. Once again, I don't know if this is the way you SHOULD be doing it but it's how it worked for me.

Was this reply helpful? Yes No
juanriher 2 on at

Like (0)

Report
Copy link

Link copied!

How I can use the "__PowerAppsId__" column, I conect the excel and this colum not show in dynamics option.

Was this reply helpful? Yes No
ErichH 322 on at

Like (1)

Report
Copy link

Link copied!

Here a flow only way to generate random IDs as a callable module:

Calculation method:
concat(variables('S_Temp'),substring(variables('S_CharArray'),rand(1,variables('I_Len')),1))

S_CharArray:
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_

HTTP Request Body:
{ "S_RandomRowID": "<Number of Random Characters>"}

Parse JSON output:
{
  "type": "object",
  "properties": {
    "S_RandomRowID": {
      "type": "string"
    }
  },
  "required": [
    "S_RandomRowID"
  ]
}

Flow:

Was this reply helpful? Yes No
Krutika S 13 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you get a solution? I need to access "__PowerAppsId__" to get a row id and pass it to the flow but not finding any solution to this.

Regards,
Krutika

Was this reply helpful? Yes No
ErichH 322 on at

Like (2)

Report
Copy link

Link copied!

easiest is to introduce a new column in the excel table and store in it your own unique RowIDs.
use those in GET ROWS statement and use advanced options to filter the RowIDs for specific values.
this will give you IDs to use in subsequent actions.

Was this reply helpful? Yes No