Unanswered

Reset a ComboBox people picker to blank

(0) Share

Report

Posted on by tagustin2020

Hello Randy,

No need to respond immediately since it is the weekend, but I recently got a request to set a Mechanical Engineer combobox control back to blank default status after the control has already been used to select a name. The combobox has no problem updating if I choose a different name, but if I just erase my name by clicking the X, it just reverts back to my name when I resubmit the form. I've tried a bunch of different things (see attachment for details) and nothing is working. I was wondering if you could help me out.

Thanks,

Teresa

Categories:

Building Power Apps

ComboBox Problem ...

I have the same question (0)

All responses (11)

Answers (3)

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report
I was having same problem few days ago. Below code on the 'Update' Property of The 'Data card' solved my issue:
If(IsBlank(DataCardValue26.Selected),Blank(),DataCardValue26.Selected)

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@tagustin2020

Turn on the Error-Level Formula Management option in your Advanced settings in the app.

Also, as a general principal, your Submit action button should only contain the SubmitForm function.

Everything else you want to occur after the form is submitted should be in the OnSuccess or OnFailure action of the form.

So, the OnSelect action of the button should be:

Set(varPlaySpinner, true); SubmitForm(frmDesigner); SubmitForm(frmApproval);

The OnSuccess action of the frmApproval should be:

Set(varRecord,frmApproval.LastSubmit); ViewForm(frmApproval); UpdateContext({DesignerForm: false, ApprovalForm: false }); Set(varPlaySpinner, false)

This does not account for the success or failure of the Designer form, but I am not completely clear on the double form submit and the relation to each other.

Hope that helps some.

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report
@RandyHayes
@zmansuri

Hello Z and Randy,

Thank you for you advice. I entered the formulas, but unfortunately, the name is still stubbornly hanging on. Can you spot what I am doing wrong?

Save icon OnSelect:
Set(varPlaySpinner, true);SubmitForm(frmDesigner);SubmitForm(frmApproval)

Form OnSuccess:
Set(varRecord,frmApproval.LastSubmit);ViewForm(frmApproval); UpdateContext({DesignerForm: false});UpdateContext({ApprovalForm: false}); Set(varPlaySpinner, false)

Thank you,
Teresa

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

Like (0)

Report

@tagustin2020

Can you clarify what is being submitted to the list? Is a Blank or the original value being submitted?

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@RandyHayes

Hi Randy,

It is the original value being submitted. If I assign myself to the job, I can assign someone different to the job, but I can't make it go back to blank, it just reverts to my name.

Teresa

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

Like (0)

Report

@tagustin2020

Change the Update property to be just Blank() then submit a form and see if you are getting Blank in the record properly.

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@RandyHayes

Hi Randy,

I tried changing the Update property of the ME Assigned data card to Blank(), I deleted my name from the combobox, saved the form - it still reverted back to my name. Stubborn little bugger. I'm going to be in a meeting from 1-4pm PST so please forgive any delays in response this afternoon.

Kind regards,
Teresa

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

Like (0)

Report

@tagustin2020

Yes, changing the Update Property of the datacard was all that was needed. Nothing else would function at that point. It was a test just to see if the Blank is being written.

So, are you SURE that the Formula-Level Error Management is on??? That is the only feature that will allow you to write a blank to the datasource. The signs scream that it is not on.

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@RandyHayes
@zmansuri

Hi Randy,

Sorry I missed that instruction on your post. Once I turned on formula-level error management, the Update formula Z provided worked perfectly. I really appreciate the input from both of you!

Teresa

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@tagustin2020

Yes, the key to writing a blank to the datasource is to have error-level formula management on.

And, your Update property does not need to be all of the If statement, it can simply be valMEAssigned.Selected

If no selection is made, then .Selected will be blank. So there is no need to check for blank in order to write a blank. It just didn't work before because you didn't have that setting on.

Was this reply helpful? Yes No