Data Table using a textbox value in FILTER - does not always fill the data table.

[TecSolArchitect]

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))

[v-sheyu-msft]

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