Forum Discussion

Kevin_INP's avatar
Kevin_INP
Copper Contributor
Feb 25, 2022

Forms in Sharepoint lists and overwrite existing entries

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

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    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

    • JustineD's avatar
      JustineD
      Copper Contributor

      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)