List value not increment

[Dhinesh28R]

Hi,

I have to update my list value by incrementing 1.

But its not getting updated.

Set(RP,LookUp(List,Field=Gallery.Selected.Field,People));

Patch(List,LookUp(List,Field=Gallery.Selected.Field),{People:RP+1});

But its not getting Increment in List

Thanks,

Dhinesh

[CNT]

@Dhinesh28R Is the global variable RP having a number set? What is the datatype of the People column?

[Dhinesh28R]

@CNT  People column is a Number type. Rp is a Global Variable.

[CNT]

@Dhinesh28R Check the value in RP and make sure it is not blank.

[Dhinesh28R]

@CNT , Yes man. It Is Blank.

Now what to do?

Thanks

[CNT]

@Dhinesh28R If Rp is blank it means that your LookUp is not returning any records. You'll have to sort that out. 

[Dhinesh28R]

@CNT  In my List people column doesn't have any value means it's Blank correct.

People

Set(RP, LookUp(List, Field=Gallery.Selected.Field, People));

Now RP is Blank correct.

If it is blank how to Increment + 1 value in People filed.

Thanks

[CNT]

@Dhinesh28R Change the Set to this,

With({varRP:LookUp(List,Field=Gallery.Selected.Field,People)},
Set(RP,If(IsBlank(varRP),1,varRP))
);

[Dhinesh28R]

@CNT , Its getting values in RP man.. But not updating on a List man.

[CNT]

@Dhinesh28R Check if LookUp(List,Field=Gallery.Selected.Field) is blank.