Patch multiple values on condition

(0) Share

Report

Posted on by JM-14081323-0

Hello,

what is the best solution for this?

I want to do a batch record to a table where there shall be in columns Employee (on the left, checkboxes), Block (combobox, more choices) and Date (datepicker)

It should write down like this:

Antonín Zeman	000-USW sváření	05.02.2025
Antonín Zeman	000-Vstřikování	05.02.2025
Antonín Zeman	000-Testování	05.02.2025
Jarda Venca	000-USW sváření	05.02.2025
Jarda Venca	000-Vstřikování	05.02.2025
Jarda Venca	000-Testování	05.02.2025

and in addition test if any of these records are already there.

Both employees and blocks form its own collection which is to be seen in the galleries.

Thank you for your ideas

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you clarify a few things

1. Can you please list the columns and column types as well as for instance if choices are multi-select as all this makes a huge difference in patching, especially in batches.

2. I am guessing you do mean separate records (as your table shows)

3. I am unsure how to tell you if a record already exists unless a) you are already loading existing records and its an update, or if you need to do a "validation" that the record exists because it matches some criteria, which means you aren't going to be able to do this in batches. Not in a single call.

4. Are the other 3 columns (not the person one) the other choices? And is it 3 single select choices?

Was this reply helpful? Yes No
Akah Mandela 445 on at

Like (0)

Report
Use collections for employees and blocks.

Create a ForAll loop for batch processing.

Check for duplicates before inserting using LookUp.

Use Patch for inserting new records.

Step 1: Prepare Collections (If Not Already Created)

// Example collection for employees
ClearCollect(colEmployees,
{Name: "Antonín Zeman"},
{Name: "Jarda Venca"}
);

// Example collection for blocks
ClearCollect(colBlocks,
{BlockName: "000-USW sváření"},
{BlockName: "000-Vstřikování"},
{BlockName: "000-Testování"}
);

Step 2: Batch Insert with Duplicate Check

Assume:

colSelectedEmployees contains selected employees from the gallery (checkboxes).

colSelectedBlocks contains selected blocks from the combobox.

dpDatePicker.SelectedDate is the selected date from the date picker.

Target table: EmployeeBlockTable.

ForAll(
colSelectedEmployees,
ForAll(
colSelectedBlocks,
If(
IsBlank(
LookUp(
EmployeeBlockTable,
Employee = ThisRecord.Name &&
Block = BlockName &&
Date = dpDatePicker.SelectedDate
)
),
Patch(
EmployeeBlockTable,
Defaults(EmployeeBlockTable),
{
Employee: ThisRecord.Name,
Block: BlockName,
Date: dpDatePicker.SelectedDate
}
)
)
)
);

Hope this helps you out

Was this reply helpful? Yes No
JM-14081323-0 93 on at

Like (0)

Report

Hello and thanks for your interest.

Yeah, the collections are already created. Everything you are assuming is right.

This is how it looks now for me (not yet implemented update of the column Platnost (datepicker) if the record is found):

ForAll(

colDelnikhrom;

ForAll(

colBlokyhrom;

If(

IsBlank(

LookUp(

DelnikVNKN;

Delnik = ThisRecord.Delnik &&

VNKN = Seznam

)

);

Patch(

DelnikVNKN;

Defaults(DelnikVNKN);

{

Delnik: ThisRecord.Delnik;

VNKN: Seznam;

Platnost: DatePickerHrom.SelectedDate

}

)

)

)

)

I am getting errors in Lookup part:

These types cannot be compared: record, record

These types cannot be compared: record, text

and in Patch part:

type of argument "crf13_delnik" is not expected type Record. Found type error.

DelnikVNKN is the table in question. Delnik is lookup column into Delnik table where the name of the employee is column Jméno. VNKN is lookup column into the VNKN table where the name of the block is column Seznam. Platnost is dateformat column in DelnikVNKN table itself. Choices in combobox (blocks) are indeed multiselect allowed.

In DelnikVNKN table there can already be a record which matches the combination of Delnik and VNKN. On this event I only want to update a date. I this combination is not there, then to set up a whole new record (Delnik, VNKN, Platnost).

I will continue try to get it done somehow, if you can help me some more with the formulas, thank you in advance

Was this reply helpful? Yes No