Refresh Excel file in SharePoint

[Uthraa_S (Uthraa)]

Hi,

Please check if the file is synced to local . If so you can directly access excel form that folder and use excel activities. To refresh excel you can use Refresh Excel Data Connections activity . Please check the below thread

Background process: Is it possible to refresh an excel worksheet table that is connected to sharepoint?

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 i…