create reports by using two sharepoint lists

[icsrit7]

Hi Mates,

Can you guys help me to create  reports by using two sharepoint lists contains with same columns ???

[jaipal]

@icsrit7 simply you can click on Get data and choose Sharepoint Online list and paste the web URL to pull the document. You need to do it for twice as you have two different lists.

Finally you can show the data easily in a single report

[icsrit7]

hello jaipal,

i am giving you  brief,

Infact, i have two list which contains same columns , the specified columns contains agreement year and agreement type.in that both list , column agremment type is a choice column contains same values and year column contains different time period like 2010 2011 2012 2013 . ( list A having set of year values and list B having set of different year values)

 in this i need to pick values from agreement type agreement year from both list and make reports in number of agreement type in both lists by year.

I dont know how to get both list values integerate with single report.

Hope i am giving you brief ...

[v-janeyg-msft · Accepted solution]

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]

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

[icsrit7]

Actual sample data is ,

tracker no	agreement type	agreemnt year	facultyname	facultydept
1_1212	naz	2022	kk	IT

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 /\