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)

Sort by

Verified answer

NPPlatform 606 Moderator on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!
@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
Copy link

Link copied!

@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
Copy link

Link copied!

Understandable, glad you got it working!

Was this reply helpful? Yes No