Getting sharepoint Excels on a cloud robot

Hi, I am looking to build a cloud based robot that I need to read an excel file from a sharepoint location. How can I get the robot to read this file as it is not stored locally on any machine as the robot is cloud based.

Thanks, Alex

Hi @aquinn ,

I believe you would require to install Microsoft 365 Package and check the activities present in it as it provides activities related to OneDrive, Sharepoint, Excel, Planner etc. :
image


this is all i see

@aquinn ,

Try it in the below manner :
image

I’ve got this now, do you know how I can get an excel file from sharepoint using this?

@aquinn ,

If the Authentication/Setup of the Microsoft 365 is needed, would recommend to check the below Video and similarly If the requirement is to download the Excel sheet, the same is also present in the below tutorial video :

However, We could also directly read the Excel sheet in Cloud using the Excel activities in Microsoft 365 package once the it is setup and the Authentication details are known.
image

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.