Unanswered

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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

I FORGOT THE PRINT WITH THE CODE rsrsr

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

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
}
}
)
)
)

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No