Sep 23 2020 08:32 AM
Hello,
I have a sharepoint list that stores the tasks of my team. Now I want to create a burndown chart for this list and embed it on a sharepoint page. The chart webpart does only provide circular and bar chart. So I decided to create a excel sheet with a data connection to the sharepoint list.
In this excel sheet I can create a burndown chart. Now I want to put the chart into a sharepoint page. But I am not able to refresh the data. There comes an error "error by refresh the external data".
Is there any solution for this problem? Maybe I can refresh the data by starting a flow every 3 hours or something else?
Sep 23 2020 09:58 AM
Hi @chhe5,
I'm afraid refreshing SharePoint data connection is not possible with Flow.
SharePoint PnP community have published an Modern Charts example.
https://github.com/pnp/sp-dev-fx-webparts/tree/master/samples/react-modern-charts
Is there anything useful for you?
I can also help trying this out, if you could just provide some example data.
Sep 23 2020 10:14 AM
My company looks away from the installation of community webparts. Unfortunately.
But when I run the excel sheet local on a network drive there is no problem to refresh the data from the sharepoint list.
If I upload it to a document library to place the chart by the "document viewer" webpart the refreshing of the data is broken.