Unanswered

How do i restrict an input?

(0) Share

Report

Posted on by Admir0110

i add a data with user infos into a gallery. How do I implement that you could only insert each date once, so that no duplicates are inserted?

I add the following to my gallery by a patch function:

This is the Data Source:

And this is the Code of the Gallery:

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

hey @Admir0110

please copy/paste your patch code here so we do not need to retype

thanks in advance

Was this reply helpful? Yes No
Admir0110 57 on at

Like
a
(0)

Report
Copy link

Link copied!
If( DatePicker1.SelectedDate < Today()+1, Reset(DatePicker1); Navigate(Fail_Screen); Notify("Fehlgeschlagen! Bitte wählen Sie ein Datum ab morgen", NotificationType.Error), Patch( Tabelle1, Defaults(Tabelle1), { Datum: DatePicker1.SelectedDate+1, Email1: User().Email, Name: User().FullName } ) ; Reset(DatePicker1); Navigate(ThankYou_Screen, ScreenTransition.Fade); Notify("Erfolgreich!", NotificationType.Success); Reset(Gallery1)); Refresh(Tabelle1)

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Admir0110 , I see you Patch 'DatePicker1.SelectedDate + 1' as a date. If you want to check whether there already is a row in the datasource with this date you could use a formula like

IsBlank(LookUp(Tabelle1, Datum =DatePicker1.SelectedDate + 1))

If this resolves to true, there is no row found for that date. If it resolves to false, there is a row found. You can put this check in your patch-statement and build a similar structure to the error (for when somebody selects a date before tomorrow) you already have.

Was this reply helpful? Yes No
Admir0110 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply unfortunatly i get the following error message:

Was this reply helpful? Yes No
Admir0110 57 on at

Like
a
(0)

Report
Copy link

Link copied!
Did i implement it the right way?
If( Or(DatePicker1.SelectedDate < Today()+1,IsBlank(LookUp(Tabelle1, Datum =DatePicker1.SelectedDate + 1)) ), Reset(DatePicker1); Navigate(Fail_Screen); Notify("Fehlgeschlagen! Bitte wählen Sie ein Datum ab morgen", NotificationType.Error), Patch( Tabelle1, Defaults(Tabelle1), { Datum: DatePicker1.SelectedDate+1, Email1: User().Email, Name: User().FullName } ) ; Reset(DatePicker1); Navigate(ThankYou_Screen, ScreenTransition.Fade); Notify("Erfolgreich!", NotificationType.Success); Reset(Gallery1)); Refresh(Tabelle1)

Was this reply helpful? Yes No