Store new collection with lookup link

(0) Share

Report

Posted on by Aionik

103

Hello,

I want to store in the collection a dropbox value that is selected and link it to the lookup column in the other collection.

I have two tables, one is Modelseries and the other is the Component.

Modelseries (Sharepoint)

Component (Sharepoint)

Title
Manufacturer [LookUp]

Model [Text]

Title
Modelseries_Model [LookUp]

Component_Name [Text]

This is my code:

Collect(
 colComponent;
 { 
 Component_Name: txtControllerLib_Modell.Text;
 Modelseries_Model : {
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
 Value:drp_modelserie.Selected.ModelOption}; 
 }
);;

I want to create a new entry in the collection that is linked to the model series and has stored a new component. The selected dropbox value is a record.

Any help is welcome.

Categories:

Building Power Apps