Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

How do I reset a combobox after a patch to the comboboxes dataverse table?

(0) ShareShare
ReportReport
Posted on by 634

I have a combobox with a DSI of:

 

If(Self.DisplayMode=DisplayMode.Edit, If(IsBlank(newThird),{crfeb_thirdparty: Parent.Default},newThird), Blank())

 

This combobox used to automatically refresh every time I patched a new value to the Dataverse table from a text input field.  No it does nothing. If I look at newThird there is a record value which I can print to screen using a label. The new value can also be seen in the combobox dropdown so I know the data got patched correctly. I tried refeshing the combobox after the patch but that doesn't appear to do anything. what is interesting is if I fiddle with that combobox formula, event if it is an error, it refreshes and the newThird appears. I just can't figure out why it doesn't do it normally.

Categories:
  • Future_Vision Profile Picture
    Future_Vision 634 on at
    Re: How do I reset a combobox after a patch to the comboboxes dataverse table?

    @v-xiaochen-msft 

    Below is what is on the submit button.

     

    If(
     !IsBlank(AddThirdParty_TB.Value) && IsBlank(
     LookUp(
     'Third Parties',
     crfeb_thirdparty = AddThirdParty_TB.Value
     )
     ),
     Patch(
     'Third Parties',
     Defaults('Third Parties'),
     {crfeb_thirdparty: AddThirdParty_TB.Value}
     );
     UpdateContext({newThird: {crfeb_thirdparty: AddThirdParty_TB.Value}});
     Set(
     add3rdPtyGRP,
     false
     );
     Set(
     add3rdPtyBTN,
     true
     );
     Set(
     add3rdPtyERR,
     false
     );
     MicrosoftTeams.PostMessageToChannelV3(
     Gallery1.Selected.id, Gallery1_1.Selected.id,
     {
     content: "Third Party Added: <br><b><span style=""color:#e67e22"">" & AddThirdParty_TB.Value & "</span></b> ",
     contentType: "html"
     }
     ),
     Notify(
     If(
     !IsBlank(AddThirdParty_TB.Value),
     AddThirdParty_TB.Value & " Already Exists",
     "Add Third Party Field is Blank"
     ),
     NotificationType.Error,
     2500
     );
     Set(
     add3rdPtyERR,
     true
     );
     
    );

     The datatype for the crfeb_thirdparty column is text.

     

    I'm not sure what you are looking for the newThird's formula. Are you talking about the formula used on the combobox for the DSI?

     

     

  • Re: How do I reset a combobox after a patch to the comboboxes dataverse table?

    Hi @Future_Vision ,

     

    Could you provide a formula for submitting data?

    What's data type of  crfeb_thirdparty column?

    What' newThird's formula?

     

    Best Regards,
    Wearsky

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics