Referencing Excels Online - Form results

%3CLINGO-SUB%20id%3D%22lingo-sub-201867%22%20slang%3D%22en-US%22%3EReferencing%20Excels%20Online%20-%20Form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201867%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20current%20situation%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20I%20have%20a%20Microsoft%20Form%20which%20sends%20the%20results%20to%20an%20Online%20Excel%20(A).%20This%20forms%20ask%20employees%20about%20the%20sell%20out%20of%20the%20day.%3C%2FP%3E%3CP%3E-%20I%20want%2C%20every%20employee%2C%20to%20have%20an%20Excel%20file%20(B)%20(online%20or%20offline%2C%20I%20don't%20care)%20where%20s%2Fhe%20can%20see%20a%20report%20with%20the%20latest%20sell%20outs%20and%20some%20other%20data%20as%20%25%20of%20target%20of%20the%20year%2C%20etc...%3C%2FP%3E%3CP%3E-%20I%20want%20this%20information%20to%20be%20filled%20automatically.%20So%2C%20summarizing%2C%20I%20would%20like%20to%20take%20data%20from%20A%20and%20reference%20it%20in%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20think%20is%20possible%3F%20And%20if%20not%2C%20do%20you%20think%20is%20there%20any%20workaround%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-201867%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202714%22%20slang%3D%22en-US%22%3ERe%3A%20Referencing%20Excels%20Online%20-%20Form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202714%22%20slang%3D%22en-US%22%3EUse%20Flow%20to%20take%20the%20data%20from%20the%20submitted%20form%20and%20then%20using%20an%20Excel%20connector%20to%20write%20it%20to%20a%20shared%20spreadsheet%20in%20SharePoint%20Online.%20You%20can%20create%20charts%20and%20pivot%20table%20in%20Excel%20and%20share%20that%20file%20or%20embed%20it%20on%20a%20SharePoint%20Page%20or%20tab%20in%20Teams.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello! :)

 

This is my current situation:

 

- I have a Microsoft Form which sends the results to an Online Excel (A). This forms ask employees about the sell out of the day.

- I want, every employee, to have an Excel file (B) (online or offline, I don't care) where s/he can see a report with the latest sell outs and some other data as % of target of the year, etc...

- I want this information to be filled automatically. So, summarizing, I would like to take data from A and reference it in B.

 

Do you think is possible? And if not, do you think is there any workaround?

 

Thanks!

1 Reply
Use Flow to take the data from the submitted form and then using an Excel connector to write it to a shared spreadsheet in SharePoint Online. You can create charts and pivot table in Excel and share that file or embed it on a SharePoint Page or tab in Teams.