Answered

Limit form submissions to 3 times a week

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi there!

I'm currently creating a form that only allows each person to make reservations for a maximum of 3 times a week. So if one already have 3 reservations in the same week recorded on my sharepoint list, then when the person make the 4th reservation on the same week, an error message will be shown on my canvas app. Can anyone assist me in my code, it doesn't seem to be working:

If(CountIf(SharepointList,ReservedBy=DataCardValue4.Text && DateValue(Text(ReservedDateinSharepointList,DateTimeFormat.LongDate))>=DateValue(Text(DateAdd(DataCardValue5.SelectedDate,1-(Weekday(DataCardValue5.SelectedDate,Monday)),Days),DateTimeFormat.LongDate)) && DateValue(Text(ReservedDateinSharepointList,DateTimeFormat.LongDate)) <= DateValue(Text(DateAdd(DataCardValue5.SelectedDate,7-Weekday(DataCardValue5.SelectedDate,Monday),Days),DateTimeFormat.LongDate)))>3,"You can only make 3 bookings per week.","")

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Anonymous ,

I used WeekNum function in PowerApps to try to get your result. Let us know if it works for you.

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-weeknum

ClearCollect(FilteredTablebyCurrentUserWeek,Filter(ClearCollect(FilteredTablebyCurrentUser,Filter(SharepointList, 'Created By'.Email = User().Email)),WeekNum(Created) = WeekNum(Today())));

Storing it in Collections to avoid delegation issues.

If(CountRows(FilteredTablebyCurrentUserWeek) = 3,"You can only make 3 bookings per week.")

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ashwin7104 ,

Thanks for your help, WeekNum function worked for me! I'm not familiar with Collections, so I have created a column on my Sharepoint List to collect the Week Number information.

If(CountRows(Filter(SharepointList,ReservedFor=DataCardValue4.Text,WeekNumber=WeekNum(DataCardValue5.SelectedDate,Monday)))=3,"You can only make 3 bookings per week.","")

Was this reply helpful? Yes No