Forum Discussion

bloffet's avatar
bloffet
Frequent Visitor
8 years ago
Solved

Loop through a SharePoint list and build one query per item in that list.

Hi all,   I have as a need to connect to muliple SharePoint sites and look at the "Pages" library of each of those sites to perform certain actions/reporting in Power BI.   The way I'm doing this...
Need Help
  • Michal_cwiok's avatar
    Michal_cwiok
    8 years ago

    It is possible. You can access those URLS using Custom Functions. Moreover, you can make it conditional i.e. if url contains some text, apply function1, otherwise function 2. I tried to cover it here and here.

     

    If you paste more info, perhaps we can help you with writing such a query.

     

    Thanks,
    Michal

Michal_cwiok's avatar
Michal_cwiok
Icon for Resolver II rankResolver II
8 years ago

It is possible. You can access those URLS using Custom Functions. Moreover, you can make it conditional i.e. if url contains some text, apply function1, otherwise function 2. I tried to cover it here and here.

 

If you paste more info, perhaps we can help you with writing such a query.

 

Thanks,
Michal

bloffet's avatar
bloffet
Frequent Visitor
8 years ago

Hello Michal,

 

Thanks a lot for your useful answer.

I think I'll be able to build what I want, if not I'll come back to you.

 

Have a nice day

Benoît