cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Memorable Member
Memorable Member

Re: the property expects Text values, but this rule produces incompatible Record values

Hey @Dcurran12

 

 

No problem. Glad it worked out for you 🙂

 

Kind regards

 

 

Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Highlighted
Advocate I
Advocate I

Re: the property expects Text values, but this rule produces incompatible Record values

Tom, that works for items selected in gallery, but what if you want to filter the gallery by wether a column called "Team" contains User().Fullname. This column could either be a 'People' column or a lookup column which references a list of staff in another list.

 

I can only get the filter to work if the people column does not allow multiple values, for example:

SortByColumns(Filter(Participants, Team.DisplayName = User().FullName ), "Surname", If(SortDescending1, Descending, Ascending))

 

What I really need is the equivilent of:

SortByColumns(Filter(Participants, Team.DisplayName CONTAINS User().FullName ), "Surname", If(SortDescending1, Descending, Ascending))

 

I've tried every variation of find, search, filter, if and so on but as neither a lookup of people column are a text string the filter fails. I'm trying to find a workaround that would take the value of the people column and convert it to a text string which I could then use to filter the gallery.

 

I hope that makes some sense and thanks in advance!

Highlighted
New Member

Re: the property expects Text values, but this rule produces incompatible Record values

I tried to put .Value at the end of the expression, but unfortunately I still receive the same error. "the property expects Text values, but this rule produces incompatible Record values"

 

Do you have any idea what else I could try?

Highlighted
Power Apps
Power Apps

Re: the property expects Text values, but this rule produces incompatible Record values

@Daniel_Pipe, you could try filtering the teams first and then joining it with your list of participants on ID like so:

 

Filter(Child,'Parent'.Id in Filter(Parent_1, TextInput1.Text in DisplayName).ID)

 

Do you think this might solve your problem?

Highlighted
Power Apps
Power Apps

Re: the property expects Text values, but this rule produces incompatible Record values

@zoltanvarga, do you mind sharing the expression you are trying to evaluate and the structure of your data?

Highlighted
Memorable Member
Memorable Member

Re: the property expects Text values, but this rule produces incompatible Record values

Hey @Daniel_Pipe,

 

 

Sorry for the super late answer. Didnt have time to get back to this.

I understand what you want to do. And my first instinct with a people field (like the one in SharePoint I suppose) is that I would use a Lookup() funciton. But you can't use like contains in PowerApps. You could use like IsMatch() instead I guess but I could be wrong. 

 

Let me know if it helped you out a bit.

 

Kind regards.

 


Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Highlighted
New Member

Re: the property expects Text values, but this rule produces incompatible Record values

Did not matter.   Table.Field.Value does nothing,.

Highlighted
New Member

Re: the property expects Text values, but this rule produces incompatible Record values

I am experiencing a similar error. I am using the following expression "ThisItem.Counterparty.Value" for a label and the underlying data source is a sharepoint list lookup field looking up value from another sharepoint list.

Highlighted
Advocate II
Advocate II

Re: the property expects Text values, but this rule produces incompatible Record values

Something similar to this worked for me:

First(Record).FieldName

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,295)