Hi does anyone know how to tell Power Automate to check if an item exists in a SharePoint list and then update the remaining columns of the list accordingly?
I have a SharePoint list where it will record all the responses of users' training details via MS Form:
Date of form submission
Participant Name
Course Name
Course Provider
Course Address
Approval Status
etc
etc
Post Course Achievement
Flow in brief:
- Form sent,
- approval sent,
- approve,
- details recorded in sharepoint,
- after training end date to send for email reminder to participant to input post course achievement where a separate form link is stated in the email reminder
- Participant then send responded in the post training form.
It seems that the flow is looking for Column "Course222" but i am checking for the data "Course222" in column "Course Name".
Everything works until the point on the identification part. How to link the post response to the initial response so that the post course achievement can be updated?
I have already tried to connect the post response course name = initial response course name and
post response name = initial response name
so that this can be the unique identifier to match.
But seems like it doesn't work.
Please advise. Thanks !
