Power Platform Community Forum Thread Details

@RezzaB , @ShaneYoung , @DruvRn

I have a SharePoint list name Inventory and another SharePoint list name Desktop_Screen I have created a lookup column name Employee Code based on the title value of Inventory List as also based on the Employee Code column i have another reference column name location whose value is depend on the employee code value , there are two others columns one is employee name which is a people picker column and another column name department which is a drop down column as now i created a screen name desktop on visible i created a collection Clear Collect (inventorydata, Inventory) as now based on that i filtered my employee code value as filter(inventorydata , title) , others columns as

'Employee Name': LookUp(inventorydata,ComboboxCanvas1.Selected.Title in Title,EmployeeName.DisplayName),

Employee Code: Location : LookUp(inventorydata,ComboboxCanvas1.Selected.Title in Title,Location),

Department : - LookUp(inventorydata,ComboboxCanvas1.Selected.Title in Title,Department.Value)

now i my patching these values as

Patch(

Desktop_Screen,

Defaults(Desktop_Screen),

{

EmployeeCode: {

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

Id: ComboboxCanvas1.Selected.ID,

Value: ComboboxCanvas1.Selected.Title

'Employee Name': LookUp(

inventorydata,

Title = ComboboxCanvas1.Selected.Title,

EmployeeName

Department: LookUp(

inventorydata,

ComboboxCanvas1.Selected.Title in Title,

Department

'EmployeeCode: Location': {

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

Id: ComboboxCanvas1.Selected.ID,

Value: ComboboxCanvas1.Selected.Location

Title: DataCardValue1.Value,

ModelNumer: DataCardValue3.Value,

SerialNumber: DataCardValue4.Value,

HardDisk: DataCardValue5.Value,

RAM: DataCardValue11.Value,

Configuration: DataCardValue12.Value,

LEDModelNo: DataCardValue13.Value,

LEDSerialNo: DataCardValue14.Value,

Vendor: DataCardValue15.Value,

Status: DataCardValue16.Value,

DateofPurchased: DataCardValue17.SelectedDate,

IssuedDate: DataCardValue18.SelectedDate,

Value: Value(DataCardValue19.Value)

}

)

also Title column of desktop screen sharepoint list is auto generated id column whose formula is

"Desk-"&Text(Max(Filter(Desktop_Screen,StartsWith(ID,"Desk-")),Value(Mid(ID,6)))+1,"[$-en-US]0")

on select the submit button it shows error related to network error when using patch function : The specified column is generated by server and cannot be specified .

@RezzaB