You’re offline. This is a read only version of the page.
Announcements
76
Hi,
I am currently building a recognition/praise system using a SharePoint list and power app. There is essentially 4 types, monthly, quarterly, yearly and just because.
Everything is working at the moment, however I want to see if it's possible to limit the number of times each user can submit a type of request each period.
For example for November a user can only submit 4 monthly recognitions and for yearly can only submit 2 for the year.
Not sure if this is a power app or automate solution, but would be keen to hear your thoughts.
Thanks,
Georgia
Hi @Georgia12 ,
You can set a rule for submitting records, for example,
Before patching a new Monthly record, check if the same record exists, and then submit the record if the item does not exist
Share
Report
All responses (
Answers (
If(
IsBlank(LookUp(SPList,essentially="monthly" && 'Created By'.Email=User().Email)),
Patch(SPList,Defaults(SPList),{XXX}
)
Best Regards,
Bof
