cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhinesh28R
Post Prodigy
Post Prodigy

Sp list value reduce based on powerapps patch

Hi,

This is my SP List,

Before Completing Selection

PositionOpeningsStatus
Developer2In-Progress

 

After completing Selection,

PositionOpeningsStatus
Developer2Completed

 

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

 

How to update this?

 

Thanks,

Dhinesh 

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-albai-msft
Community Support
Community Support

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

View solution in original post

@v-albai-msft,

It's working man.

Thanks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,657)