TRYING TWO SAVE THIS TWO DROPDOWN, I'M GOING CRAZY HEHEHE

[Gorilla_8]

I am trying to save two dropdowns and I can't make them save to my SP list, but it is a gallery of items and items that are adding follow the same pattern as the first selected item.

Can anybody help me?

These are dropdown fields and I followed the SHANE YOUNG repeating table on youtube.

Appreciate any help, I'm going crazy hehehe

[Gorilla_8]

I FORGOT THE PRINT WITH THE CODE rsrsr

[v-siky-msft]

Hi @Gorilla_8 ,

What is the type of TipodeDespesa column? Can you share the Items property of inputItemTiopdeDespesa? 

The error shows because "inputItemTiopdeDespesa.Selected.Value" is a Text, but TipodeDespesa not. You should add a "." dot behind 'TipodeDespesa' ,and try any autocomplete suggestions that appear. So it could be TipodeDespesa.Value.

Please have a try and check if your issue is fixed. If not, please post back more details.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

[Gorilla_8]

I tried to save this way, and unfortunately it was not possible, he kept saving but only the first school that the user makes in the gallery item, as if it was "default" the choice

[v-siky-msft]

Hi @Gorilla_8 ,

What is the type of TipodeDespesa column?

Can you share the Items property of inputItemTiopdeDespesa?

You are patching record to ExpenseDetails, and the Lookup source is also ExpenseDetails, is that right?

I think I need more app's design thought.

Best regards,

Sik

[Gorilla_8]

property of TipodeDepesa: 

Items -> Choices(ExpenseDetails.TipodeDespesa)

Default - >ThisItem.LineTipoDeDespesa

OnSelect -> select(parent)

Onchange -> false

but in card like "textinput" the property "onchange" = Set(NeedsSaved; true)

[Gorilla_8]

I found a solution, but it looks like the exclamation item

chek this: 

ForAll(Gallery1.AllItems;
If(!IsBlank(LineDescricaoDoReembolso);
Patch(
ExpenseDetails;
Defaults(ExpenseDetails);
{
Title: LineItem;
ItemCost: LineCost;
MasterID: Form1.LastSubmit.ID;
Viagem_destino: LineViagem_Destino;
DataDaViagem: DateValue(LineDataDaViagem);
Moeda_Viagem: Value(LineMoeda_Viagem);
TaxaDaViagem: Value(LineTaxaDaViagem);
DataDoReembolso: DateValue(LineDataDoReembolso);
N_x00fa_meroDoDocumento: Value(LineNumeroDoDocumento);
DescricaoDoReembolso: Text(LineDescricaoDoReembolso);
ValorGastoItemViagem: Value(LineValorGastoItemViagem);
ValorGastoItemEmReaisVALORFINAL: Value(LineValorGastoItemReaisValorFinal);
TipodeDespesa:
{
ID: LookUp(ExpenseDetails; TipodeDespesa.Value = inputItemTipodeDespesa.Selected.Value).ID;
Value: inputItemTipodeDespesa.Selected.Value
};
CentroDeCusto:
{
ID: LookUp(ExpenseDetails; CentroDeCusto.Value = inputItemCentroDeCusto.Selected.Value).ID;
Value: inputItemCentroDeCusto.Selected.Value
}
}
)
)
)

[v-siky-msft]

Hi @Gorilla_8 

If the column is Choices type, and you want to patch choices to SP list. You should put the following to the your formula

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

If the column is LookUp type,  you should put the following to the your formula

TipodeDespesa:
{ 
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: LookUp('Looked Up List ', 'Looked Up field' = inputItemTipodeDespesa.Selected.Value).ID),
Value: inputItemTipodeDespesa.Selected.Value 
} 

Best regards,

Sik