Forum Discussion
Connecting to SP-Lists from multiple SharePoints - adresses comming from one Source List
Most Valuable ProfessionalYeah, what you want to be searching for is the "invoke a custom function" feature. That will let you do a series of steps on rows in a query. I believe this particular feature will not let you schedule refresh (some sort of error about dynamic content), but it's not something I use super often so perhaps someone else can chime in there.
An alternative would be to parameterize the URL and/or list ID that you're connecting to in the query - you just add a new parameter, and replace the string for what you're connecting to with the parameter name. That would let you "hot swap" things, but you'd still be duplicating queries and appending that way.
What you might consider is shifting the architecture of how you're storing the data to be more flexible and not so much based on creating a ton of lists, e.g. use a single Dataverse table with role-based access or something like that (though this will typically be Power Apps premium licensing).
Hey Christine,
thx for the reply!
invoke custom functions and parametrization is indeed not something, that I am very skilled in so I would require a bit more guidance here.
the centralization of data might be an option for the future as to the data there is anyway to a powerapp connected... which is still another story, that needs to be investigated... anyway today the setup is as it is.
I thought aswell about an option to amand the tables not with powerquery but outside of powerBI... eg. with powerautomate in some kind auf summary sharepoint list... not sure if that is possible but basically it would be the same issue there. The coleague who owns the subject has no specifc licenses and I'd like to eneable him to manage the entire subject.
BR
Jens
- christinepayton
Donnnnn't copy them with Power Automate, you'd have to build the flow to update the items every time something changes or they'll get out of sync. It'll just make your problem worse lol.
It doesn't even necessarily have to be Dataverse, you could use a single SP list, but you don't want to be storing very similar data in a ton of disparate lists like that. It might be OK now, but like 2 years down the road you will be wishing you hadn't.
Haha... agree
however, that it is unfortunately not in my hands. Will discuss with my colleague about the architecture of the datasource.
thx a lot anywaycheers Jens
