Power Platform Community Forum Thread Details

Hi all - I have built a powerapp to allow users to submit schedule preferences. One section is to submit multiple requests for days off. There are 10 date pickers there for them to put in one date per date picker. Not all 10 fields are required. Is there a way to catch if they put duplicate dates in the field and prevent them from hitting a button that navigates them to the next screen?

I use this for a different section that has dropdowns: (code is in the OnSelect property of the button)

With({temp:[DataCardValue39.Selected.Value,DataCardValue40.Selected.Value,DataCardValue41.Selected.Value,DataCardValue42.Selected.Value]},

If(CountRows(temp)<>CountRows(Distinct(temp,Value)),DisplayMode.Disabled & Notify("You have selected duplicate SIM start times, please select only one of each to continue.",NotificationType.Error),

The issue with recreating this, is if the user does not select a date in more than one of the datepickers it will catch blank date pickers and say they are duplicates...

Any help/guidance would be appreciated!! Thanks!

Categories:

Building Power Apps