web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Remove specific values...

Power Apps

Answered

Remove specific values from status column and display the rest as dropdown values in powerapp

(0) Share

Report

Report

Posted on by aparnaa

95

In sharepoint list backfill, I have a choice column called status.

My requirement is to add a value called All and also remove the status values Joined and Requirement closed from the dropdown values

Joined &Requirement closed are there in the sharepoint list but I dont want to show them in the Open backfill page

I was able to find the formula to add a value called All, however i am struggling to find formula to remove Joined and Requirement from the list

Request you to kindly guide me

Ungroup(
Table({DepartmentItems:["All"]},
{DepartmentItems:Choices('backfill'.Status)}
),
"DepartmentItems"
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aparnaa ,

Well done on the first part, you were nearly there! All you need to do is add a filter to the choices part.

Have a go with the following Power Fx code in the Items property of your dropdown control:

Ungroup( Table( {DepartmentItems: ["All"]}, { DepartmentItems: Filter( Choices('backfill'.Status), Value <> "Joined" && Value <> "Requirement" ) } ), "DepartmentItems" )

I have replicated on my end and works:

My choices in the list column:

My dropdown in Power Apps:

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net
aparnaa 95 on at

Like
a
(1)

Report
Copy link

Link copied!

thank you, this worked for me

Join the conversation