Labels are not updating and conditional formatting is not triggering on copy form. How do I fix?

(0) Share

Report

Posted on by futr_vision

831 Moderator

I posted this question before, but I haven't gotten any feedback since. Here is what I have.

I have a form that uses combo boxes with this I have corresponding labels
The labels populate when a value is selected int he combo box
For some labels I was able to use comboboxname.Selected.Value and for others I needed to use comboboxname.Selected.columnname
The labels use conditional formatting. They are pink if the datacard is required and there is no value selected in the combobox. Code looks like this:

If(IsBlank(CB_Industry.Selected.'Industry Name') && DC_Industry.Required = true, RGBA(253, 222, 207, 1), RGBA(255,255,255,1))

This all works great when using the form to create a new record. Where I run into issues is when I go copy a record. Here is what this process looks like:

User clicks on a record in a gallery and then clicks a copy button
The button adds the record to a global variable and redirects them back to the original form where the forms is populated with the data in the global variable.
Code on the copy button looks like this"

Set(
 glbFormData,
 GAL_Campaigns.Selected
);
Set(
 varCopy,
 true
);
EditForm(FRM_CampaignForm);
Navigate('Create Campaign');

Note: I don't believe I need that varCopy variable. It was copied over from another app that has different functionality and required it.

Back on the form the fields are populated. Here is where my problem comes in. The labels, when it comes to comboboxes, don't function as expected.

If a label is using comboboxname.Selected.Value for the text value data is populated in that label
If a label is using comboboxname.Selected.columnname then no value is populated in that label
Any label using the conditional formatting posted earlier in this post does not pick up on the values populated in the comboboxes. For reference the comboboxes are using code similar to this for their DefaultSelectedItems

If(IsBlank(Parent.Default), Blank(), [Parent.Default])

That about sums it up. The last post I had on this topic was working towards a reevaluation of the form data but as I started this post, it dead ended after the first failed attempt. Any help would be greatly appreciated especially since I am not a coder by profession.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

v-jefferni on at

Like (0)

Report
Hi @futr_vision ,

Seems like you are using modern forms control, and modern Combo box controls are included in the form. For modern Combo box controls, please make sure DefaultSelectedItems property uses

Parent.Default

In addition, If(IsBlank(Parent.Default), Blank(), [Parent.Default]) is not necessary. The logic of using this formula is redundant. Parent.Default is enough.

Best regards,

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

Like (0)

Report

Thanks @Jeff . That formula was given me by the last person that attempted to help out. I originally had [Parent.Default] and the property value because Parent.Default throws and error 'Expected table value'.

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

Like (0)

Report

@Jeff or anyone have an idea how to fix this? I'm really stuck finding a solution and don't want to open 3rd post to get some help, Thanks!

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @futr_vision ,

Could you please tell what's the column type of the specific field?

Best regards,

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

Like (0)

Report

Hi @v-jefferni ,

The column type for all of the combo boxes is single line of text.

Was this reply helpful? Yes No
Verified answer

futr_vision 831 Moderator on at

Like (0)

Report
@v-jefferni
I've somewhat solved my problem. Instead of using [Parent.Default] for my DefaultSelectedItems in the combo boxes I switched to something like this:
{dk_industryname: Parent.Default}

That fixed a number of the label issues. All of them populate with the combo box data. Not all of the triggered the conditional fill. That I am scratching my head on. Not sure why it works for some combo boxes and for others it didn't.

Was this reply helpful? Yes No
Verified answer

futr_vision 831 Moderator on at

Like (0)

Report
Hi @v-jefferni ,

Ok. Still hashing through trying a bunch of options. I fixed the conditional formatting now. I was doing this

If(IsBlank(CB_Industry.Selected.Industry)&&DC_Industry.Required= true ,RGBA(253,222,207,1),RGBA(255,255,255,1))

Instead of thisH

If(IsBlank(CB_Industry.Selected.'Industry Name')&&DC_Industry.Required= true ,RGBA(253,222,207,1),RGBA(255,255,255,1))

That seemed to fix it. Allis good but there is one thing that is really baffling me. I have a single combo box that didn't like the DefaultSelectedItems formatted like this

{dk_costcenter: Parent.Default}

It only worked if I used

[Parent.Default]

Looking at the DisplayFields and SearchFields it has ["Value"] as a value instead of ["dk_costcenter"]. Why is that? I think it might have to do with the fact I am using 'Distinct' in the Items property for the combo box.

Was this reply helpful? Yes No