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