Hi all! Forgive me for being noob at this.
Recently, my company sent me for a crash course for UiPath. While the teachers are excellent and I learnt so much, my company gave me a project which involves me getting data from an excel sheet in Sharepoint.
The idea of this excel online file is when users key new information into it, it will get the latest data and input into a local excel template that i have, before converting that into a PDF and sending it out as an email.
My main concerns are:
How do i derive the latest info from the sharepoint? Would it be better to get the file locally or from the web, as sometimes the sync takes time.