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

[yoshihirok]

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

[Jaden · Accepted solution]

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.

[yoshihirok]

Great thank you, @Jaden 

I done edit my flow, and this work well.

Best Regard,

Yoshihiro Kawabata

[gmkafafi]

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.

[Anonymous]

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

[Anonymous]

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

[chabader-jarvis]

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. 

[juanriher]

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

[ErichH]

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:

[KrutikaSuchak]

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

[ErichH]

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. 

[KrutikaSuchak]

Thanks.

[Ndmesser1]

Does the  "__PowerAppsId__" column still get added automatically because its not doing that for me? I'm trying to figure out what Row ID is?

[Anonymous]

Hi. Did you get a solution? I cant find the "__PowerAppsId__" column as well. 

[rbbi]

@Anonymous and @yoshihirok  I found that in the Excel action "List rows present in a table" there is a field added by Flow called ItemInternalId that you can access like this ...

item()['ItemInternalId']

It gives a GUID-like value e.g. ccc23c55-5d94-4764-802a-3e789a9ece5e

Curiously, after saving, closing and going back into Edit, this appears as a GREEN field expression, just like other fields in the table, but it is not a field in the table!

[Rqamar]

I am having the same problem - I can't figure out how to get the "Row ID" for a flow. However, I don't see any new column with the name you described. 

How do I get the new column to appear?

[rbbi]

hi @Rqamar ,

From memory I just added the code and it worked, even though ItemInternalId does't appear as a field in the table. It's like a hidden field that the code can access. After you add the code and save the flow, you may see the field in the list as I described.

good luck

[drewnoakes]

The "Get a Row" feature doesn't seem to work if the table was created from entire columns (i.e. you clicked column headers, then made a table). Changing the table to be based on a finite range of cells seems to have fixed it for me.

[Anonymous]

I can confirm that I have applied this and it fixed a whole lot of related issues, for get update and delete. 

Thanx for the update.