Unanswered

need formula help for search

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am noticing one of the common errors with search in powerapp. I put in the below formula for Items proeprty of gallery control, but gives me invalid arguements error:

SortByColumns(Search(Inspections, TextSearchBox1.Text, "Title","Location","Inspection_x0020_Site_x0020_Name"), "Title", If(SortDescending1, Descending, Ascending))

Title is the OOTB column of SharePoint list, Location and Inspection site name are choice drop-downs. Can someone help me correct the formula? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

PaulD1 2,914 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you break down the formula and build it up one piece at a time to see exactly where the error is occuring?

E.g. start with Search(Inspections,TextSearchBox1.Text,"Title")

Then add the other fields and finally the Sort.

It is difficult to troubleshoot without knowing the data types of your fields and without being able to check the value in the variable SortByDescending1.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have mentioned the data types in question description, Title (OOTB text column), the other two are choice drop downs.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@PaulD1
the error comes up when I add the two choice columns in formula: Location and inspection site name, Thoughts?

Was this reply helpful? Yes No
PaulD1 2,914 on at

Like
a
(1)

Report
Copy link

Link copied!

Do the choice columns allow for multi-selection? If so, I think they will be returning tabular instead of text data which woul result in an error.

I've just tested on choice fields with single-selection and it works as expected (although the formula is not delegable).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@PaulD1
no, multiple values are not allowed. Can you share your formula, not sure If my formula looks off.

Was this reply helpful? Yes No
PaulD1 2,914 on at

Like
a
(1)

Report
Copy link

Link copied!

I just used a datasource I happened to have on-screen:

Search(RecommendedProduct, "litre", "Metric")

Where "Metric' is a SharePoint choice column set to single selection (in the SharePoint list definition).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

So should I take off Sortbycolumns from my formula?I guess you are only using search right?

Was this reply helpful? Yes No
PaulD1 2,914 on at

Like
a
(1)

Report
Copy link

Link copied!

It's always good to try to build up formulae a little at a time, so start with the Search and if that works, then add on the SortByColumns.

Was this reply helpful? Yes No