Power Platform Community Forum Thread Details

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.