Forum Discussion

Jokin Piquer Beruete's avatar
Jokin Piquer Beruete
Copper Contributor
Jun 07, 2018

Referencing Excels Online - Form results

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!

  • Alan Marshall's avatar
    Alan Marshall
    Steel Contributor
    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.

Resources