Hi. This is my first time using PA so any help is really appreciated.
I have a programme MS Form that collects evaluations from trainees. It sits in our PMO team Sharepoint and currently has approx 960 responses going back to Jan 25.
Recently the training project it relates to has had its own Sharepoint set up and I've been asked to import responses from the form to this new SP as a List for trainers to review their own evakuations directly instead of me having to email a file each week.. I can't transfer the form as the link has been publicised across the company and is currently embedded in multiple documents etc.
So, following copilot guidance, I've set up an auto 'Get New Responses' flow which works but it only gets the first new responses after it was first turned on ie response 953 +. This works fine except the date is brought across as mm/dd/yyyy instead of dd/mm/yyyy. I need to fix this for reporting.
Secondly, I've tried to set up a second flow that pulls in the old responses up to 952 from a downloaded copy of the excel file, formatted as a table.
This only seems to pull up to 256 responses, it duplicates them each time I try to rerun because of date format errors. I tried playing with the format expression and mistakenly used utcNow and it pulled them all across but with today's date for all of them instead of the submission date. I've tried to undo this but can't get the format to work correctly with the date.
I have screenshot here but can't access Reddit in work so can't paste anything directly to this message.
Any advice?
