cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Microsoft
Microsoft

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

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
Highlighted
Microsoft
Microsoft

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

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

Highlighted
Memorable Member
Memorable Member

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

Great thank you, @Jaden 

 

I done edit my flow, and this work well.

 

Best Regard,

Yoshihiro Kawabata

Highlighted
New Member

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

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.

Highlighted
Anonymous
Not applicable

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

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

Highlighted
Advocate IV
Advocate IV

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

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

Highlighted
New Member

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

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. 

Highlighted
New Member

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

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

Highlighted
Kudo Kingpin
Kudo Kingpin

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

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

Highlighted
New Member

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

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

Highlighted
Kudo Kingpin
Kudo Kingpin

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

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. 

Highlighted
New Member

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

Thanks.

Highlighted
New Member

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

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?

 

Highlighted
Anonymous
Not applicable

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

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

Highlighted
Regular Visitor

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

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

Highlighted
New Member

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

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?

Highlighted
Regular Visitor

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,441)