Power Platform Community Forum Thread Details

Hello,

I am in the learning phase, so excuse me.

I have a list created: Let's call it 'Roster'.

My PowerApps has a text input called 'BadgeID'

A button is created called 'EmployeeID'

The column i'm trying to reference is called 'Badge' from the aforementioned list

This would then add columns 'Payroll Name: First Name' AND 'Payroll Name: Last Name' to the text input named 'EmpName'

I thought it would be similar to running vlookup in excel, maybe im wrong.

thanks,

Categories:

Building Power Apps

Hi @jkel9bna

You need a thirth collection that merge everything together.

Check my example below:

My collections are:

ClearCollect(colRoster, {BadgeID:"123", Name:"ABC"},{BadgeID:"456", Name:"DEF"},{BadgeID:"789", Name:"GHI"});
ClearCollect(colEmployee, {BadgeID:"123", EmployeeID:"987"},{BadgeID:"456", EmployeeID:"654"},{BadgeID:"789", EmployeeID:"321"})

The button.Onselect is:

ClearCollect(colMerged, 
 AddColumns(
 Filter(colRoster, BadgeID=TextInput1.Text),
 "EmployeeID",
 LookUp(colEmployee,BadgeID=BadgeID,EmployeeID)
 )
)

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.