Answered

Patching a LookUp not working

(0) Share

Report

Posted on by NthnClrksn

I am trying to patch multiple rows of a gallery to a dataverse table. I am having issues patching to the column that is a lookup.

Each item is added to galley by filling in the following:

The button adds the information to a collection which is used to drive a gallery that shows the following:

The item number comes from a combobox and it is added to the gallery using:

{

'Item Number': comboItemNumberTest.Selected.'Item Number',

}

When I then try to patch all of the values in the gallery table to the dataverse table. It does not patch the correct value. This is the code I use:

ForAll(

glyItemsForTesting_3.AllItems,

Patch(

'Testing Items',

Defaults('Testing Items'),

{

Available: 'Available (Testing Items)'.Yes,

'Batch Number': ThisRecord.'Batch Number',

Source: ThisRecord.Source,

'Item Number LookUp': First(

Filter(

'Item Designs',

'Item Number' = ThisRecord.'Item Number'

)

}

)

It is instead giving me the same item number for every case (the first item in the table) which means the filter is not working

I am however able to upload one at a time by patch the item that is selected in the gallery:

Patch(

'Testing Items',

Defaults('Testing Items'),

{

Available: 'Available (Testing Items)'.Yes,

'Batch Number': glyItemsForTesting_3.Selected.'Batch Number',

Source: glyItemsForTesting_3.Selected.Source,

'Item Number LookUp': First(

Filter(

'Item Designs',

'Item Number' = glyItemsForTesting_3.Selected.'Item Number'

)

}

)

It seems to me that "ThisRecord" does not work for this but I can't figure out why.

I also tried doing the for all for the collection instead of the gallery but the same thing happened.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

NPPlatform 606 Moderator on at

Like (0)

Report
Hi @NthnClrksn , my first suggestion would be to try and use an As-statement. This helps specify what you exactly mean with 'ThisRecord'. It might solve this issue for you. The code then would be:

ForAll(

glyItemsForTesting_3.AllItems As ItemsToPatch,

Patch(

  'Testing Items',

Defaults('Testing Items'),

{

Available: 'Available (Testing Items)'.Yes,

  'Batch Number': ItemsToPatch.'Batch Number',

Source: ItemsToPatch.Source,

  'Item Number LookUp': First(

Filter(

  'Item Designs',

  'Item Number' = ItemsToPatch.'Item Number'

)

)

}

)

)

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like (0)

Report
@NthnClrksn In addition: why do you use the First(Filter())-combination instead of LookUp? For example like:

LookUp(
'Item Designs',
'Item Number' = ItemsToPatch.'Item Number'
)

Was this reply helpful? Yes No
NthnClrksn 10 on at

Like (1)

Report

@NPPlatform
Thank you for your help!

I do that at the moment because some of the records are duplicated so the lookup would not give a definite answer.

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like (0)

Report

Understandable, glad you got it working!

Was this reply helpful? Yes No