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