Hi guys,
I really cannot figure this out so apologies if i'm being really silly here.
I have an HR app where line managers can log in and pull up thier delegates Performance Management Reviews.
On the line manager screen - the drop down is set up with the following formula Distinct(ShowColumns(Filter(colMyDirects,User().Email='Line Manager Name'), "Submitter"),Submitter).
This works for what i need it to do, however i would like a blank in the drop down to be the default.
I have managed to get the blanks to work on the HR screen like this
ClearCollect(colMyDirects,{Name:""});Collect(colMyDirects,Distinct('End Of Year Review',Submitter))
and then in the drop down i have
Sort(colMyDirects,Result).
So this is fine as it will pull all the users through for HR. But for the line manager screen i need it to use my formula above to be able to only show their direct reports.
If anyone has any suggestions i would be so grateful!
Thanks
Donna
Solved! Go to Solution.
Hi @donnadonut
For line manager also create a collection and enter blank as
ClearCollect(colLineManager,{Result:""});Collect(colLineManager,Distinct(ShowColumns(Filter(colMyDirects,User().Email='Line Manager Name'), "Submitter"),Submitter))
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @donnadonut
For line manager also create a collection and enter blank as
ClearCollect(colLineManager,{Result:""});Collect(colLineManager,Distinct(ShowColumns(Filter(colMyDirects,User().Email='Line Manager Name'), "Submitter"),Submitter))
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you @RezaDorrani! 🙂
User | Count |
---|---|
137 | |
127 | |
75 | |
72 | |
69 |
User | Count |
---|---|
220 | |
135 | |
78 | |
58 | |
54 |