Answered

Full-text search in Gallery

(1) Share

Report

Posted on by alt88

171

How can I do a full text search on a gallery that is connected to a dataverse table? This contains texts and numbers. For a number like 7459604, I want to find the number in the entry 604 or 745 or even 596.

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

shubham_7 110 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @alt88
You can use the search function in this case i.e Search(Table*, SearchString, Column1 [, *Column2*, ... ] )
Let me know is helping you or not if yes then accept it as a solution.
Thank You😊

Regards
Shubham Ghorpade
PowerApps Developer.
alt88 171 on at

Like
a
(0)

Report
Copy link

Link copied!
The search is done via an input field and as an error I get: Wrong column Type. Expects text type.

Search('galProjects',inpSearch.Text, "text_projectname", "number_projectnumber")
shubham_7 110 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @alt88
Let me know the Datatype of your column by which you want to filter the gallery .

Thank you.
alt88 171 on at

Like
a
(0)

Report
Copy link

Link copied!

The Datadypes of the columns are text(single line of text) and Whole numbers(none)
shubham_7 110 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @alt88
Create a collection:
ClearCollect(TableColl,AddColumns(Table2,"OrderID2",Text(OrderID)))

Then change the formula to:
SortByColumns(Search(TableColl, inpSearchText.Text, "OrderI2D"),"OrderID2",Ascending)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it
Thank you.😊
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@alt88 ,

Actually the error you get is quite strange if you are using a dataverse table. Are text_projectname and number_projectnumber the logical name of the columns ? It doesn't look like that.

Can you try this approach ?

Filter('galProjects',TextInput1.Text in 'text_projectname' || TextInput1.Text in 'number_projectnumber')
alt88 171 on at

Like
a
(0)

Report
Copy link

Link copied!

the logical nam is ert_projectname and ert_projectnumber. With your approach i get following error:
The requested operation is invalid. Server
Response: galProjects:
No function signature for the function with name
'contains' matches the specified arguments. The function signatures considered are:
contains(Edm.String Nullable=true, Edm.String Nullable=true).
Verified answer

shubham_7 110 on at

Like
a
(1)

Report
Copy link

Link copied!

Please follow the above formulas :
alt88 171 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, it works now, but unfortunately I am still missing a data type. I can't get the data type Yes/No into the new collection.
alt88 171 on at

Like
a
(0)

Report
Copy link

Link copied!
the problem is when I do the search via the collection instead of the table in the dataverse is that I have a column in the gallery where I change an image by onselect to visualise if it was favoured or not (see picture).
If(ThisItem.Favorit,'Star 24dp_blackOn', 'Star 24dp_black')
How do I get this value from ThisItem.Favourite (which is yes/no as data type) into the collection and back from the collection to the database?