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

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

Re: Excel Update Row, Row Id issues

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

Microsoft Employee

Re: Excel Update Row, Row Id issues

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 Team
Community Support Team

Re: Excel Update Row, Row Id issues

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.
Microsoft Employee

Re: Excel Update Row, Row Id issues

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.

Community Support Team
Community Support Team

Re: Excel Update Row, Row Id issues

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

Re: Excel Update Row, Row Id issues

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

powro
Level: Powered On

Re: Excel Update Row, Row Id issues

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.

Microsoft Employee

Re: Excel Update Row, Row Id issues

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

Microsoft Employee

Re: Excel Update Row, Row Id issues

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

 

Microsoft Employee

Re: Excel Update Row, Row Id issues

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.

Microsoft Employee

Re: Excel Update Row, Row Id issues

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

powro
Level: Powered On

Re: Excel Update Row, Row Id issues

Genius - it works! Thank you!

Microsoft Employee

Re: Excel Update Row, Row Id issues

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,911)