You’re offline. This is a read only version of the page.
10
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 item number comes from a combobox and it is added to the gallery using:
Understandable, glad you got it working!
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.
@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'
)
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'
)
)
}
)
)
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
