Forms in Sharepoint lists and overwrite existing entries

Copper Contributor

Hello everybody,


we plan to create a form, this should enter data into a sharepoint list, so far it works.
But we're also looking for the possibility that if the same user replies to the form again, the existing entry will be overwritten or added to.

 

Does anyone know if this is possible?

Thanks

2 Replies

@Kevin_INP it can be done with a flow in Power Automate which would get all the items from the SharePoint list, then in a condition check if the email address from the form is in the list. If it is it would update the item, otherwise it would create a new item.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Do you have an exemple of a flow that would include a control?

As of now I have:

- When new answer in flow

- Obtain details

*control?

- Create item in list 

 

(sorry for the translation my microsoft is in french)