topic Re: Automate Microsoft OneDrive file reading from in Qlik Automate

Automate Microsoft OneDrive file reading from

Isabelaa_123 — Fri, 18 Nov 2022 12:32:52 GMT

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

Re: Automate Microsoft OneDrive file reading from

Madhushree_BP — Mon, 21 Nov 2022 06:28:29 GMT

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

Re: Automate Microsoft OneDrive file reading from

Madhushree_BP — Mon, 21 Nov 2022 06:31:31 GMT

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-Sharepoint-when-using-the/ta-p/1928521

https://community.qlik.com/t5/Official-Support-Articles/How-to-Getting-started-with-Microsoft-Onedrive-Sharepoint-in/ta-p/1838316

Thanks,

Re: Automate Microsoft OneDrive file reading from

Isabelaa_123 — Thu, 24 Nov 2022 10:27:15 GMT

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 ?