Unanswered

Search funnction : the property expects text value, but this rule produces incompatible table values

Like (0) Share

Report

Posted on 13 Nov 2018 16:05:57 by ProtestThe7

Sup folks?

I'm working on a powerapps project rn and have come across a little problem which i cannot solve and the other solutions presented here do not help me unfortunately so here we are,new thread 😕

Setting:

I have an app based on an excell table,called Table1.

On my app i have a browse screen listing my products and i have a text-input box on the top of my gallery where ideally a user can enter product names to search for said products.

My Excell Spreadsheet has the following columns:

PHAT ID

Marke

Geschmacksorte

Type

Vol

Image[image]

_PowerAppsId_

So in the searchbar (the Text Box is called "SearchBox" in my project) i have this function:

Search(Table1,SearchBox.Text,"Geschmacksorte")

which returns following error:

the property expects text value, but this rule produces incompatible table values

now every other soultion to simmilar problems dont work for me or are sadly outdated :(, any help would be highly appreciated 😄

thanks and have a nice one,

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

OneThing 393 on 13 Nov 2018 at 16:17:54

Like (0)

Report

Re: Search funnction : the property expects text value, but this rule produces incompatible table va

Hi @ProtestThe7,

I can't see anything wrong with your code. Where do you have this function?

The function is returning a table of results but it sound like you are trying to display this in a Text Label for example.

If you put the code into a Data table or a gallery you should be able to see the results.

Thanks,
Nicky

Was this reply helpful? Yes No
OneThing 393 on 13 Nov 2018 at 16:20:58

Like (0)

Report

Re: Search funnction : the property expects text value, but this rule produces incompatible table va

I've just noticed this line:
So in the searchbar (the Text Box is called "SearchBox" in my project) i have this function:
The function should really be in which ever control you wish to display the information such as a Gallery, Dropdown etc.

Try this out and you should have more luck.

Thanks,
Nicky

Was this reply helpful? Yes No