So I’m trying to see if it’s possible to refresh an excel spreadsheet that has a table that is connected to a sharepoint list, as a background process? I’d like to take the refreshed information and populate it into a queue for processing.
I currently run a foreground process that runs a refresh macro in the spreadsheet and then it reads the updated info and adds it to a queue. But it occupies a runtime doing this.
I know I could use a power apps license to have an api anytime the sharepoint is updated to add the info directly to the orchestrator queue. But we don’t have any power apps licenses.
So yea just seeing if it’s possible by doing it with a background process instead of a foreground process.
You can use the Offcie365 Official or the sharepoint activities to directly read the sharepoint data
Alternately, you can run macro as well to get the data by setting excel processing to automation mode which wont open excel, but yes refresh of data will be little slow. So I would suggest use sharepoint activities instead
Interesting. I’ll have to check out the sharepoint activities.
Do you know though if they can be ran in a background process type as opposed to a foreground process?
so I followed the instructions in this video for setting up the Office 365 scope. but I am getting an error when performing the Get List Info activity.
Is there something I am missing in order to read the sharepoint list info?