Good morning Group
I have a SharePoint list named “Encuestas”, from SharePoint I generate an Automatic PowerApps from this list.
This automatic application generates an Edit Form named EditForm1 and in the DataCardValue14 drop-down list in the items property I have: Choices([@Encuestas].'Se Promueve la Innovación'), which gives me the option of “Si” and “No”. . If I choose Si, it shows me the options from another drop-down list in DataCardValue19 with the options to choose from.
In the DataCardValue19 drop-down list, one of the eligible options is “N/A”, how can I configure the DataCardValue19 so that if DataCardValue14 = “No”, DataCardValue19, the option I register is “N/A” without choosing it from the list
Due to locale settings, My statement separator is ;
I have made several attempts at the formulas that I show below, but it leads me to error.
//If(DataCardValue14.Selected.Value = "No" || Text(DataCardValue14.Selected.Value) = "No"; "N/A"; LookUp([@Encuestas]; 'Se Promueve la Innovación' = "N/A").ID)
//If(DataCardValue14.Selected.Value = "No" || Text(DataCardValue14.Selected.Value) = "No"; "N/A"; LookUp([@Encuestas; Title = "N/A").ID)
//If(DataCardValue14.Selected.Value = "No"; DataCardValue19.Selected.Value = "N/A")
Thank you in advance
