Cascading drop-down not saving onto SharePoint

[PM6]

Hi all

I have only one data source (TblComplaintsDataSP) which has the following columns:

Area (Choice column)

AreaProcessDetail (Choice column)

Root Cause (Choice column)

Root Cause Detail (Choice column) 

On my App, I have coded it so the dropdowns on both AreaProcessDetail and RootCauseDetail only show the choices I want depending on the option selected on both Area and Root Cause.

Here's an example, the code on the app for the "Area" datacard is: 

- Update property: drpArea.Selected.Value

Now the code for the actual dropdown is:

- Items: Choices([TblComplaintsDataSP].Area

The dropdown is working fine, but it is not saving onto the SharePoint when I click the Save button (Patch(TblComplaintsDataSP, galComplaintsGallery.Selected, frmPhase2.Updates);
Navigate(DataPage, ScreenTransition.Fade);
Refresh(TblComplaintsDataSP);)

I'll give you the code for the cascading dropdown dependant on "Area":

- Items: If(drpArea.Selected.Value = "ER Admin",
["Account Closures", "Additional admin accounts", "Change of Company Details", "Contact Maintenance", "Email Communication", "File upload issues", "Inbound call", "Insolvencies", "Manual Payments", "Outbound call", "Tax Relief"],
If(drpArea.Selected.Value = "Transfers",
["Due diligence", "Email Communication", "Inbound call", "Manual Payments", "Origo - Transfer in", "Origo - Transfer out", "Outbound call", "Payment allocation", "Pension sharing orders", "Transfer in - Paper", "Transfer out - Paper"],
If(drpArea.Selected.Value = "Small Pots",
["Email Communication", "Inbound call", "Manual Payments", "Outbound call", "Small Pot claim"],
If(drpArea.Selected.Value = "Member Admin",
["FAD Claims", "Inbound call", "LOA's", "LSRB Claim", "Manual Payments", "MIP's", "Outbound call", "Projections", "UFPLS Claims"],
If(drpArea.Selected.Value = "Banking (Members)",
["BACS", "Email Communication", "Inbound call", "Manual Payments", "Outbound call", "Payment allocation", "Personal Payments"],
If(drpArea.Selected.Value = "Banking (Employers)",
["BACS", "Direct Debit", "Email Communication", "Inbound call", "Manual Payments", "Outbound call", "Payment allocation"],
If(drpArea.Selected.Value = "Accident & Bereavement",
["Bereavement", "EAC", "ELC", "Email Communication", "Ill health", "Ill health - Terminal", "Inbound call", "Manual Payments", "Outbound call"],
If(drpArea.Selected.Value = "Support Hub",
["DPA", "Email Communication", "EOS - User", "Inbound call", "Opt Out - Missed window", "Opt Out - Joiner pack", "Outbound call"],
If(drpArea.Selected.Value = "Transfer Guidance",
["Email Communication", "Inbound call", "Manual Payments", "Outbound call"],
If(drpArea.Selected.Value = "IT",
["EOS - System issues", "Hardware failure", "MyProducts", "System Outage"],
If(drpArea.Selected.Value = "Key Accounts",
["Additional admin accounts", "Change of Company Details", "Contact Maintenance", "Email Communication", "File upload issues", "Inbound call", "Manual Payments", "Outbound call"],
If(drpArea.Selected.Value = "Non CS",
["EOS", "ESU", "General public", "Marketing", "MyProducts", "Rename", "Website"],
If(drpArea.Selected.Value = "Complaints",
["Email Communication", "Inbound call", "Manual Payments", "Outbound call"],
If(drpArea.Selected.Value = "Resolutions",
["Email Communication", "Inbound call", "Manual Payments", "Outbound call"],
If(drpArea.Selected.Value = "Postroom",
["Email Communication", "Inbound Post", "Outbound Post"],
If(drpArea.Selected.Value = "Data Integrity",
["Email Communication", "Inbound call", "Manual Payments", "Outbound call"],
[]
))))))))))))))))

Again, the cascading dropdown is working fine, the choices shown are the ones that are meant to be showing based on the choice selected in "Area". But neither seem to be saving onto the Sharepoint.

Thanks in advance!!

[v-qiaqi-msft]

Hi @PM6,

Actually, the Choice column expects a record type value instead of a text value as you wrote like drpArea.Selected.Value.

Please modify the Update property of drpArea data card as below:

drpArea.Selected

And modify the Update property of data card including the cacading dropdown control as below:

drpAreaProcessDetail.Selected

Please repeat the above steps for the other two dropdown controls.

[PM6]

Hi Qi

Thanks for the reply!

When I try to change the Update property to drpArea.Selected, I get an error message saying "Expected Text value" - which I don't really understand since my column on SP is Choice.

Any idea why this might be happening?

Thanks

[v-qiaqi-msft]

Hi @PM6,

So weird.

Try:

{Value:drpArea.Selected.Value}

If it does not work either, try the following formula even thgough I think it is impossible:

drpArea.Selected.Area

[PM6]

Hi @v-qiaqi-msft 

That doesn't seem to be working either - still expects a Text value. This is why I'm struggling as the rest of the dropdowns on the form are a record value and are working fine, it just seems to be these 4 and the only difference between them is that they're cascading.

Thanks for the help anyway! I'll continue to try different things but do let me know if anything else comes to mind!

Thanks again 🙂

P

[v-qiaqi-msft]

Hi @PM6，

If it is convenient for you, please attach a GIF of your form settings and all the Choice column settings.