Answered

Update specific last row in excel

(0) Share

Report

Posted on by starchrys

I have a flow that list the rows present in a table and filters the rows if it has the same name as the inputted name. I need to check if the last of this filtered array has the column 'Issue Date' as blank, if it is, then update the row and place the new issue date on the blank cell.

The flow works up until the part of updating the row as I do not know what value to put in the key value.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @starchrys ,

The key column should be the id column you defined. This column is unique and required.

If your excel does not have this column, please create a new column for your excel table. Because if you want to update a record, you need to provide the identifier of the record.

Best Regards,

Wearsky

Was this reply helpful? Yes No
starchrys 44 on at

Like (0)

Report
Copy link

Link copied!

Hey @v-xiaochen-msft,
Thanks for the reply. I am confused how would I write the formula for the id column I defined?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @starchrys ,

It's up to you, it can be a number like 1, 2, 3, 4, 5... it can also be a guid.

Note that if you define an excel function for a column, it may behave strangely in flow. I suggest you enter the ID value manually instead of using formula/function.

Best Regards,

Wearsky

Was this reply helpful? Yes No
starchrys 44 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft,
My flow works if I enter the key value as the inputted name in powerapps like so:
But it updates the first row in the table that has this same name, how would I update the last row in the table that has this name?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @starchrys ,

It's impossible.

When there are multiple records in excel that satisfy a certain column equal to a certain value, it always updates the first record that meets the condition.

So creating an ID column in excel is an important thing.

Best Regards,

Wearsky

Was this reply helpful? Yes No