Unanswered

How do I use for all patch to increment dataverse field by 1 in a dataverse table?

(0) Share

Report

Posted on by lmcc

Hi there,

I am looking to have a button that, when clicked, increments the points column in a dataverse table by 1. The items come from a gallery labelled Gallery2_1.

The formula must check against a unique column called Name and then update the points column in that record.

Here is what I have tried, but it is not working.

```

ForAll(
Gallery2_1.AllItems,
Patch(
Students,
LookUp(
Students,
Name = ThisItem.Name
),
{
Housepoints: ThisItem.Housepoints + 1
}
)
)

```

Categories:

Building Power Apps

Screenshot 2023-0...

I have the same question (0)

All responses (3)

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
Hello @lmcc

I just did some rewriting but still similar idea to what you did:

With({ _items: Gallery2_1.AllItems }, ForAll(_items As X, Patch(Students,LookUp(Students,Name = X.Name), { Housepoints: X.Housepoints + 1 } ) ) )

Was this reply helpful? Yes No
lmcc 77 on at

Like (0)

Report

@cha_cha That is incredible. Please could you explain this code to me?

Just wow!

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Did it work?

I use the With function cause I like it when the code is tidy. It allows me to store the data on a temporary variable. This means the variable/property _items can only be within that With Function.

Also, the correct format to call records within a loop (ForLoop) is ThisRecord, not ThisItem. But I don't like ThisRecord cause it's long that is why I use X as a replacement for it. And I just did the same Patch as you did using X.

Lastly, I'm unsure if the code works fine with just the code below. ForAll/Patch doesn't work together if you are patching looping and patching the same data source. This is why I use With. Technically, Gallery2_1.AllItems and Students are different data sources, so the code without the With function could work. It was just a habit of mine.

ForAll(Gallery2_1.AllItems As X, Patch(Students,LookUp(Students,Name = X.Name), { Housepoints: X.Housepoints + 1 } ) )

Was this reply helpful? Yes No