Ok i have a sharepoint list with archive data about user performance (helpdesk environment). A flow runs when an item is added to the archive list which also adds the item to an excel document. I then have graphs inside the excel document based off that data. I want to display that graph as a web part and have that graph update when a new item is added to the excel sheet. It needs to be a live graph. Is this possible? If not are there any alternatives?
You don’t need to add items to an Excel file using flow.
Add connection to SPO list in a Excel file and upload the excel file to SP Online library. Configure Refresh control for this data connection. We can refresh data automatically when opening the file or configure it to refresh automatically every specific minutes. After that, you can display the data using Excel Web Access web part.
Create a excel file in client.
Get external data from ODate Date Feed.
Select the lists which you want to display and click Next.
Enter the information such as file name for this data connection and click Finish.
View this data as you want in the workbook.
Edit this data connection properties, set the refresh control to refresh data when opening the file or other refresh options as you want.
Save the file and upload the file to a SP Online library.
Display the data using Excel Web Access web part.