@mbr0wn It depends on what exactly you want to get from the multiple SharePoint lists.
Are you trying to fetch the matching records (relationship) from multiple lists? You can get the items from multiple SharePoint lists first and then match the records based on unique columns - both in Power Apps and Power automate.
You can also using the PowerShell, PnP PowerShell or CLI for Microsoft 365 if you are familiar with the PowerShell.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
