Answered

Search display in Browse Gallery

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm new to this all so please bear with me,

I've got an app based of a sharepoint list. I used create app function in sharepoint to build the app. In the browse gallery screen I would like the information displayed to be different than than the default that came.

This is what I currently have:

SortByColumns(Search('Appointment Book', TextSearchBox1.Text, "Student_x0020_First_x0020_Name"), "Student_x0020_First_x0020_Name", If(SortDescending1, Descending, Ascending))

I want it to display results based of the "modified" column instead of the "Student_x0020_First_x0020_Name" column. I tried just reaplacing the column name but that gave be back blank results. I think its because the modifed column is date/time and the search function works with strings? Will using filter work and if so how?

Thanks,

Matt

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Matt,

I assumed that you replaced the “Student_x0020_First_x0020_Name” with “Modified” column by manually entering the word “modified”, am I right?
And you not only got the blank result, but also a yellow warning icon.

I created an app for a list in SharePoint Online, the default function it has is:
SortByColumns(Filter(Employee, StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Then I tried to replace the “Title” column with “Modified” column by manually entering the word “modified”. I got a blank result and a yellow warning icon:

Then I changed the “modified” to “Modified”, it worked, and I can sort the app by “Modified” column:

PS: When changing the column, you could delete the existing column name, then select one from the drop down menu.

Please try this on your side and let me know if it works for you.

Best regards,
Mabel Mao

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

Like
a
(0)

Report
Copy link

Link copied!

Hi Mabel Mao,
Thank you for your assistance on this. I'm sorry its taken me so long to get back to this, I was put on another project. I entered your suggestion and I am still getting the error. This time it is an invalid argumetn type. My Modfied column is a DateTime column and the Startswith argument is looking for a text value. What argrument should I use instead of Startswith?

Thanks,
Matt

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi Mauth,

Thanks for updating.

Currently, StartsWith function can be used with Filter function to search the data within your app, please see this documentation about StartsWith function for more details:
https://powerapps.microsoft.com/en-us/tutorials/function-startswith/

As you are using Search function, so when you use StartsWith function with it, an “invalid argument type” error would be shown.

I tried to configure the code looks like below, it is displayed based on a Date/Time column, and it just works fine:
SortByColumns(Search(listF,TextSearchBox1.Text,"Title"),"date_x0020_only",If(SortDescending1,Descending,Ascending))

Best regards,
Mabel Mao

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

Like
a
(0)

Report
Copy link

Link copied!

That worked!

Thanks!

Was this reply helpful? Yes No