Updating column in SharePoint List row using forms submitted by different users
I’m a novice at PowerAutomate. I’ve built two Forms. First will go to a student. Student fills out information including a school official email address. Once submitted, one Flow will use the school official email address to send a form to the school official. A second flow will load information into a SharePoint List. Both forms (student and school official) ask for a student ID number.
When the school official submits their form I’d like to build a Flow that updates the row submitted via the student’s form with select information from the school official. Ideally, I’d be able to use the student ID (StarID) in the Flow to connect everything (ie if the StarID is the same please do this . . .). The only data that I want added to the student row is the recommendation (far right column of screenshot). School Officials will recommend “Yes” or “No.” All other data you can see in the screenshot is loaded in when the student submits their form. After the school official submits, the flow would look to see if there is a StarID in the list and only add the data from the recommendation. Any help would be more than appreciated.
I’m a novice at PowerAutomate. I’ve built two Forms. First will go to a student. Student fills out information including a school official email address. Once submitted, one Flow will use the school official email address to send a form to the school official. A second flow will load information into a SharePoint List. Both forms (student and school official) ask for a student ID number. When the school official submits their form I’d like to build a Flow that updates the row submitted via the student’s form with select information from the school official. Ideally, I’d be able to use the student ID (StarID) in the Flow to connect everything (ie if the StarID is the same please do this . . .). The only data that I want added to the student row is the recommendation (far right column of screenshot). School Officials will recommend “Yes” or “No.” All other data you can see in the screenshot is loaded in when the student submits their form. After the school official submits, the flow would look to see if there is a StarID in the list and only add the data from the recommendation. Any help would be more than appreciated. Read More