Unanswered

Gallery is blank

(0) Share

Report

Posted on by ahhollan

576

I have tried to create an app from a datasource (SP list). However, app doesn't show any records in the gallery. The formula in the gallery items property is SortByColumns(Filter([@'Project Initiation'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)) . However, when the search field is blank, the gallery doesn't return any items. Thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@ahhollan
When the text input ISBLANK a condition of True will show all records. Make this small change to your code.

SortByColumns( Filter( [@'Project Initiation'], If(IsBlank(TextSearchBox1.Text),True,StartsWith(Title, TextSearchBox1.Text)) ), "Title", If(SortDescending1, Descending, Ascending) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
DisappointmentB 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

The formula is expecting a result to be in the search box. You can check to see if the search text is blank. If it is then simply return all the results and if not use the formula you have.

Regards

Ben

Was this reply helpful? Yes No
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

I made the change and still get errors.

Was this reply helpful? Yes No
DisappointmentB 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I would separate the formula out so that it is easier to read and see the errors. So:

If(IsBlank(TextInput1.Text),
SortByColumns([@'Project Initiation'],"Title", If(SortDescending1, Descending, Ascending)) ,
SortByColumns(Filter([@'Project Initiation'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)))

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ahhollan
It would be helpful to know what error messages you are receiving.

Was this reply helpful? Yes No
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

That helped, but now I get...

Was this reply helpful? Yes No
DisappointmentB 61 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

Someone with the same problem of the Lookups asked here and a solution has been given. Would be worth checking if you have the same situation.

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Error-The-query-cannot-be-completed-because-the-number-of-lookup/td-p/144130

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@DisappointmentB
Agreed this is a SharePoint issue.

Was this reply helpful? Yes No