Excel Update Row, Row Id issues

[michowl]

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.

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.

[v-yamao-msft]

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

[michowl]

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.

[v-yamao-msft]

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

[Anonymous]

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]

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.

[michowl]

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

[michowl]

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:

[michowl]

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.

[michowl · Accepted solution]

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.

[powro]

Genius - it works! Thank you!

[michowl · Accepted solution]

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.