Unanswered

Each user can just create 1 item per day

(0) Share

Report

Posted on by faridanabilah22

Hi,
The case is : i create an item in 2/2/2020 , all created items is shown in browse screen.
When i want to create another item in the same date, it should show a warning "you can just create 1 item per day"
What is the solution to make it successful?
Thanks before

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Try this:
If(CountRows(Filter(Table1,Text(DateColumn),"dd-mmm-yyyy")= Text(DatePicker1.SelectedDate),"dd-mmm-yyyy")),Notify("You can Create Only one record a Day") , SumitForm(Form1))

DatePicker1 should be made a mandatory field

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @faridanabilah22 ,
You can use two things - User().FullName and Today() for the current date.
Firstly, to avoid delegation issues, set a Variable at App Onstart
Set(vUserName,User().FullName)
Note that dates are not delegable queries, so if you have a list over 2000 items, you may need a different solution, however using YourListName, YourDateField andYourFormNameas names (replace with yours) in this, when the user selects a new record you could do something like
If( IsBlank( Lookup( YourListName, 'Created By'.DisplayName = vUserName && DateDiff( Created,Today(), Days ) = 0, ), NewForm(YourFormName), Notify("You cannot create another form", NotificationType.Error) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No