Answered

Patch multiple records in one row

(0) Share

Report

Posted on by twarb

Hello,

I'm trying to build an app in which employees at our company can fill in job sheets and submit them to an excel spreadsheet. So far I've got the patch command to work with my date picker and one of my drop-down lists with separate "submit" buttons but ideally I want them to be able to fill out their jobsheet, hit the "submit" button and have that submit all of the input data to one row (i.e name, date, team leader, client etc) is there a command that can do this or do I have to chain multiple patch commands together? In the case of the latter how would I join these two patch codes together as an example?

Patch(Table3,Defaults(Table3),{'Team Leader': Dropdown2.SelectedText.Value})
Patch('Table3',Defaults('Table3'),{Date:DatePicker1.SelectedDate})

Many thanks
TW

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Hi @twarb

I though you meant multiple items (i.e. rows) to your datasource.

To patch multiple fields, just extend the record in your patch statement to include all the fields in your record like as follows:

Patch(Table3,Defaults(Table3),{'Team Leader': Dropdown2.SelectedText.Value, Date:DatePicker1.SelectedDate, otherfield: "etc", otherfield:"etc"})

Hope this helps

Was this reply helpful? Yes No
twarb 28 on at

Like (1)

Report

Hi again @AmDev

Many thanks, I'm still a bit new to this so unsure of my way around some of the functions. Once again your wealth of knowledge has saved me; thank you!

TW

Was this reply helpful? Yes No