cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
afernando
Level 10

Table records not showing

Hi,

 

I have an app with a form and gallery connected to an Azure SQL database. Whenever I open the app and enter a record, the record won't appear in the gallery. Closing the app and reopening will show the record in the gallery but a refresh won't. This only started happening after the last update to PowerApps.

There are only less than 100 records in the database. Please help!

 

Cheers,

Anton

3 REPLIES 3
Community Support Team
Community Support Team

Re: Table records not showing

Hi @afernando,

 

I just tested it from my side with an Azure SQL database, and after I create a new record, it will navigate back to the browsescreen and show the newly added records.

Would you please share more information about your Table column information, and the App details?

My PowerApps version is 2.0.610.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
afernando
Level 10

Re: Table records not showing

Hi Michael,

 

Thanks for your reply. I think it has something to do with the filter function. I tried filtering the table with a variable and when I update the variable by pressing a button, the new item shows up. 

 

Items in Gallery:

 

 

Sort(Filter('[dbo].[Pallets]', OrderNo = varOrder && ProductCount>0),ProductCount,Descending)

Button to update the variable and refresh dataset;

UpdateContext({varOrder:"" }); Refresh('[dbo].[Pallets]');UpdateContext({varOrder:glOrders.Selected.OrderNo })

 

I am also using version 2.0.610. 

 

 

Please let me know if you need any further details.

 

Thanks,

Anton

 

afernando
Level 10

Re: Table records not showing

Hi @v-micsh-msft,

 

Do you have any update on this? 

 

Cheers,

Anton

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 427 members 4,690 guests
Please welcome our newest community members: