Combobox & Button bug

[Fosse]

Hello,

Comboboxes in a gallery in my App suddenly stopped working on their own. There seems to be a problem with the DefaultSelectedItems of the the comboboxes. As you can see from the picture, instead of showing for example "JDI" in Type-combobox like it did previously, it has started to show {"ID":0, "Value":"JDI"}. The code for DefaultSelectedItems is "{Value: ThisItem.Type}".

There is now also a problem with a button, and I think it is related to the comboboxes. The button is used to trigger a flow, which creates An Excel file of the gallery view, and then returns the link for that file. Here is the code for the button:

ForAll(Gallery3.AllItems,Collect(colDataExported,{ID: ThisRecord.ID, Problem: ThisRecord.Problem,Type:Text(ThisRecord.Type), Category:Text(ThisRecord.Category), Root_Cause:ThisRecord.Root_Cause, Solution: ThisRecord.Solution,Status_with_comments: ThisRecord.'Status With Comment',Responsible: ThisRecord.Responsible, Support_function: ThisRecord.'Support function', Priority: ThisRecord.Prio,Solution_cost: ThisRecord.'Solution cost', Start_Date: ThisRecord.'Start Date', End_Date: ThisRecord.'End Date', Effect: ThisRecord.Effect, Status: ThisRecord.'Problem Status', Planned_End: ThisRecord.'Planned End', Location:ThisRecord.CreatorCity, Department: ThisRecord.CreatorDepartment}));

Set(varFileLink,'PowerApp->Content'.Run(JSON(colDataExported,JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes)).filelink);

Launch(varFileLink);

Clear(colDataExported)

Here are the errors caused by the button:

The errors are strange in a sense, that buttons do not have an OnChange-feature at all in PowerApps. The button worked like it should previously, and I have not changed anything. What is interesting, is that if I put Text(ThisRecord.Root_Cause) in the code above, the formula on select starts to give errors, but Text(ThisRecord.Type) and Category:Text(ThisRecord.Category) work just fine. Type, Category and Root Cause are all comboxes. The reason why I am using for example Text(ThisRecord.Type) is, that I want the excel to show the text value for the Type column, rather than Column Choice ID (number).

So does anyone know, what is going on with my app? Has there been some update, that I am not aware of?

Thanks!

[v-qiaqi-msft]

Hi @Fosse,

Could you please share a bit more about the scenario, the first screenshot you provided is so blurry that I could not see the problem at all?

In addition, I think you could modify the formula as below:

ForAll(Gallery3.AllItems,Collect(colDataExported,{ID: Label1.Text, Problem: Label2.Text,Type:Label3.Text, Category:Label4.Text, Root_Cause:Label5.Text...}));

If you worry about the data type, you could replace the ThisRecord with the specific control.

Could you please post a clear screenshot.

Regards,

Qi

[Fosse]

Hello,

Here's the picture:

This video is practically the scenario: https://www.youtube.com/watch?v=vRn7br2OaxE

So I have created a similar gallery view, which is used to edit a Dataverse for Teams table. I don't know if it possible to use specific controls instead of ThisRecord, because those rows in the Gallery are coming from the Dataverse-table.

In the Dataverse for Teams table, Category, Type and Root Cause are type Multichoice.

[Fosse]

I was just thinking, is it possible that:

ForAll(Gallery3.AllItems,Collect(colDataExported,{ID: ThisRecord.ID, Problem: ThisRecord.Problem,Type:Text(ThisRecord.Type), Category:Text(ThisRecord.Category),Root_Cause:ThisRecord.Root_Cause, Solution: ThisRecord.Solution,Status_with_comments: ThisRecord.'Status With Comment',Responsible: ThisRecord.Responsible, Support_function: ThisRecord.'Support function', Priority: ThisRecord.Prio,Solution_cost: ThisRecord.'Solution cost', Start_Date: ThisRecord.'Start Date', End_Date: ThisRecord.'End Date', Effect: ThisRecord.Effect, Status: ThisRecord.'Problem Status', Planned_End: ThisRecord.'Planned End', Location:ThisRecord.CreatorCity, Department: ThisRecord.CreatorDepartment}));

Set(varFileLink,'PowerApp->Content'.Run(JSON(colDataExported,JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes)).filelink);

Launch(varFileLink);
Clear(colDataExported)

Converts the Gallery Items to JSON-format and that would cause the problem, because {"ID":0, "Value":"JDI"} seems like JSON-format?

[_Corey_ · Accepted solution]

@Fosse  

We have identified the issue and an update is currently being deployed to all regions to address this issue and in some cases has already completed.  

Depending on your region, the following versions (or later) contain the fix:

• 3.21061.14
• 3.21055.27
• 3.21054.36

You will need to edit, save, and re-publish your app(s) for the fix to take effect.

[Fosse]

Hello,

Thanks for the reply. My App started working better after I updated to 3.21055.27, but I still have one problem, that did not exist before all of these problems started: the DefaultSelectedItems-property of the comboboxes is not working like it did previously. 

I have a gallery, where Dataverse For Teams-table is the data source for the comboboxes. However, DefaultSelectedItems: {Value: ThisItem.Column} does not automatically show the Column value that the gallery item has in the Dataverse for Teams table. It did show it before, now it just shows blank. If I select a value from the combobox and patch the selected value to the table, it works, but after that the combobox just turns to blank instead of showing the selected & patched for the gallery item.

[v-qiaqi-msft]

Hi @Fosse,

Glad that you have solved your problem.

If you have a new issue, could you please open a new case to describe them?

Thanks for your co-operation.

Regards,

Qi

[Fosse]

Hello @v-qiaqi-msft ,

You can find it here Combobox DefaultSelectedItems showing blank - Power Platform Community (microsoft.com)

Thanks for your help!