Needing dropdown with blank

[donnadonut]

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

[RezaDorrani · Accepted 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

[donnadonut]

Thank you @RezaDorrani! 🙂