Updating row in Excel through flow - Days off Database

[Kosynod]

Hi there,

I'm trying to connect some data from Forms to Excel.

Basically, I want to create a day off system. I already manage to synchronise the Form with the Excel, so that the responses are automaticly registered in the Excel Table.

Now in a different sheet, I want to keep track of the people registered.

Every time that someone uses the Form, they have to add their unique ID code. I want to create an automatization, when this code appears for first time, a new row will be added in the table, but if the code already excist, then simply update the row with the new data.

Thanks for the help.

[v-litu-msft · Accepted solution]

Hi @Kosynod,

You could refer to the following steps to create your Flow:

Step 1. Get the response details to retrieve the unique ID, put it in the List rows present in a table action to find the row with the unique ID.

Step 2. Use the length function to return the length of rows.

-If it is equal to 0, add a row in the table

-If not, update the row with unique ID.

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