Calculations with Text Input and Patch to Data Source

(0) Share

Report

Posted on by CC-19121430-0

240

Hello Everyone,

Hope you are all well,

I am a bit stuck, I have a Text Input within a gallery that i need to be 2 other text inputs added together. I also need it to patch back to my data source and update the cells within that. The problem is that isn't currently happening.

I am using this as the default property of that text input:
Round(TextInput1 + TextInput1_1,2)

The OnChange property is:

Patch(Calcs2,ThisItem,{'Payroll £ value ':TextInput1_2.Text})

Any help as always is very much appreciated!

Many Thanks

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

SebS 4,686 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Appy1

Change Round(TextInput1 + TextInput1_1,2) to :

Round(TextInput1.Text + TextInput1_1.Text,2)

Than Patch if Your column is type Number

Patch(Calcs2,ThisItem,'Payroll £ value ': Value(TextInput1_2.Text))

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Hello @SebS

Thanks for your suggestion, i have given it a go and seem to be getting an error on the Patch - OnChange.
Are you able to advise?

Thanks very much
Chris

Was this reply helpful? Yes No
SebS 4,686 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Appy1

My bad forgot about {} 🙂

Patch(Calcs2,ThisItem,{'Payroll £ value ': Value(TextInput1_2.Text}))

try again

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Hi @SebS ,

Thanks, still not quite working unfortunately.

This is now the error received:
Many thanks
Chris

Was this reply helpful? Yes No
SebS 4,686 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Appy1

Sorry, that must be me today 🙂 all that typos today not good 🙂

Patch(Calcs2, ThisItem, { 'Payroll £ value': Value(TextInput1_2.Text)})

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Thanks! @SebS

Haha no worries, one of those days 😄 The formula now works and no error there.

Unfortunately it doesn't seem to be patching it to my data source though the cells happen to still be blank there.

Many thanks
Chris

Was this reply helpful? Yes No
SebS 4,686 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Appy1

The problem is not in Patch but in how you want to patch it.

You are using OnChange if the expectation is that when TextInput1 and TextInput2 will be input, that will trigger TextInput1_2.Text OnChange will never happen without physically pressing something that controls, so question is, in what control property are you using on change ?

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Hi @SebS

Sorry i seem to have accidentally accepted the solution rather than click reply, i hope you can still help me please.

I think i understand what you are saying, is it that i would need a save button? Is that would your recommendation would be?

Thanks
Chris

Was this reply helpful? Yes No
SebS 4,686 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Appy1

if you input data to text inputs in a sequence like TextInpu1 than TextInput2 and after TextInput2 is submitted You want result of TextInput to be Patch to DataSource one of the options for You will be place code in OnChange of TextInput2 property other than that Save button will do the job

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Thanks @SebS

What formula would I need to use within my ONSelect property of my save button?

Kind Regards
Chris

Was this reply helpful? Yes No