cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

Thank you so much @Tom_Slosse. You are the hero of the day.

Highlighted
Anonymous
Not applicable

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

Did anyone happen the following regarding the lookup field?

 

Lookup fields displayed values while i am editing my app but they are not when i run the app from the web link.

 

 

while i am editing:

 

 Capture2.JPG

 

Opening from web link:

Capture1.JPG

 

THanks!

 

Martín

Highlighted
Memorable Member
Memorable Member

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

Hey @Anonymous

 

 

I think your problem lays with the PrimaryId = ThisItem...

Because the lookup only expects only a datasource so what I would do is remove everything after the ; and remove the ; as well

 

Hope this helps

 

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
Anonymous
Not applicable

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

thanks @Tom_Slosse.

 

The strange thing is that the formula is working, but values are not shown when i play the app in a web browser ( i can only see them in powerapp studio app).

 

Highlighted
Memorable Member
Memorable Member

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

Hey @Anonymous

 

 

I suggest you keep using the Studio instead of the web.

And try to test your apps on home.dynamics.com and see if the values are showing.

 

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
Frequent Visitor

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

Im having the same issue but mine is appearing when I do it in a gallery. I am getting the incompatible record values error.

 

I have an object entity and a room entity. I linked the two together. When I add .value to the string it doesnt populate the table with the text value. Any thoughts?

 

 

valueerror.jpg

Highlighted
Advocate IV
Advocate IV

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

@rdevine I'm having the same issue...

 

I have a "New" Form pointed at a Sharepoint List "Requests"...I'm trying to have a bunch of fields in that form default to predefined values stored in another list...so the user chooses something in the "Request Category" Lookup and this sets the default value in another form field

 

I have my edit form pointed to my main Sharepoint List "Requests"

Within the "Requests" sharepoint list there is a lookup field that is linked to another sharepoint list "Request Type List" and on the edit form there is a cooresponding Lookup 

 

I then have a plain Label (to see what's going on) where the Data Property is set to : 

First(Filter('Request Type List',Title=drpPCPRequestCategory.Selected.Value))

 

All i get is "The Property Expects Text Values, but this rule produces incompatible Record Values"...what am I doing wrong??

 

Highlighted
Memorable Member
Memorable Member

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

Hey @Dcurran12

 

 

Your code is good but you are using record values so you need to put the column after your existing code, if I'm not mistaken.

So something like this:

 

First(Filter('Request Type List',Title=drpPCPRequestCategory.Selected.Value)).<field>

 

If thats not working try and put Search instead of the Filter function, and add your desired field behind it like the example above.

 

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
Memorable Member
Memorable Member

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

Hey @rdevine

 

 

You should try and search for your values in the gallery.

So something like this:

 

First(Search(<datasource>, <gallery>.Selected.RoomLocation.Value, "<field>")).<field>

 

Let me know if this works, otherwise I will try and recreate your problem.

 

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 IV
Advocate IV

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

@Tom_Slosse  You are a friggin ROCK STAR my friend!!  Using "First(Search(<datasource>, <gallery>.Selected.RoomLocation.Value, "<field>")).<field>" worked!  

 

You have know idea how hard I bashed my head against the wall to figure this sucker out!

 

 

Helpful resources

Announcements
secondImage

New Return to Workplace

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

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,964)