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))
hi @TecSolArchitect,
can you share a bit more about your data source ?
Is your SQL table saved locally or on-premises?
i made a test and there is no issue on my side.
please try to remove the connection and reconnect .
I suggest that you can also create a collection from SQL table and get data from the collection.
regards,
Eason
User | Count |
---|---|
177 | |
116 | |
85 | |
44 | |
41 |
User | Count |
---|---|
241 | |
153 | |
128 | |
77 | |
72 |