Forum Discussion
Getting updated data from a Microsoft Form's SharePoint Excel Repository using VBA.
piper977 , could you please share bit more details. Did you use desktop flow or cloud flow and which exactly steps. At least with cloud flow I was not able to push syncing the file.
I had to set up a cloud flow. The main aim is to use a dummy step that opens the SharePoint file which starts the sync between SharePoint and Excel Online.
Roughly, I arrange my text editor and command line how I describe here.
Any type of trigger, manual, scheduled or another type, can be set in Time Machine.
Step: Go to the Excel file in SharePoint, then use the “Get file content” or “Get file metadata” action.
That step makes SharePoint automatically update the file with the newest Form information. Once you finish these steps, run your VBA on the desktop using the new file.
It does not solve everything, but it helps me a lot.
piper977 , thank you, but that doesn't work in my case. Run the flow with step you mentioned. In a while Power Query this file, it is not synced. Will try to play more in a while.
Yeah, I ran into the same issue before, "Get file content" works in theory, but sometimes SharePoint doesn’t actually refresh in time for Power Query. What helped me once was chaining a “Get file content” with a slight delay (using "Delay" or "Do Until" with a dummy check) before kicking off the desktop-side process. Not a perfect fix, but seemed more reliable in my case. Also had this open in another tab while tweaking it
