Connecting excel in MS team

Question

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 Diary), 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.

VojtechT · Answer

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

Vojta

terry10 · Answer

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

terry10 · Answer

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