Issue with OnChange Combobox inside the gallery

(0) Share

Report

Posted on by Rhk

133

I’m trying to patch the changes into the collection.

This combobox is single selected value and searchable.
I’m using OnChange function of the combobox where I’m patching the changes into the collection.
Here is the code I tried.

Patch(Collection1, ThisItem, {Currency : Self.selected.Value,
ModifiedData: If(ThisItem.ModifiedData ="C","C",ThisItem.ModifiedData="N","N","M")})

I tried removing modified data and then it is working fine.
In Defaultselectedvalue, I’m passing this value.

{Value: ThisItem.Currency}

What is wrong with the formula?

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Rhk 133 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz , @developerAJ Can you help me out with this?
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rhk ,

After Checking your formula, we found that there is a mistake in your formula.
Patch(Collection1, ThisItem, {Currency : Self.Selected.Value,
ModifiedData: If(ThisItem.ModifiedData="C","C",ThisItem.ModifiedData="N","N","M")})

Best Regards,
Tina
Rhk 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Hii Tina,
Thanks for your reply, Sorry about that, It was a typo.
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rhk ，

Have we solved this issue, or it is just a typo?
If it is just a typo, can you offer the Items of the Gallery and the formula about the Collection1?

Best Regards,
Tina
Rhk 133 on at

Like
a
(0)

Report
Copy link

Link copied!

I’m store the sql data in Collection and I have few columns ex- FName, LName, Currency, ModifiedData.
Where FName and LName are Text Inputs and On Change is as same as the combobox but the column name and values will be changed but ModifiedData will be same, If they do some changes in that field then That item’s modifiedData should update with “M”… It stays “N” if it is “N” by default.