Combo Box Value Doesn't go Blank when you remove a name

(0) Share

Report

Posted on by olsen9

378

Current Patch Code is:

f(
!IsBlank(ComboBox13.Selected.Mail),
{
Name1: {
Claims: Concatenate(
"i:0#.f|membership|",
ComboBox13.Selected.Mail// Person email
),
Department: "",
DisplayName: "",
Email: "",
// Person email
JobTitle: "",
Picture: ""
}
}
),

It Patches perfect but if I remove the value(name) and click Patch, the value stays the same.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@olsen9

Change the following:

{ Name1: If(IsBlank(ComboBox13.Selected.Mail), Blank(), {Claims: "i:0#.f|membership|" & Lower(ComboBox13.Selected.Mail), Department: "", DisplayName: "", Email: ComboBox13.Selected.Mail, JobTitle: "", Picture: "" } }

Make sure you also have the "Formula Level Error Management" feature turned on or it will not write the blank.

I hope this is helpful for you.

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @olsen9 ,

Turn on Formula Level Error Management in Settings

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
olsen9 378 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, all that is on, still doesn't take:

If(
IsBlank(ComboBox13.Selected.Mail),Blank(),
{
Name1:
{Claims: "i:0#.f|membership|" & Lower(ComboBox13.Selected.Mail),
Department: "",
DisplayName: "",
Email: ComboBox13.Selected.Mail,
JobTitle: "",
Picture: ""
}
}
),
If(
!IsBlank(ComboBox13_1.Selected.Mail),
{
Name2: {
Claims: Concatenate(
"i:0#.f|membership|",
ComboBox13_1.Selected.Mail// Person email
),
Department: "",
DisplayName: "",
Email: "",
// Person email
JobTitle: "",
Picture: ""
}
}
),

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @olsen9 ,

Not sure who you are responding to here (I just noticed @RandyHayes posted just before me). Adding to his response

If( Len(ComboBox13.Selected.Mail) = 0, { Name1: { Claims: "", Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" } } )

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@olsen9

Your If is in the wrong place from what I sent you.

And, you still need to actually send a Blank to the list.

{ Name1: If( IsBlank(ComboBox13.Selected.Mail),Blank(), {Claims: "i:0#.f|membership|" & Lower(ComboBox13.Selected.Mail), Department: "", DisplayName: "", Email: ComboBox13.Selected.Mail, JobTitle: "", Picture: "" } } ), { Name2: If(IsBlank(ComboBox13_1.Selected.Mail), Blank(), {Claims: "i:0#.f|membership|" & Lower(ComboBox13_1.Selected.Mail), Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" } } ),

Your formula is just a fragment of your entire formula, so it is hard to tell what else you might be doing and what the problem might be. But the above is the construct of what you need.

Ideally this would all be done from your comboboxes, but you can do it in this formula as well.

Was this reply helpful? Yes No
olsen9 378 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks,

Everything works unless I go back into the form to clear out the name. The name still sticks. I hope that helps.
I don't have the correct patch to clear out the name.

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@olsen9 ,

I will leave you in the capable hands of @RandyHayes

Was this reply helpful? Yes No
olsen9 378 on at

Like
a
(0)

Report
Copy link

Link copied!
This one works for both adding and removing names from a combo box Drop down

{ Name2: If(IsBlank(ComboBox13_1.Selected.Mail), Blank(), {Claims: "i:0#.f|membership|" & Lower(ComboBox13_1.Selected.Mail), Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" } } ),

Was this reply helpful? Yes No
olsen9 378 on at

Like
a
(0)

Report
Copy link

Link copied!

Problem I am having now is this doesn't work for both items. Either one has data and saves or the other ones clears out

Here is my code

{
Name1:
If(IsBlank(ComboBox10.Selected.Mail), Blank(),
{Claims: "i:0#.f|membership|" & Lower(ComboBox10.Selected.Mail),
Department: "",
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
}
)
};
{
Name2:
If(IsBlank(ComboBox10_1.Selected.Mail), Blank(),
{Claims: "i:0#.f|membership|" & Lower(ComboBox10_1.Selected.Mail),
Department: "",
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
}
)
};
{SubmitFlag:"1"};
)

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@olsen9

I will reply to you in your new posted topic.

Was this reply helpful? Yes No