Connecting excel in MS team

[moy]

Hi everyone

I need some help connecting to multiple excel spreadsheets hosted on MS Team. 

Option 1: I have read thru this link (Connect alteryx with Microsoft Teams - Alteryx Community), but it is way too complicated and probably won't work on the corporate laptop. 

Option 2: On a diff link - I tried creating a mapped drive (How to Map a SharePoint Online Document Library as a Network Drive using PowerShell? - SharePoint Di...), but that didn't work either (Windows explorers does not like the URL)

This could be a good way. 

If anyone has done it - could you share how you have done it, please?

Option 3 (preferred): I tried adding the SharePoint link directly in the alteryx Input component on a diff link, but it still didn't work. This one will be good as well if someone could help.

Also, is there a way to connect multiple excels (30+, each with 3 tabs) in one go? 

Thank you all in advance. 

[terry10]

Do your 30+ Excels have the same format?  And are the located in the same folder?

[terry10]

Make sure you have synced your mapped network drive and use backslashes.  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/File-Paths-and-Alteryx/ta-p/847200

[VojtechT]

Hi @moy , depending on the version of Designer you're running you could also try and use Sharepoint Files connector. 

Vojta