How to populate a specific sharepoint column with specific excel cell that is being populated from MS Form

(0) Share

Report

Posted on by cassonori

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
cassonori 2 on at

Like (0)

Report

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.
https://powerusers.microsoft.com/t5/Building-Flows/MS-Form-multi-response-question-to-SharePoint-List-Issue/td-p/1496737

Was this reply helpful? Yes No
v-liwei-msft on at

Like (0)

Report

Hi @cassonori ,

Could you please provide me with a screenshot of the flow and details of the error reported?

Best Regards,
Levi

Was this reply helpful? Yes No