Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Dropdowns and check boxes reset upon saving form

(0) ShareShare
ReportReport
Posted on by 246

Hi forum.

 

I have a form that has a dropdown (let's call it Dropdown1) field that is a lookup field from a 2nd Sharepoint list.  This field has 3 fields that are dependant on its value.  So when i choose a name from Dropdown1, it autopopulates the 3 other fields.  Until recently, when i go to save the form , Dropdown1 resets/goes blank on the form.  Which means that the other 3 fields are blank as well.  When i look on the Sharepoint, the dependent fields were saved but Dropdown1 did not.  

 

The Update property to Dropdown1 is pointing to Dropdown1.SelectedText.  <-- when i add .Value or .Result i get the red squiggly line.

 

The other fields are point to DD#.SelectedText.Result (with no error).

 

I am having the same issue with the Checkboxes (multiselect Choice column) when the tick mark does not stay ticked.  The ticks also used to stay ticked every though it was not saving to the Sharepoint list.  

 

Please help.  I am at my whits end.  I have tried everything that i know and have researched and nothing worked.  I am not sure  where to go from here.

 

Thank you for your time.

Categories:
  • Verified answer
    Misa Profile Picture
    Misa 246 on at
    Re: Dropdowns and check boxes reset upon saving form

    Hi @eka24.  I apologize for the delayed response.  For some reason it did not work.  I ended up deleting the field and started over.   I found this by Pavel Bludov and it finally worked.

     

    Added to the Default of the checkbox(s):  of course updating the Id and value based on the Checkbox:

    If(
    {
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    Id: 0,
    Value: "ILT"
    } in 'Delivery Method_DataCard2'.Default,
    true,
    false
    )

     

    OnCheck on all of the checkboxes: (are the same)

    ClearCollect(
    SelectedMethods,
    If(Checkbox1.Value,"ILT"),
    If(Checkbox2.Value,"VILT"),
    If(Checkbox3.Value,"Self-Paced")
    );
    ClearCollect(
    SelectedMethods,Filter(
    SelectedMethods,
    !IsBlank(Value)
    )
    );Set(ILT, true);UpdateContext({NoPricing: 0})

     

    I have the Update for the Datacard pointing at SelectedMethods.Value.

     

    Thank you for your help!!

  • eka24 Profile Picture
    eka24 20,921 on at
    Re: Dropdowns and check boxes reset upon saving form

    @Misa

    Is the issue resolved?

  • eka24 Profile Picture
    eka24 20,921 on at
    Re: Dropdowns and check boxes reset upon saving form
    Distinct('Vendor Information',Title)

    In the datacardvalue not the datacard:
    Dropdown1.SelectedText.Results
  • Misa Profile Picture
    Misa 246 on at
    Re: Dropdowns and check boxes reset upon saving form

    @eka24 

     

    Hi and thank you.  I don't receive an error when i submit the form.

     

    In the Items property of the control:  Sort(Distinct('Vendor Information',Title),Result)

     

    In the Update property of the datacard:  Dropdown1.SelectedText

    In the Default property of the datacard:  ThisItem.'Vendor Company Name'

  • eka24 Profile Picture
    eka24 20,921 on at
    Re: Dropdowns and check boxes reset upon saving form
    Kindly Display the error or formula used for the items property of the dropdown and the checkbox

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,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard