web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Formula to patch multi...

Power Apps

Answered

Formula to patch multi checkboxes and each box is a column

(0) Share

Report

Report

Posted on by Mo78

249

I have this form and am trying to patch check boxes based on the selection. probably will select one or more based on the requirement.

is there away to patch them by button as shown or what I showed do. each check box is a data card.

like 1-E2 account update_DataCard1 is a data card and the check box value is = DataCardValue9

and so for each one.

please help

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Mo78 249 on at

Like
a
(0)

Report
Copy link

Link copied!

I used this formula. and it did work. but it does record each one of them individually. is it possible to collect all of them in one record when updated?

Patch('Onboarding Work Tracker',ThisItem,{'1-E2 account update':Value(Value(DataCardValue9.Value))});Patch('Onboarding Work Tracker',ThisItem,{'2-OS/FLM-IT Attribute added in SWB':Value(Value(DataCardValue10.Value))});Patch('Onboarding Work Tracker',ThisItem,{'3-TMC-IT Staffing Category updated in SWB':Value(Value(DataCardValue16.Value))});Patch('Onboarding Work Tracker',ThisItem,{'4-Supervisor added in SWB':Value(Value(DataCardValue13.Value))});Patch('Onboarding Work Tracker',ThisItem,{'5-Request laptop for new OS':Value(Value(DataCardValue11.Value))});Patch('Onboarding Work Tracker',ThisItem,{'6-Training start date in SWB for trainees':Value(Value(DataCardValue18.Value))});Patch('Onboarding Work Tracker',ThisItem,{'7-Notify Training SSPs of new AG/CPCIT/PE':Value(Value(DataCardValue17.Value))});Patch('Onboarding Work Tracker',ThisItem,{'8-Timecard first PP':Value(Value(DataCardValue19.Value))});

Looking for any help please.

Thanks

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Mo78 ,

Please try:

Patch( DataSource, Defaults(DataSource), Patch( If(CheckBox1.Value,{'Column1':DatePicker1.SelectedDate},{}), If(CheckBox2.Value,{'Column2':DatePicker2.SelectedDate},{}), If(CheckBox3.Value,{'Column3':DatePicker3.SelectedDate},{}), If(CheckBox4.Value,{'Column4':DatePicker4.SelectedDate},{}), If(CheckBox5.Value,{'Column5':DatePicker5.SelectedDate},{}) ) )

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation