Forum Discussion
Help - new to sharepoint and power automate
Help... I'm new to sharepoint I have a spreadsheet in my sharepoint site that is populated by PowerAutomate when an MS Form is filled in. I added a second worksheet to the spreadsheet on...
shawn_fielding
Hi Shaun - thanks for replying..
I've confused myself here.. and just had another look
I have a microsoft form. The spreadsheet for the form is on the sharepoint and populates when the form is completed.
I did a list using a flow to see how that would work as i have only just started to use sharepoint.
On the spreadsheet that forms produces, i created a second worksheet and on there created some summary info from the main page - I labelled each one of those as a table.
I then created a list for each of the summary tables and used that list as the source for the quickcharts on the sharepoint page -
Looks good but as more forms are completed the lists and the charts do not update as i thought they would
So, I am not a quickchart expert at all, but I do think it takes a manual update as far as my research shows. But it seems there is a flow step that you can use to create a new chart when an item is updated. Here's a bit of documentation about what you can do with Power Automate and quickcharts. https://learn.microsoft.com/en-us/connectors/quickchartip/
Excel should update its internal charts by itself. I am not sure really what would be going on there. I'm sorry I could not be more help.
Excel should update its internal charts by itself. I am not sure really what would be going on there. I'm sorry I could not be more help.
- Thanks very much Shawn.. I will have a read at the documetation...
really appreciate you taking the time to reply
thanks
Ian