Unanswered

Updating items which are based on other elements in gallery,

(0) Share

Report

Posted on by Draqon

Hello, have a gallery which has elements, that I'd like to allow edit. The problem is that some of them are based on other and they are not updating in sharepoint list.

I need Rate per KM and VALUE/Total in PLN elements updated based when other values (Type of Car and No. of KM). I've edited OnChange value so it would update in a way that I'd like that to happen but nothing's changing. Any idea how to fix that?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Loose Chippings 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Draqon

This may be very simple. Try changing the semicolons in your Patch() statement to commas:
Patch('mileage-report', This.Item, {'Rate per KM': Value(TextInput1_3.Text}))

I can't tell if your 'Total in PLN' is a number field or calculated column in SharePoint. Instead of patching Value(TextInput1_3.Text) try patching the value of the Dropdown.Selected instead:

Patch('mileage-report', This.Item, {'Rate per KM': Dropdown3.Selected.Value})

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Draqon ，

Do you want to update Rate per KM and VALUE/Total in PLN when Type of Car and No. of KM change?

If so, you should set controls for Type of Car and No. of KM's OnChange about formula to update Rate per KM and VALUE/Total in PLN.

For example,

set drop down for Type of Car's OnChange:

Patch(...,.....,{'Rate per KM':....})

set textinput for No. of KM 's OnChange:

Patch(...,.....,{'VALUE/Total in PLN':....})

Best regards,

Was this reply helpful? Yes No