Unanswered

Gallery works fine in browser, comes up blank on the phone

(0) Share

Report

Posted on by AFWright

I have a text box that I'm using as a search bar on this page that is connected to a Gallery.

When I'm testing the app in a browser and during editing, there are no errors and everything works just fine. Once published, on a mobile device once you reach this specific screen, the gallery displays the correct number of rows of items, but data is not populated.

Code for Items in the Gallery:

If(
IsBlank(TextInput1.Text),
ProductSelections,
SortByColumns(
 Search(
 '[dbo].[AOC_Items]',
 TextInput1.Text,
 "Item",
 "Description",
 "PreferVendor"
 ),
 "Item",
 Ascending)
)

Categories:

Mobile App

Connectors

General Questions

I have the same question (0)

All responses (4)

Answers (0)

v-yutliu-msft on at

Like (0)

Report

Re: Gallery works fine in browser, comes up blank on the phone

Hi @AFWright ,

I've noticed that you connect your app with SQL Server.

Could you tell me you connect with Azure SQL or on-promises SQL?

If you connect with on-promises SQL, you can not load data in your phone.

The data is in your computer.

What's more, please check your phone's system whether meet the requirments:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/limits-and-config

Best regards,

Was this reply helpful? Yes No
corey_msft on at

Like (0)

Report

Re: Gallery works fine in browser, comes up blank on the phone

In App settings -> Advanced settings, is Explicit column selection enabled or disabled?

Was this reply helpful? Yes No
AFWright 87 on at

Like (0)

Report

Re: Gallery works fine in browser, comes up blank on the phone

Explicit is enabled.

I found the issue. It was not related to the Gallery itself, but other references on the page (Form and labels).

Once I corrected those, everything worked fine.

Was this reply helpful? Yes No
corey_msft on at

Like (0)

Report

Re: Gallery works fine in browser, comes up blank on the phone

@AFWright Glad you were able to figure it out!

Was this reply helpful? Yes No