Power Platform Community Forum Thread Details

Hello all,

I have the code below that tries to find a part description in a sharepoint list if a collection value is empty. EditItems is my collection and 'Part Descriptions' is my sharepoint list.

The issue is that the code below doesn't seems to be able to properly reference EditItems[@'Part Number'], I continue to get blank values after this code runs. If I replace EditItems['Part Number'] with an actual part number then the code correctly finds the match.

Is there a way to adjust the code below to find the corresponding EditItems 'Part Number'?

UpdateIf(
 EditItems,
 'PartDescription' = Blank(),
 {
 'PartDescription': LookUp(
 'Part Descriptions',
 'Part Number' = EditItems[@'Part Number'],
 'Short Description'
 )
 }
)

Thanks,

Travis

Categories:

Building Power Apps