You’re offline. This is a read only version of the page.
2
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.
Hi @cassonori ,
Could you please provide me with a screenshot of the flow and details of the error reported?
Best Regards,
Levi
Hi Anna, I have a flow which feeds the MS Forms response into a MS Excel spreadsheet. There are 7 questions on the form, with the last one being a multiple choice. I need the answer from the last multiple choice question to be "recorded" on the sharepoint list in a specific row/column, using the Name (Which will be the same on the Sharepoint List (step a) and being input into the form (step b), to populate the choice from question #7 on the form into the sharepoint list.
I was using this link to help me, but I am stuck on the "Select" step, it doesn't seem to work correctly for me and keeps giving me errors.
@cassonori so you are looking to update specific item in SharePoint list, and the value you need to update is from the MS Form? Do you already have flow which triggers on MS Form response, if yes, then add/update item from SharePoint with the form data.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
