operations with Sharepoint lists

[Anonymous]

Hi guys,

How can I combine Sharepoint lists? I try to explain you better. I have a Sharepoint list where all the check-in users are signed in and each user, has co-workers (CO-WRKG in the screenshot below) under him. I am wondering if it is possible, that when I click on the filter "SIGLA" (rectangle red in the screenshot), I am able to see the co-workers only and not all the users. I specifiy that all the users are stored in a sharepoint list and the co-workers in another Sharepoint list. So, my idea is to combine these lists. Any comment, clarification and idea is very much appreciated.

Many thanks

[collinq]

Hi @Anonymous ,

I am not sure that this is necessarily a Sharepoint specific issue.  In my mind, the easy solution is to bring them into your Power BI report as two lists and then you can just combine them (append) into one query.