Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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

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 statewanted 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".



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 updateafter one update

After updating a second time the values are correctly displayed.

after two updatesafter two updates

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

first inputs but after three updatesfirst 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.


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,658)