Forum Discussion
Connecting to SP-Lists from multiple SharePoints - adresses comming from one Source List
Hello, I have a set of Sharepoint-Lists, that I want to connect to to and amand afterwards. Establishing the connection on by one is clear for me. Since the amount of lists is evolving over time ...
ppm1
Solution Sage
Solution SagePlease see this article. You can adapt the M code there to create a function to pull the data from multiple lists starting from an input table with site url and list name (if the lists have the same fields).
Updated – Get SharePoint List Data … Fast – Hoosier BI
Pat
Hi Pat,
thx for the link,
when I understand the code correct, it returns the content of the SP list through another way then the standard SP connector,
My problem is, that I have no idea, how to create the respective function in order to use the hyperlinks in the adressbook to connect to all sharepoint lists included.
Basically I've never created a custom function in M 😞
BR
Jens
