Answered

Patching from a gallery and creating new items

(0) Share

Report

Posted on by aborodin

Tried to figure this out all day yesterday. Have consulted https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-gallery-item-in-SP-list/td-p/1758662 regarding the proper syntax from patching records to a gallery:

Right now, I have the following gallery:

The gallery items are from the "members" table. The "txt_calendarday_id" control pulls from a field in this table, and the "drp_calendarday_activity" and "txt_calendarday_location" are meant to be input controls only.

I'd like to patch to a third table, "memberlocations." that has four columns:

DateRecord:

MemberID

Location

Activity

I believe my syntax is wrong. I've written my patch function like this:

Patch(
ForAll(gal_calendarday_form.AllItems,
{
MemberID:txt_calendarday_formID.Text,
DateRecord:gblSelectedDay,
MemberLocation:txt_calendarday_formlocation.Text,
Activity:drp_calendarday_activity.Selected
}
)
)

It is giving me an error of: Patch expected a record but is getting a table from my ForAll. Am I misunderstanding how this works?

Thanks for your help!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aborodin ,

Try below:
ClearCollect(gallery_items,gal_calendarday_form.AllItems); Patch( gallery_items, Defaults(gallery_items), { MemberID:txt_calendarday_formID.Text, DateRecord:gblSelectedDay, MemberLocation:txt_calendarday_formlocation.Text, Activity:drp_calendarday_activity.Selected.Value } )

Patch cannot directly operate on the gallery.allitems, instead, it needs a collection or a table datasource.

BR,
Hen Wang
Verified answer

HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aborodin ,

Just be the way, it seems that you are trying to collect all the items inside this gallery to a new table, if yes, then you can try below formula:
Collect(third_table, ForAll(Gallery1.AllItems, { MemberID:txt_calendarday_formID.Text, DateRecord:gblSelectedDay, MemberLocation:txt_calendarday_formlocation.Text, Activity:drp_calendarday_activity.Selected.Value } ) )

BR,
Hen Wang
aborodin 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hen,

Thanks so much! This worked!