Forum Discussion
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 which i created some tables containing filtered date from sheet 1. - Each table was given a name.
I created lists based on each table on worksheet 2 of the spreadsheet.
So, for exampe, worksheet 1 of the spreadsheet holds all the support given to staff needing help. There is a table on worksheet 2 that shows how many staff were helped by a trainer or a champion.
The list based on this table holds the following
Digital Trainers 100
Digital Champions 2
From the list i have created a quick chart to visualise the information
My problem is - when a new form is completed the results are added to the spreadsheet - this works fine.
The tables on worksheet 2 update as a new form is completed - this works fine
I need the lists created from the tables on worksheet 2 to update when a new form is completed - at the moment they don't..... How do i get a list to update/refresh when a new form is submitted - is this a power automate task??
- You would need to trigger a Power Automate Flow to do this task. Microsoft Forms automatically posts data to the spreadsheet but doesn't update anything else. You could have a "When a Form is Submitted" trigger to read the data and then Create / Update a SharePoint List item.
