URGENT - Lookup before patching

(0) Share

Report

Posted on by Kosenurm

802

Hi there,

I really have to get this right as its for an urgent business case.

I have a very basic Dataverse table which will be patched OnSelect of a button like below

Patch(DVTABLENAME, Defaults(DVTABLENAME),
{Name: User().FullName},
{Email: User().Email},
{'Office Location': Dropdown8.Selected.Value},
{'Date': DatePicker1.SelectedDate},
{'Redemption': "Unredeemed"});

But we need to ensure that a user can only make ONE reservation/patch per SelectedDate in the DatePicker control. If they try to click submit more than once, throw them an error message.

How can I do this so that I look up the colleague's email address AND the chosen date on the Dataverse table and, only if a row does not exist currently with these two elements, allow the patch?

Many thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

meelamri 468 on at

Like (1)

Report

Hello @Kosenurm ,

I think you can do a server side validation. This will send the error message back to your application.

At first sight, I would consider a validation using a plugin that will run in pre-validation.

Please tick Accept as solution if the answer is useful.

https://xrmtricks.com/

Was this reply helpful? Yes No
Kosenurm 802 on at

Like (1)

Report

Thanks, I need really just a simple lookup though as a quick and dirty solution - so that an error message displays if they already have a record in the table with the chosen date and email.

Any ideas?

Thanks

K.

Was this reply helpful? Yes No
meelamri 468 on at

Like (0)

Report

So maybe you can make the a validation when users change the values and display the submit button only if the values is correct.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Kosenurm, Add a Label with your desired error Message wherever you want the error message to appear. Then, in the error message Label Visible Property add theis formula:

If(!IsBlank(LookUp(DVTABLENAME, 'Date'=DatePicker1.SelectedDate && Email=User().Email,'Date')),true,false)

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com