Forum Discussion

ADumith's avatar
ADumith
Iron Contributor
Apr 20, 2022
Solved

Create a calculated field

Hello everyone,   I have a gallery where the employees who are celebrating their anniversary are displayed.   For this I have a collection: Set(varCM, Text(Now(),"mm")); Set(varCY,Text(Year(Now...
PowerApps
sharepoint
  • ADumith's avatar
    ADumith
    Apr 21, 2022

    Hello guys,

     

    I did it by my self :stareyes:

     

    This is the filter formula:

     

    Sort(Filter(colWA,Mjoined = varCM && (varCY-Yjoined>0)),Djoined,Ascending)

     

    Have a great day

     

ADumith's avatar
ADumith
Iron Contributor
Apr 21, 2022

Hello guys,

 

I did it by my self :stareyes:

 

This is the filter formula:

 

Sort(Filter(colWA,Mjoined = varCM && (varCY-Yjoined>0)),Djoined,Ascending)

 

Have a great day