cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahdiou
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".

 

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

0 REPLIES 0

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (25,585)