Firstly, thanks ever so much for the time you are taking on this.
To answer your questions -
Here are my data sets, there are two environments I am looking at, a Development and a Staging. The Staging environment has the _1 at the end of the name and it is this environment I am currently pointing everything to.
Yes, I am pointing the Gallery Control to the Campaigns_1 table in the staging environment. The Gallery is called CampaignGallery.
SortByColumns(Search(Campaigns_1, CampaignSearch_CS.Text,"name"), "name", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
The following is my patch lines
Patch(
Leads_1,
Defaults(Leads_1),
{
subject: "Tradeshow App Generated",
firstname: FirstName_BCR.Text,
lastname: LastName_BCR.Text,
campaign_1: CampaignGallery.Selected.campaign_1
}
)With this I get the error that Campaign_1 is not a field in the table, so I change it to the following
campaignid: CampaignGallery.Selected.campaign_1
campaignid is the schema name for the lookup column in the Leads_1 table, however when I change it to this I get the following error
The type of argument 'campaignid' does not match the expected type 'Record'. Found type 'Error'.
I get a different error when I link it to Campainid at the end
campaignid: CampaignGallery.Selected.campaignid
here i get the error
The type of argument 'campaignid' does not match the expected type 'Record'. Found type 'Guid'.
so I assuming that whatever is at the end of that line needs to be the type of record.
here is the solution line for the campaign lookup on the lead entity
