Unanswered

Suppressing Work Titles when in Cancelled Status

(0) Share

Report

Posted on by EuniceG11

Hi,

I have a dropdown menu on one of my forms called "Project Name". By using "Choices([@'Resource Management'].'Project Name')" in the Items, I have pulled in all the Project Name choices from my SharePoint list. Easy.

BUT, a couple of the projects on that list have now been cancelled and have been recorded as "Cancelled" in another column in my SharePoint list called "Work Status".

My question is this...

How can I remove the projects in "Cancelled" status from the "Project Name" dropdown list?

I know I could just remove the cancelled projects from the SP list, but we want to keep them there. I also know I could suppress them by their project name, but I would have to do that manually for every project that gets cancelled in the future. So, how can I get the "Project Name" dropdown list to not show projects in "Cancelled" status automatically?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @EuniceG11 ,

May I ask what relationship between Resource Management and Work Status?
What is the type of ‘Project Name’? Is it Lookup?

Let us assume its type is Lookup and created two lists below.

Insert a form in the Canvas app.
Items of the DataCardValue:
Filter(Choices([@'Resource Management'].ProjectName),Id in Filter('Work Status',Status.Value <> "Cancelled").ID)

Update of DataCard:
DataCardValue2.Selected

After select one option the data can be stored in the SharePoint List.

Hope this will help you,

Best Regards,
Tina

Was this reply helpful? Yes No
EuniceG11 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tina,

THANK YOU for the very detailed response! I truly appreciate it!

In answer to your questions:
1. 'Resource Management' is the name of the SP list.
2. "Project Name" is a LookUp column and is pulling data from another SP list called "PMO Portfolio List"

When I tried the step above on the data value card, it underlined the last part in red.

The details of the error said the following:

The column definitely still exists in the SP list. I think the problem is that the 'Project Name:Work Status DL' column (aka Work Status) is also a LookUp column pulling info from the same list as Project Name (SP list name is PMO Portfolio List).

How would I adapt the formula as a result of this.

Thank you in advance.

Yours,

Eunice

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @EuniceG11 ,

Please try this:
Filter([@PMO Portfolio],...)
Operators and Identifiers in Power Apps - Power Platform | Microsoft Learn

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No