Forum Discussion

icsrit7's avatar
icsrit7
New Member
4 years ago
Solved

create reports by using two sharepoint lists

Hi Mates,   Can you guys help me to create  reports by using two sharepoint lists contains with same columns ???
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, icsrit7 

     

    You can use the append function in power query to join the two tables so that they can be filtered together in the report.

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.
     
    Best Regards,
    Community Support Team _ Janey
jaipal's avatar
jaipal
Resolver III
4 years ago

Hi icsrit7 please share the sample data or sharepoint links and explain your desired outcomes, so it would be easy to help.

icsrit7's avatar
icsrit7
New Member
4 years ago

Actual sample data is ,

tracker noagreement type agreemnt yearfacultyname facultydept
1_1212naz2022kkIT

 

 

i have two lists which contains data after migration data in one list and newer added data in another list,

like the above table , i have two lists and i need to show report as mentioned data as visuals in a single report

 

thanks in advance /\