cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft
Microsoft

Excel Update Row, Row Id issues

https://flow.microsoft.com/manage/environments/Default-72f988bf-86f1-41af-91ab-2d7cd011db47/flows/84...

 

I'm having several issues with the Row Id field in Excel Update rows.

 

First, when I select the Row Id field, the dynamic content pane pops up for both the Row Id field, and the ID field (column name in table). I can work around this (sort of), by not specifying a table before selecting the Row Id field or entering a text value, but this is a workaround only, and pointless because of the second problem.

dynamic content overlap.JPG

Second, I am using a loop to find the row I'd like, since ODATA filtering is not enabled on the Excel connector yet. However, I cannot access the __PowerAppsID__ of the current row in the loop, as I'd expect.

 

Third, having assigned a dummy value to the id, I cannot edit the value now, the box is displayed as grey.

dead id field.JPG

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

I've found a workaround for now.

Since I can't put a WDL function in the RowId field, I used a Compose action with the same command, then used the Output of that for the RowId.

 

Screenshot for anyone else who needs help with this:

 

Note that when I reopened the Flow, Compose changed "@item()['__PowerAppsId__']" into a dynamic content tag, but __PowerAppsId__ still doesn't show up in the dynamic content selection box.

 

flow-excel-getrow-usecompose.JPG

 

View solution in original post

Checked today and the Row Id field is available in the Update Row Action. Must have been fixed at some point in last 3 weeks.

View solution in original post

11 REPLIES 11
Community Support
Community Support

Hi Michowl,

 

About #1, I have a table with a column named ID, when I create a similar flow with you, I get the same issue, the dynamic content type pops up for both the Row id filed and the ID filed when I click the Row id field. Then I change the column name of the ID filed to TestID, then the dynamic content type pops up only when I click each field. Please try to change the column name to see if it works.

 

About #2, I have seen a thread about Row id issue, hope it can be a reference for you:
https://powerusers.microsoft.com/t5/Flow-Forum/What-is-quot-Excel-Get-Row-quot-action-s-quot-Row-id-...

 

About #3, it seems that once we fill a custom value in the Row id field and save the flow, we cannot edit the field. About this issue, I would suggest you submit an idea at Flow Ideas Forum, so it might be taken consideration for future releases.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Mabel,

 

The reference you provide for #2 explains what a RowId is, and I understand that aspect. However, it needs to be available for reference in Update row for the current iteration of a loop.

 

In the scenario I described, I am Looping through a list of Rows. The Update Row action requires a RowId to lookup the row. I would like to use the RowId of the current row in the iteration. However, I am not able to select the RowId from the dynamic content pane.

 

#1 and #3 are bugs, not feature requests. I've submitted them as such.

Hi Michowl,

 

Thanks for your reply. About #1 and #3, I would also collect and report these issues on my side. About #2, I would reconfirm this issue and update you once I get useful information.

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I Guess I'm facing a similar problem, but I'd like to understand it better.

I'm aiming to create a Timing Report that "flows" outlook calendar information to an approriate excel table.

 

What I have in mind is composed of 2 flows.

1. Every time an item is created in Outlook calendar a corresponding line is created in excel reporting table

EventID StartTime - EndTime - Subject - Collaborators(email addresses) - 

 

I have no issue in doing this, I can then report the infomation in power BI correctly. I'm using tag in subject like [Meetings] to bucket up info for may reporting.

 

The issue is the 2. point

2. Every time a previuolsy created event is modified or delated I'd like to retrive the corresponding row in my excel table and change the information accordingly.

 

It seems is very difficult to use correctly the __PowerAppsID__ info in an effective way in flow.

I tried even somethig like

"If Event is modified in outlook

FOR each Line in the Excel table compare Event ID EXCEL  to EVENT ID Outlook /*Is not __PowerAppsID__ 

If equal update row...

"

But again Update Row action in flow require the __PowerAppsID__ ID and I don't have any idea how to retrive it correctly in my usecase.

 

Any suggestion would be more than welcome.

 

 

Br

Filippo Persia

I think it is a bug in Flow Excel actions.

 

I think it used to work. In this thread from August user yoshihirok says he could get his flow working with Excel and __PowerAppsId__.

 

It still works with Flow Google Sheets actions, so a workaround could be to use Google Sheets instead.

Unfortunately, in an enterprise scenario, Google Apps is often not an acceptable scenario.

This issue persists.

 

Scenario:

1. Get Rows from TableFoo in FooBar.xlsx

2. Apply to each (value from GetRows)

    2.a. Do some process using cells from current row

    2.b. Update Row: Set a flag value in Column "Processed" to "true"

 

To use update Row, I need the Row id. This is what I'm seeing:

 

flow-excel-getrow-noid.JPG

 

I'd also be happy with a simple explanation of how to access the properties of the current item in a loop.

I thought i could use:

@item().__PowerAppsId__

 

But when I put that in the id field is is URL Encoded so instead of interpreting it as the id field of the current item in the loop,

it gets re-written as %2540item%2528%2529.__PowerAppsId and send in place of the actual Id

 

I've tried enclosing the expression in ""s and {}s to no avail.

I've found a workaround for now.

Since I can't put a WDL function in the RowId field, I used a Compose action with the same command, then used the Output of that for the RowId.

 

Screenshot for anyone else who needs help with this:

 

Note that when I reopened the Flow, Compose changed "@item()['__PowerAppsId__']" into a dynamic content tag, but __PowerAppsId__ still doesn't show up in the dynamic content selection box.

 

flow-excel-getrow-usecompose.JPG

 

View solution in original post

Genius - it works! Thank you!

Checked today and the Row Id field is available in the Update Row Action. Must have been fixed at some point in last 3 weeks.

View solution in original post

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!

Top Kudoed Authors
Users online (27,686)