cascade dropdown field value not saved in a list

(0) Share

Report

Posted on by ancorte

Hello, i've read many post but unable to resolve the problem.

I have a list with 2 lookup field "Pratica" and attivita". These 2 field are in an other list.

reading, post and webinar, i modify the list with power app, and i've been able to create the cascade look up.

But when i try in a list to add a new field, the field "Pratica" and "Attività" that i choosed from the dropdown are not saved.

I think that i have to modify the update item of the Datacard.

name of the field of the datalist "Pratica"

name of the datacard dropdown "Pratica_Datacard1"

name of teh dropdown in this card is "Pratica1"

In the edit of the Pratica_Datacard1" i wrote:

{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: Pratica1.Selected.Value,
Value: Pratica1.Selected.Value
}

But there is an errore, and the app doesn't functions.

Very grateful if someone can help me.

(sorry for my writing, i am from Italy)

All responses (8)

Answers (0)

ancorte 84 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

Nothing, every modification that i make i have always the same error in the comma ',' after
"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", in red
So i don't know if there are other errors..

Spoiler (Highlight to read)
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

hi @ancorte ,

In the code you sent I can see a extra , and Pr_Att_St1', Pratica
Is it 'Pr_Att_St1'.Pratica or Pratica.Selected.Id because together its wrong

{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: ('Pr_Att_St1', Pratica = Pratica.Selected.Id,),
Value: Pratica.Selected.Value
}
ancorte 84 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

Ok, I modified like this:
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: ('Pr_Att_St1', Pratica = Pratica.Selected.Id,),
Value: Pratica.Selected.Value
}
Pr_Att_St1 is a list that contains the elements where look up.
Pratica is the field of Pr_Att_St1 list

But doesn't function, it gives me an error, the "," is underline in red "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", <--------
I dont' know what to do.
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

Hi @ancorte ,

Please use the column from the parent lookup list. The ID should the id of the item and Value should be the Text value you looked up. Please update the column name according to your datasource.
ancorte 84 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

Hello,
in bold the error (in red in the immagine).
Thanks for your help
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
Id: Pratica1.Selected.Id;
Value: Pratica1.Selected.Value
}
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

Hi @ancorte ,

What is the error message could hove on the error to see the error message.
ancorte 84 on at

Like (0)

Report

Re: cascade dropdown field value not saved in a list

Thanks for your helpful, but it seems that don't accept the comma "," after SPListExpandedReference",
it is underlined in red.
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Re: cascade dropdown field value not saved in a list

Hi @ancorte ,

If error is on Code. Please try below code if it helps
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: Pratica1.Selected.Id, Value: Pratica1.Selected.Value }

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.