Dropdowns and check boxes reset upon saving form

(0) Share

Report

Posted on by Misa

248

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Kindly Display the error or formula used for the items property of the dropdown and the checkbox

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Distinct('Vendor Information',Title)

In the datacardvalue not the datacard:
Dropdown1.SelectedText.Results

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

@Misa
Is the issue resolved?

Was this reply helpful? Yes No
Verified answer

Misa 248 on at

Like (0)

Report
Copy link

Link copied!

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!!

Was this reply helpful? Yes No