Power Platform Community Forum Thread Details

Hello,

I am a newbie to the Power Apps and trying to figure out the way to make a connection between the lookup field and the data connection. I am customizing the SharePoint form into power apps.

I have a list called "Financials" and "Request Form" in SharePoint. I have created the "Unit", "Var", "Act" and "Wrk" columns in the Financials list and add a "UNIT" as a lookup column in the "Request Form".

Now that I have the "Unit" field on the Request form getting data from the Financials list. I added a data table in the power app and connect the data source to the "Financials" list. And added a "Unit" field from the "Request Form" list.

What I wanted to do is when I select the "Admin" from the UNIT lookup drop down it should pull the "VAR", "ACT" and "Wrk" columns and show their data only instead of showing the entire "Financials" list data.

There is not just these three values in the UNIT column there is bunch of other values as well.

Is that possible in the power apps? Where should we add the condition? And what should be the condition? Any help would greatly be appreciated. Lookup field.jpg