
I have a date table from which I retrieve a diary number this is then used to filter a much larger table. I used the date as int solution to overcome delegation issues with filtering the date table with the date picker.
I then use "with" pre filter with the diary number on the larger table to return data on which I then filter further to retrieve the data we want.
However, I am now experiencing a bizarre problem. Every second time I use the date picker; it returns no data. For example, start the app and pick 4/1 I get data pick 5/1, and no data is returned. Pick 3/1 data returned pick 4/1 no data returned but then pick 5/1 data returned. Using SQL as the data source.
Does anyone know why this is happening ?
I think you have posted this in the incorrect forum, this forum is specifically for the "Power Pages" product believe you are dealing with a Canvas App in which case this link is the forum you want https://powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1