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)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
ancorte 94 on at

Like (0)

Report

Thanks for your helpful, but it seems that don't accept the comma "," after SPListExpandedReference",
it is underlined in red.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @ancorte ,

What is the error message could hove on the error to see the error message.

Was this reply helpful? Yes No
ancorte 94 on at

Like (0)

Report

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
}

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ancorte 94 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

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
}

Was this reply helpful? Yes No
ancorte 94 on at

Like (0)

Report

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)

Was this reply helpful? Yes No