Form shows "No item to display" although it should be available (Azure DB)

[mahdiou]

Hello, sorry if this is a newbie question. I have started using Power Apps last week.

I am facing a problem using a form that pulls data from and updates an SQL table in Azure.

Here's a description of the task I'm trying to implement:

There is a table in our database where from which we want to display column values based on a "section name" and "month". Those two can be selected by the user via their respective combo boxes as shown in this picture that shows the wanted result.

wanted state

Here the app correctly pulls the current contents of saisie2, saisie3, and saisie4. They can then be updated by the user and submitted by pressing the button "valider".

Problem:

The problem arises when any of the two combo boxes is updated an odd number of times. That is shown in the following picture.

after one update

After updating a second time the values are correctly displayed.

after two updates

We can see the problem happen even for the first values that were tested.

first inputs but after three updates

Our previous implementation used an Excel data source and did not have that problem.

A temporary fix that we implemented was to refresh the data source every time a combo box changes (OnChange), but I do not like it because in my understanding it will read the whole table from the database every time the user changes a combo box which is not very efficient.

My question is "Is there a way for the form to correctly appear without having to reload the data source every time?".

Thank you in advance for your time.