Rrestrict Inactive records in Gallery Dropdown.

[Powerappsdev2]

Hi Community Team,

I need to restrict Inactive records in Dropdown.

In Sharepointlist,

Project--Columns are-Project ID,Project Name,Project status

Resource Assign  list-columns are-Name,email,Project, Project ID

In Gallery dropdown are

Project Dropdown--Items-Filter('Resource Assign','Resource Email'=User().Email)

Task Dropdown---Items=Filter('Resource Assign','Project Name'=Projectdropdown .SelectedText.'Project Name')
When user select project in dropdown show only active projects.

In resource Project Id available, How it will help for filter project status. please provide right way approach to thisone.

Thanks in advance for quick responce.....!!!!

[v-mengmli-msft]

Hi @Powerappsdev2 ,

Please try this:

Set the Items of Project Dropdown:

Filter(Project,'Project ID' in Concat(Filter('Resource Assign','Project Status'="active"),'Project ID',",")&&Lower('Resource Email')=Lower(User().Email))

Best regards,

Rimmon Li

[Powerappsdev2]

Hi @v-mengmli-msft 

Thanks for Quick Respond,

I tried above formula but not working can yo check and resolve errors.

In value it shows  Asset Id unable change the columns

Onselect of project dropdown my code is

Filter(Project,'Project ID' in Concat(Filter('Resource Assign',Status.Value="Active"),
Lower('Resource Email')=Lower(User().Email)))

My doubt in code is project status column is availble in project list but how can write in Resource Assign list.

Thans in advance for quick response.

[VauBee]

If your choice column is system default, try 'Project Status'=0  

If this doesn't work, check in the Project Status column properties what value is assigned to the Label 'active' and use that one

If you want to avoid the delegation warning, try StartsWith()

Filter(Project,StartsWith(Concat(Filter('Resource Assign','Project Status'=0),'Project ID')),'Project ID',",")&&Lower('Resource Email')=Lower(User().Email))

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

[v-mengmli-msft]

Hi @Powerappsdev2 ,

If you have a new question, I recommend republishing a post so that more people can find it, and regarding your initial question, I assume that you want to achieve such a goal, filtering out all eligible records in the Resource Assign:

Condition1: ‘Resource Email'=User().Email;

Condition2: Status="active"

I assume your status column is a text column, then my above code can meet your needs. I made some changes to my original code, please try this:

Filter('Resource Assign','Project ID' in Concat(Filter(Project,'Project Status'="active"),'Project ID',",")&&Lower('Resource Email')=Lower(User().Email))

If that's not what you want or there's a bug in the code, I'd like you to describe the problem in as much detail as possible, and I'd like to know the type of Status in the data source.

Best regards,

Rimmon Li

[Powerappsdev2]

Hi @v-mengmli-msft ,

 Thank you quick response,

I tried your  provided code but not show active  project in drop down.

  Project Dropdown --Item=

Filter('Resource Assign','Project ID' in Concat(Filter(Project,Status.Value="Active"),'Project ID',",")
&&Lower('Resource Email')=Lower(User().Email))

Condition1: share point list= Resource Assign list and column is=‘Resource Email'=User().Email;

Condition2: share point list= Project List and column is  Status="active"[choice column= Active and Inactive]

after code not show the dropdown value.

Please Help.

[v-mengmli-msft]

Hi @Powerappsdev2 ,

Please check if there are eligible records in 'Resource Assign'.

Best regards,

Rimmon Li

[Powerappsdev2]

Hi @v-mengmli-msft 

Yes ,Active projects in Project and  Resource assign list

The issue is Dropdown Value is Disabiled,Unable to set the column name.

 Dropdown Value=Project Name

How to update This value .Please help.

[v-mengmli-msft · Accepted solution]

Hi @Powerappsdev2 ,

Please try this:

Filter('Resource Assign','Project ID' in Concat(Filter(Project,'Project Status'="active"),'Project ID',",")&&Lower('Resource Email')=Lower(User().Email)).'Project Name'

Best regards,

Rimmon Li