Unanswered

Power Apps form validation from Dataverse

(0) Share

Report

Posted on by alexa_028

Hi Team,

I am new to power apps, and I wanted to have a functionality in my form that will add new record to my Dataverse Table but prevent consecutive entry by the same user.

Ex: So when XYZ user will form for booking a slot, a row gets added and slot remaining gets updated.

However, when he tries to book again for 13/06 , he should get error that you cannot have 2 consecutive leaves.

Can someone pls help me how can I add this to form in Power Apps?

Date	Initial Slot	Booked By	Slot Remaining
12/06/2023	3	XYZ	2

I have no clue how to make a form either using Dataverse.
And adding these rules,Its my first project, really appreciate your help here.

Thanks !

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Shaheer Ahmad 2,194 Moderator on at

Like (0)

Report
Copy link

Link copied!
Sure! I can help you with adding form validation to your Power Apps form in order to prevent consecutive entries by the same user. Here's an outline of the steps you can follow:
Create a Canvas app in Power Apps and connect it to your Dataverse table.
Add a new form control to your canvas app by clicking on the "Insert" tab and selecting the "Forms" option. Choose the table you want to work with from the available options.
Customize the form control by selecting the fields you want to display and arrange them as needed. You can do this by selecting the form control and using the options in the "Properties" pane.
Add a button to the form that will submit the data and trigger the validation. You can add a button control from the "Insert" tab.
In the button's OnSelect property, add a formula that performs the validation before saving the record. Here's an example of how the formula might look:

If( CountRows( Filter( 'YourTableName', 'Booked By' = User().FullName, Date = Today() ) ) > 0, Notify("You cannot have 2 consecutive leaves.", NotificationType.Error), Patch('YourTableName', Form1.Updates) )

In this formula, 'YourTableName' should be replaced with the name of your Dataverse table, and 'Booked By' and 'Date' should be replaced with the corresponding field names in your table.
The formula checks if there are any existing records in the table for the current user and today's date. If such records exist, it displays an error notification. Otherwise, it uses the Patch function to save the record to the table.
Customize the error notification message as needed by modifying the string inside the Notify function.
That's it! With this setup, when a user tries to book a slot for a consecutive day, they will receive an error message indicating that it's not allowed. Otherwise, the record will be saved to the Dataverse table.
Remember to test your app thoroughly to ensure that the validation is working as expected. Let me know if you need any further assistance!

Was this reply helpful? Yes No
alexa_028 63 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your reply, but the date can be anywhere in future , example user cannot have 20/21st july booked , it doesn't have to be based on today.

Was this reply helpful? Yes No