cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Memorable Member
Memorable Member

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

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.

 

 

View solution in original post

16 REPLIES 16
Microsoft
Microsoft

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.

 

 

View solution in original post

Great thank you, @Jaden 

 

I done edit my flow, and this work well.

 

Best Regard,

Yoshihiro Kawabata

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
Not applicable

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

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

New Member

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.

 

Base64 Random

 

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. 

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

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:

RandomID_1_2018_01_09_ 18-17-39.jpgRandomID_2_2018_01_09_ 18-17-39.jpg

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

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. 

Thanks.

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
Not applicable

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

@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!

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?

Regular Visitor

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (38,241)