You’re offline. This is a read only version of the page.
226
Hi,
I have configured a Leave request Power apps template with Excel as a data source. I can Patch the data into excel. I need to validate If the user already submitted a leave request and was approved by the manager, we should not allow the user to submit another leave request on the same date.
Ex: If the User already submitted a leave request -- > 09/14/2022 to 09/15/2022. It's approved by the Manager. We need to add validation here in such a way that we should allow users to submit the request for the same data. Any suggestion on this?
Thank-you,
Gokulnath.
Hi @gokulnath
You can apply condition like
If( !IsBlank( LookUp(TableName, Startdate = FromDatePicker.Selecteddate And Enddate = ToDatePicker.Selecteddate And RequestedBy user= User().email) ), Notify("You have already submitted"), Patch( if not then submit request logic)
Share
Report
All responses (
Answers (
