Power Platform Community Forum Thread Details

I have 6 sharepoint list (lets say - Environment, Employee, Savings, Costing, Activity, Governance. This is to be filled by 1100 employees across the company with one employee filling only 1 initiative. For that I have a Power Apps in place which is floated in the organisation. The entries are taken in the Power Apps and the data is stored in any of these SP list.

There are 15 columns which are common for all six SP list such as name(text), email id(email), reporting person(person type), Initiative(text), Location, Senior reporting person(person type), Implementing date(date type), importance of the initiative(text), how to implement it etc.

In total 150 columns are there if combined, each of the 6 list have 20 uncommon fields( lets say list 1 has 1A(text), 1B(number), 1C(number), 1D(choice), 1E(currency), 1F(date),1G(attachments -image/pdf) till 1U columns, Similarly, list 2 has 2A,2B,2C,2D,2E and so on, with some different column types. I am creating a gallery view based on the approval status. It will retrieve data from all 6 sharepoint list and display in the gallery.

Tricky part -

1> The page retrieves the entries of all those user who have that given person as their manager. So, User.().Email will call all those entries and display those entries in the gallery. While I was able to do that for 1 SP List, I am troubled with doing it for 6 SP List.

2> All the 6 SP have a column of Approval with Choice column - Given Approval, Pending Approval and Approved. I want to filter the Gallery of all 6 SP List using that and display the entries in the gallery. Here again, I was able to do that for 1 SP List. How to FILTER items based on one common column and its choices.

Attached the screenshot how it looks.

I went through a number of videos and sites, all they talk about is LOOKUP fn.

Please help.