Why is my gallery displaying wrong data

(0) Share

Report

Posted on by AaronRichardson

148

I have a gallery with the following formula for the items:

Which returns a dataset that looks like this:

Notice the blank row at the bottom. This row is included by design and should always be at the bottom.

Now look at the gallery:

Notice how the last row is not blank, but rather duplicates the previous row's data. To be clear, the gallery is not displaying the data the way it is shown in the Items property.

Does anyone have any idea why this is happening? Is my blank row somehow confusing PowerApps? The gallery only recently began showing this behavior and I can't figure out why.

This is my build version:

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Re: Why is my gallery displaying wrong data

Hi @AaronRichardson ,
The dropdown control has always a selected item. If the default item is not inside the items controls, the first item of the Items source is displayed as selected.
If you want that your control to have a blank value as a choice you can either add a blank value to the items source (collection) of the dropdown control or use a comboBox control.

Hope it helps !

Was this reply helpful? Yes No
AaronRichardson 148 on at

Like (0)

Report

Re: Why is my gallery displaying wrong data

@gabibalaban thanks for the response!

The drop downs do have a blank response option. That isn't the issue here. If you look at the free text inputs for example, the values match between the bottom two rows. Again, the source rows in the collection do not contain duplicate values like this. Any other thoughts?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Why is my gallery displaying wrong data

Hi @AaronRichardson :

Could you tell me:

Are these drop-downs dropdown controls or combo box controls?

What are their items\default\(defaultselecteditems) properties?

I assume there are all drop down controls.

First of all,let me explain why you encounted this problem.

The key is that even if there is a Blank() option in the drop control, if the value of its Default property is Blank(), it still selects the first option by default(Unless you reset this control).For example:

1\Add two dropdown controls(Dropdown1/2)

Dropdown1-Items

["1",Blank(),"2"]

Dropdown2-Items

["1",Blank(),"2"]

Dropdown2-Defult

Dropdown1.Selected.Value

The result is that when dropdown selects Blank(), the options of dropdown2 will not change.

So my suggestion is to use spaces instead of blank() as options.For example:

Dropdown2-Items

["1"," ","2"]

Dropdown2-Defult

If(IsBlank(Dropdown1.Selected.Value)," ",Dropdown1.Selected.Value)

Secondly,I suggest you create a Data Table to check if the result of the formula is as expected.For example:

Add a datatable control and set it's items property to:

Sort( Filter( ColImpactfullDetails…… ）

Finally , I suggest you check the default property of these dropdown controls.(If they are combo boxes, you need to check the defaultselecteditems property.)

Best Regards,

Bof

Was this reply helpful? Yes No
AaronRichardson 148 on at

Like (0)

Report

Re: Why is my gallery displaying wrong data

@v-bofeng-msft thanks for the reply.

I'm afraid you've made the same suggestions that the previous commenter did. As I mentioned before, the issue is not the default items in the drop down controls. Please notice in the images I posted that the text input controls are also showing the wrong data per the Items property of the gallery.

I will stress the point that this worked previously and only recently stopped working. The default items of these controls has not changed during that time. For example, here's the Default property of the left text input control:

The data for the last row in the Items property of the gallery is blank, so the default property is not showing the correct data for both the text input controls and the drop downs.

Is there anything else you can think of that could be causing this?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Why is my gallery displaying wrong data

Hi @AaronRichardson :

I've made a test but did not encountered the problem you mentioned.

Have you confirmed that the ImpactDescription value of the last record in the return value is Blank?for example:

You can add a label control and set it's Text property to:

IsBlank(Last(Sort(Filter(ColImpactfullDetails……）..)).ImpactDescription)

In addition,Because you mentioned that the gallery was working fine before, I suggest:

1\Clear browser cache

2\Delete the corresponding connection (colImpactFullDetails) and recreate

3\Change the version of power apps

4\Return your app to the previous version

If none of these work, I suggest you create a support ticket.

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

AaronRichardson 148 on at

Like (0)

Report

Re: Why is my gallery displaying wrong data

Thank you for your time, @v-bofeng-msft! I have created a support request.

Was this reply helpful? Yes No