Automate Microsoft OneDrive file reading from

[Isabelaa_123]

Hello,

I have problem. I need conntect to Onedrive my team and downloand list email recipients. List is file xlxs, which have many sheets, but one of the sheets is just this list.

I need help:

1.  what name to enter?- name file  or path file ?

2. Ineed to be connected to my onedrive or onedrive my team ( I can see all file from my Onedrive)

Can someone describe the path of my problem? Step by step

[Madhushree_BP]

Hi @Isabelaa_123 ,

From the image shared by you, I can see that you have connected to Microsoft one drive.

Regarding the path If all files are in the main directory then simply you can use the name of the file, but if your file is under any folder then you need to provide the entire path.

For example, if you have a folder named Test and a file named Testing.txt under the folder Test then the path would be ./Test/Testing.txt

Let me know if this helps you.

Thanks,

Madhushree

[Madhushree_BP]

Hi @Isabelaa_123 ,
Please check the articles shared below which may help you.

https://community.qlik.com/t5/Official-Support-Articles/How-to-connect-to-Microsoft-OneDrive-Sharepo...

https://community.qlik.com/t5/Official-Support-Articles/How-to-Getting-started-with-Microsoft-Onedri...

Thanks,

[Isabelaa_123]

Ok, I conect with my onedrive.  What blocks should I set, to get to the list of recipiets, which is on Onedrive in format xlsx. Its ok ?