create view in sharepoint like sql view

Hi power-apps-user2 

You could just create a new collection and load the results from all three lists into that like

ClearCollect(SharePointListView,`List 1`);
Collect(SharePointListView,`List 2`);
Collect(SharePointListView,`List 3`);

Put that into "App.OnStart"

Then set the collection "SharePointListView" as the items property of a gallery to display all items from the three lists.

If you add an item to any of the SharePoint Lists using a form then also put these three lines in the "onsuccess" property of each form.

Best Regards,
Sven