I have one lacks records in my sharepoint list i want to take all the data in one collection.

[Syndicate_Admin]

I have one lacks records in my sharepoint list. I want to take all the data in one collection. I am using more than 5 list in my application so every list have large data in future it will increase for sure. I want to calculate according to filter. if I am directly filtering and calculating hours then it's taking more than 5 minutes some time. I want to reduce the loading time. So I want data in collection so it won't take much time. Hope you understand the query waiting for the reply.

[Syndicate_Admin]

I want to create that Collection in Powerapps. Could you please suggest something which is help me to do this in powerapps.

[v-stephen-msft]

Hi,

You want to merge tables, right? Please refer to

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs

 

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.