Still have issues with dependent combo boxes when using a form to edit an existing record

(0) Share

Report

Posted on by futr_vision

831 Moderator

For reference, here is my last post that has gone dead. https://community.powerplatform.com/forums/thread/details/?threadid=de00a275-a990-ef11-ac21-7c1e520a09df

I never got to a solution that works as you can see. Here is the situation I outlined in that post,

Here is my situation

I have a gallery that returns records from Dataverse table
When you select a gallery item the record is written to a global variable (I used a global variable because there is also a copy record function on the page that navigates the users back to the original form and populates it with the copied record for editing)
I have a form on the page that uses the global variable data as the Items property
In the form I have some dependent combo boxes. These function as expected. When and item from the parent is selected the values available in the child combo box are changed.

This all works fine. But I am having issues with the behavior I want the child combo boxes to have. Here is what I want to happen.

When a parent combo box is changed I want the child combo box(es) to appear blank.
If the child combo box is required I want that to be respected by the form

I've yet to find an acceptable solution. If it was just a regular form then it's easy enough to use OnChange to control the reset of the child combo boxes but when dealing with a gallery, every gallery selection triggers the OnChange resulting it unwanted outcomes. If anyone can please help me find a solution I would greatly appreciate it. I've been trying to solve this, on and off, for the last 4-5 months. I'm at a point where I need to get this working so the app can be rolled out. TIA!!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Kellboy2243 51 on at

Like (0)

Report
Copy link

Link copied!
Hi

Try these steps below.

1. On the Onchange property of the parent combobox, reset child combobox by using the function
Reset(ChildComboBoxName)
2. There are multiple ways to do this but the fastest way is to set the required property of the datarcard for your combobox to true. The datacard is what connects the combobox field to the column on your datasource. If you do this correctly, it should throw an error when you try to submit the form without the child combobox been selected.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

Kellboy2243 Selecting a gallery item triggers the OnChange. That means when I go to edit that record the child combo box is going to be reset even though I may not want to change it. OnChange has been an issue.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

Anyone with thoughts on how to solve this?

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do these problems only occur when using a global variable as your form's data source or do they also occur when using the selected item from the gallery (presumably the required item requirement is managed automatically here)?

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!
I believe it happens in both scenarios but let me give that a try. I do see this in my history of things I have tried.

UpdateContext({varGalSelected: ThisItem.'Project Reference Number'});

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!
I think part of my problem is this

{Value:If(varResetSubLedgerReview,Blank(), Parent.Default)}

If I hover over varResetSeubLedgerReview it returns false

If I hover over Default in Parent.Default, I see the correct value

But this statement doesn't return a value

"(S)Sub Ledger: " & CB_SubLedgerReview.Selected.'Sub Ledger Name'

Was this reply helpful? Yes No
Suggested answer

futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!
Ok. After much tinkering I think I found my answer.

Parent Combo Box

OnSelect
UpdateContext({varResetSubLedgerReview: false}); UpdateContext({varResetSubLedgerReview: true});

Child Combo Box

DefaultSelectedItems (This is where I made my change by rearranging the argument)

If(varResetSubLedgerReview,{Value: Blank()}, {dk_subledgername: Parent.Default})

Reset

varResetSubLedgerReview

This seems to be doing exactly what I want although I see one oddity with another set of parent-child combo boxes. I make another post for that one.

Was this reply helpful? Yes No