Power Platform Community Forum Thread Details

Hello, I have created a SharePoint Form Power App. The list contains a multi-select Lookup column ( named Lookup_Main ) and its one Additional column ( named Lookup_Additional ).

When the FormMode.Edit, the App works, and the list gets updated easily!

In FormMode.New, I get below error always. How to resolve this?

Here is the entire code I tried. I tried making Lookup_Main as required and not required as well. Both don't seem to work!

Update property of "Lookup Additional Column"
------------------------------------------------------------------------------
If(
 SharePointForm1.Mode = FormMode.New,
 Table(
 ForAll(Lookup_Main.SelectedItems,
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Value: LookUp(MasterProductData, Product = Value).Title,
 Id: LookUp(MasterProductData, Product = Value).ID
 }
 )
 ),

 SharePointForm1.Mode = FormMode.Edit, Lookup_Additional.SelectedItems,

 SharePointForm1.Mode = FormMode.View, Lookup_Additional.SelectedItems
)


Items Property of "Lookup Additional Column" not changed!
-------------------------------------------------------------------------------------------------
Choices([@'(Test) CBN_TBN_List'].Product_x003a__x0020_Title)


DefaultSelectedItems Property of "Lookup Additional Column"
-------------------------------------------------------------------------------------------------
If(
 SharePointForm1.Mode = FormMode.New,
 Table(
 ForAll(Lookup_Main.SelectedItems,
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Value: LookUp(MasterProductData, Product = Value).Title,
 Id: LookUp(MasterProductData, Product = Value).ID
 }
 )
 ),

 SharePointForm1.Mode = FormMode.Edit, Parent.Default,

 SharePointForm1.Mode = FormMode.View, Parent.Default
)

Categories:

Building Power Apps