web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Formula to display onl...
Power Apps
Unanswered

Formula to display only Active employees

(0) ShareShare
ReportReport
Posted on by 144

Hi Team,

 

I have a list of employees, when marked their DateOfExit they are now non-active employees.

I have an allocation option, where I allocate the employees to the project for each month. Hence while adding a new allocation for an employee, the employee list should display employees who are all active and employees marked resigned for the current month.

 

Meaning, that suppose say we have two employees name A and B, A's resignation date is 14 Sep 2022 and B's resignation date is 3 Oct 2022. 

 

Now the list of employees should show while adding for an allocation, it should display only B. Because B's resignation is current month and A is on previous month.

 

I display month in a dropdown named - DropMonth and Items are ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"],

the default will be - Text(Today(),"mmm")

 

Thank you for your help.

 

Thanks,

Harisha

Categories:
I have the same question (0)
  • HarishaAkkil Profile Picture
    144 on at

    Please help me with the below formula to display records as said above.

     

    Sort(
    Filter(
    AddColumns(
    Employee_1,
    "NameID",
    EmployeeName & " (" & EmployeeID & ")"
    ),
    SearchBox_Ename.Text in EmployeeName
    && SystemStatus <> "Pending"
    || Value(Year(DateofExit)) = Year(DropYear_2.Selected.Value)
    || Value(Month(DateofExit))<= Value(SelectedMonth)
    ),
    EmployeeName
    ).NameID

     

     

     

    where SelectedMonth is a variable set below,

    Set(SelectedMonth,
    Switch(DropMonth_3.Selected.Value,
    "Jan",01,
    "Feb",02,
    "Mar",03,
    "Apr",04,
    "May",05,
    "Jun",06,
    "Jul",07,
    "Aug",08,
    "Sep",09,
    "Oct",10,
    "Nov",11,
    "Dec",12)
    );

     

     

    Thanks,

    Harisha

  • HarishaAkkil Profile Picture
    144 on at

    Hi Team,

    Any ideas on the above formula? Kindly help.

    Thanks.

  • HarishaAkkil Profile Picture
    144 on at

    Any ideas team?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard