Hi Everyone, I need some assistance in creating a Power Automate flow to create an Item in a SharePoint List when a MS form is submitted. A staff will mark certain tasks as complete using a MS form. This tasks in created as a choice column in SharePoint and need to be updated as [Selection 1]; [Selection 2]; [Selection 3] etc.
I also want to make sure every time the form is submitted the PA flow should update the specific item that is completed by a unique staff only so it does not create multiple rows of the same individual. I am unable to find a solution so the PA flow creates/updates Item and only adds the choice selected in the particular column.
1. The below form get submitted at different time time intervals when the task has been completed.
2. The PA condition is to check if the Last Name of the Staff exists in the register, If Yes, the flow will update the Item instead of creating a new Item.
3. The flow should create an item or update the item in the below list with out multiple entries of the same staff.
