I've read through several posts that mention that a lookup column is a record, and so when you go to Patch, you need to provide a full record. I have a form that saves successfully to my primary table, then I have a gallery that I'm saving onSuccess on the form being submitted. The code for this is:
ForAll(RoomsCollection, If(!IsBlank(LineItemDate),Patch('Meeting Guest Room Dates', Defaults('Meeting Guest Room Dates'), {cr623_primaryname:Text(LineItemDate), cr623_date:LineItemDate, cr623_singles:SingleRooms, cr623_MeetingServicesSiteResearch:Form2.LastSubmit})))
RoomsCollection is a collection that is initialized coming into the screen, and my 'Meeting Guest Room Dates' is the table I'm trying to save to that has the following fields:
The error I get is:
As I understand it, LastSubmit is a record, and therefore setting cr623_MeetingServicesSiteResearch to this record should work.

Report
All responses (
Answers (