cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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

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

7 REPLIES 7
Highlighted
Post Prodigy
Post Prodigy

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

I FORGOT THE PRINT WITH THE CODE rsrsr

Highlighted
Community Support
Community Support

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

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.

Highlighted
Post Prodigy
Post Prodigy

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

Sem título.png

 

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

Highlighted
Community Support
Community Support

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

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

Highlighted
Post Prodigy
Post Prodigy

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

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)

Highlighted
Post Prodigy
Post Prodigy

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

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

Highlighted
Community Support
Community Support

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

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,790)