@kmw1130
If you're not able to consolidate to a single list, then you can easily see the two in PowerApps as well.
If there is ONLY a need to view them in a list in the app, then a Gallery with an Items property such as:
Ungroup(
Table(
{Items: ShowColumns(List1, "column1", "column2", ...etc...)},
{Items: ShowColumns(List2, "column1", "column2", ...etc...)}
),
"Items"
)
You WILL want to make sure that you are using identical column types from each list.
Otherwise, the above will provide one table of all the lists combined.
Keep in mind that this kind of activity is restricted to record limits. So you will only have up to the amount specified in your app returned from each data operation (i.e. the ShowColumns function).
However, the above can be augmented to have filtered data to reduce the number of records returned.
