I have been using PowerApps for almost 1 year about 6 hours a day on projects with Sql Server 2016 for commercial client. We have a PowerApps form created and running for 3 months perfectly until the end of September when I believe a new version was released. All of suddent the data table (SQL Server 2016 - [Consumer] Table) is not always updated.
So I created a new form with a single text-box (CustomerNo) whose value is used in a FILTER() on a Data Table.
When you type the SAME value into the text box it does not always return a value in the data table.
After re-keying it about 3-5 times the records appear in the data table.
Filter('[dbo].[Consumer]', Consumer_ID = Value(ConsumerNo.Text))

Report
All responses (
Answers (