Patch Lookup Field to CDS New Record

[FunGuy]

Need help patching a new record to CDS via patch for lookup field. I am mirroring the solution from :https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Patching-User-Lookup-on-CDM/m-p/366...; however not successful...

Entity: Asset

Lookup Field: Asset_Location

ComboBox1: (Choices(Assets.Location))

Formula: Patch( Asset, Defaults(Asset), {Asset_Location: ComboBox1.Selected})

-

Result: Location field is blank.

[v-monli-msft]

Hi @FunGuy ,

The Items property of the combo box should be:

Choices(Assets.Location)

Please remove "()" and try again.

And for Patch formula, it seems that you only included the "Asset_Location" field. Please make sure that all the Required fields are included in Patch.

Regards,

Mona

[FunGuy]

I was able to patch the other fields required THEN patch the appropriate lookup field to that record; however, I am unable to execute them together in one patch line. Is it possible to make it all one execution given that the lookup requires an existing record?

Formula:

Patch(Asset, Defaults(Asset), {Asset_Name: "Test123"});

Patch(Asset, Lookup(Asset,Asset_Name="Test123"), {Location: Lookup(Locations_Table, Location_Name=Combobox1.Selected.Location_Name)})

Is it possible to store a lookup value (not as a text) in a collection?

I was thinking maybe Collect all the input data then use ForAll function to patch the specific lookup values.