disable dropdown based on Column value in table while scrolling

[DAVIDPOWELL]

I have a screen with a table tbl_Tasks

I have a dropdown  dwn_Change_Status.

I have a Column Called  Status in tbl_tasks.

What I need:

While scroll through the rows in tbl_Tasks.

If the Value in the Status Column  =  "Open" disable the dropdown "dwn_Change_Status"

Thanks

Dave

[eka24 · Accepted solution]

In the displaymode of the dropdown;

If(Self.SelectedText.Value = "Open", DisplayMode.Disabled, DisplayMode.Edit)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[DAVIDPOWELL]

@eka24 

what is "self" referring to ?  Self.SelectedText.Value

dave

[eka24]

It a function referring to the your dropdown in question.

Any feedback  after you used the Formula

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[DAVIDPOWELL]

@eka24 

Thanks, got it.

will your statement work with the following statement i already have ?

If (CountRows( Filter('[dbo].[t_nsc_trackcode_assigned_DataEntry_pa]',ID_Racfid = lbl_Racfid_ms.Text) ) > 0, DisplayMode.Edit, Disabled)

[eka24]

You have not said anything whether it worked or not. Is this a new question?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[DAVIDPOWELL]

sorry, yes that works fine..

Dave

[eka24]

Please if it worked, mark it. Then post a new request and explain further how you want it

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.