You’re offline. This is a read only version of the page.
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
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.
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.
hi @Anonymous ,
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
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?
@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 ...
Share
Report
All responses (
Answers (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!
Hi. Did you get a solution? I cant find the "__PowerAppsId__" column as well.
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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
