Patch Lookup Field from Combobox

(0) Share

Report

Posted on by slhangen

356

Please help with coding.

Have form called EditSupplementalForm1

Need to patch following fields into new record:

Title, Narrative, Submitter, School

Am able to patch first 3 columns with following:

Patch('SRO Test List', Defaults('SRO Test List'),
{Title: valSupReportNumber.Text},
{Narrative: valSupNarrative.Text},
{Submitter: valSupSubmitter.Text}
)

Cannot figure out how to patch School column. School column is a multichoice lookup field populated from SP list name School.

Form combobox field to patch School column is named cboSupSchool.

Please help!

facepalm

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @slhangen ,

Please try with this.

Patch('SRO Test List', Defaults('SRO Test List'), {Title: valSupReportNumber.Text}, {Narrative: valSupNarrative.Text}, {Submitter: valSupSubmitter.Text}, {School: Filter(Choices('SRO Test List'.School),Id in cboSupSchool.SelectedItems.ID)} )

Hope this helps.

Sik

Was this reply helpful? Yes No
slhangen 356 on at

Like (0)

Report
Copy link

Link copied!

Perfect, just changed Id to Value and it worked like a charm. Thx a million.

Ran into another issue though:
Need to patch into SP column Date/Time.
Field type is date and time.
Input control is datacard Date/Time_DataCard2_1 with 3 dropdowns
Date dropdown is valSupDateTime
Hour dropdown is valSupHour
Minute dropdown is valSupMinute

Thx again!!!

Was this reply helpful? Yes No