Hello all,
Here is a full description of what I'm trying to build a flow to do and what I have tested so far:
1. User fills out MS form
2. Form results auto-populate into excel file (this works fine, but would be better if I could put it into a sharepoint list I believe)
3. 1 specific cell of the results populates into Sharepoint specific cell
Basically, I created a selection matrix, and the final question is a "sum of the numbers" (note, this is currently not an auto-populated number, would be great if I could figure out how to place a "number/score" value on each selection of the form and then have it auto generate). The results from the form populates into an excel spreadsheet, which I have a powerauto flow that works fine.
What I NEED to figure out, is how to pull the specific "sum of the numbers" answer into the correlating line on sharepoint. I was hoping to use the Topic name, which is present on both the Form, Excel and Sharepoint list identically, to be the "callout indicator" of which Sharepoint list row, to populate the result from the excel/form question.
