Unanswered

Filter choice in a dropdown

(1) Share

Report

Posted on by IS-28111528-0

Hello, I have an app and it’s been one year since I started working on it.

In this app, there is a BrowseGallery that takes items from a SharePoint list. In this list, we have a column that contains data about projects stored in another SharePoint list.

I have a DetailForm on another screen that takes information from a line in the first SharePoint list and displays it. You can also edit the line or create a new one.

On the final screen, I have an EditForm and I want the dropdown menu to only show projects where the STATUS isn’t “CLOSED.” I have tried many things, but nothing seems to work.

My first idea was to add the second SharePoint list to my app and change the Items property of the dropdown to show every project that is not “CLOSED.” But it didn’t work, because when I saved the line in the first SharePoint list, the project field was empty.

Then I tried to use Lookup to get the STATUS from the second list, but that didn’t work either because STATUS is a Choice column. I then created a text column with “CLOSED” for projects that are closed, added this column to the first list, and tried to get every distinct project where it wasn’t “CLOSED.” That also didn’t work, and even if it did, I don’t think it would have shown newly added projects from the second list, because they wouldn’t be in the first list.

If you need more information, like screenshots or other details, I can share them!

Thanks in advance for your help.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@IS-28111528-0,

Can you please share the screenshots and give the backend schema in short so that we can replicate the things from our end and keep you posted.

Was this reply helpful? Yes No
IS-28111528-0 42 on at

Like
a
(0)

Report
Copy link

Link copied!

For the sharepoint list here are some picture

Was this reply helpful? Yes No
IS-28111528-0 42 on at

Like
a
(0)

Report
Copy link

Link copied!

For the app :

First screen Browse screen where you can browse your ligne you created.

Was this reply helpful? Yes No
IS-28111528-0 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Second screen Display screen where every column of the line are shown to the user with the delete option edit and copy.

Was this reply helpful? Yes No
IS-28111528-0 42 on at

Like
a
(0)

Report
Copy link

Link copied!

MS.Ragavendar

And the final screen the one to edit or create line.

For the Project dropdown menu on the third screenshot I want that only the project with on going in status are shown.

this code in items show me every project :

Choices([@'APOLLON_2025_BOOKING TS'].PROJET0)

I Have also tried this :

Filter(
'APOLLON_2025_AFFAIRES',
Delegation_Status.Value <> "CLOSED"
)

And this :

Distinct(
Filter(
'APOLLON_2025_BOOKING TS';
'PROJET: delegation_status'.Value <> "CLOSED"
);
PROJET
)

The picture are currently under scan but tell once it's done if this is enough for you !

Was this reply helpful? Yes No
IS-28111528-0 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@MS.Ragavendar

Do you have all the information that you want ? or do you need anything else ?

Was this reply helpful? Yes No