Sp list value reduce based on powerapps patch

[Dhinesh28R]

Hi,

This is my SP List,

Before Completing Selection

Position	Openings	Status
Developer	2	In-Progress

After completing Selection,

Position	Openings	Status
Developer	2	Completed

After status getting completed i need to update a Openings into "O".

How to update this?

Thanks,

Dhinesh 

[v-albai-msft · Accepted solution]

Hi @Dhinesh28R ,

What's the column type of your Openings and Status column?
Do you want to change Openings to a text "O" or to a number 0?
I assume that the Openings column is a Number column and the Status column is a Choice column, and you want to change it to number 0, so you can try this formula:

UpdateIf(listname,Status.Value="Completed",{Openings:0})

If this is a Text column, try this formula:

UpdateIf(listname,Status.Value="Completed",{Openings:"O"})

Best regards,

Allen

[Dhinesh28R]

@v-albai-msft,

It's working man.

Thanks