Incompatible Types error - Help

[kightamy]

I have a form that pulls data from one SP source, I have a combobox that pulls data from another SP list. I want to filter the CB based on the user who submitted the form. Looking up the display name in the 2nd SP list & pulling in the correct column from that list.

VR site - 1st SP site with PowerApp

BU Permissions list - 2nd SP site with data for CB

The DataCardValue12 is not a fillable field, it populates based on user

The User Name field is entered in manually

Both are Person type fields in each SP site

I get the error: Incomparable types for comparison. These types can't be compared: Record, Text 

This is the formula I have in the CB Items

Filter('BU Permissions list', 'User Name' = DataCardValue12.Selected.DisplayName)

[TheRobRush · Accepted solution]

Here's how i set up a combo box for a record in a gallery based on a choice column in sharepoint. They are a little different, this might help you

In items of the combo box you have Choices() inside of that ParkingMasterGarages (My SPList) . Area (The Choice Column

Choices(ParkingMasterGarages.Area)

Then for default selected items I have

ThisItem.Area.Value

see if that gets you closer

[kightamy]

That did help me get my issue resolved. Thank you

I changed my Items to Filter('BU Permissions list', 'User Name'.DisplayName = TextInput2.Text)

I had to change the lookup field to a textinput because I needed to populate that with the current user when the form is opened as new.