cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Future_Vision
Post Prodigy
Post Prodigy

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

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.

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

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

 

Future_Vision
Post Prodigy
Post Prodigy

@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?

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,348)