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]

try putting a text box there somewhere with the default of DataCardValue12.Selected.DisplayName and make sure that's giving you what you expected it to

[kightamy]

I should have mentioned that, I put a TextInput box & it is populating the correct info. I tried changing the filter to look at that field instead but same error except it says Record, error

[kightamy]

I changed the formula to this:

Filter('BU Permissions list', 'User Name' = DataCardValue12.Selected) & not it says it's not comparable: record, Record

I'm confused

[TheRobRush · Accepted solution]

in the data source is 'User Name' column a people/person column? if so that column is in fact a "Record" as it stores all the variables attached to the person, you would need to narrow that down like user name.displayname etc. & this DataCardValue12.Selected will need a modifier on end as well IE)DataCardValue12.Selected.Value

[kightamy]

That resolved the error. I have another issue though. I have this in the DisplayFields of the same CB

'BU Permissions list'.'BU Allowed' 

I had it working for a minute but then it comes up blank

[TheRobRush]

I don't think it would need 'BU Permissions list' this part since the source is handled by the item, have you tried making it just the 'BU Allowed' portion? Like this

["BU Allowed"]

['BU Allowed']

[kightamy]

When I try it in that format, the ["BUAllowed"] with or w/o space it makes the word red & when I click outside the field it converts it to ["ComplianceAssetID"], when I click on the field it shows the BUAllowed in Red

[TheRobRush]

Is BU Allowed a column in the splist BU Permissions List? If so what is the column type

[kightamy]

It is in the BU Permissions list & it is a Choice Field