Do not save in forms sharepoint if condition met

(0) Share

Report

Posted on by syhrh

997 Super User 2024 Season 1

Hi, I'm customizing the form in Sharepoint using Power Apps and I'm trying to notify users that if their leave balance is insufficient, they cannot save/create the item with a message that will be displayed like the formula below.

The Leave Balance list has all Number columns.

Whenever the user chooses any of the leave types, it will check if the leave type balance in the leave balance list and whether the days applied are enough to apply.

This is on SharepointIntegration.OnSave. I try this way but has errors. How to fix it?

If(DataCardValue1.Selected.Value = "Annual Leave" < DataCardValue15 And DataCardValue1.Selected.Value="Calamity Leave" < DataCardValue15,false);
SubmitForm(SharePointForm1);
ResetForm(SharePointForm1);
RequestHide();

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @syhrh ,

Please set SharepointIntegration.OnSave .

Best Regards,

Bof

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft Yes, I set it in SharePointIntegration.OnSave but have errors. It was a typo when I posted it. Thank you

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @syhrh ,

I think you maybe need something like this:

If( LookUp('leave balance list',DataCardValue1.Selected.Value='leave balance type').RemainData < Value(DataCardValue15.text), SubmitForm(SharePointForm1); ResetForm(SharePointForm1); RequestHide(); )

Best Regards,

Bof

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft
It has an error on the value

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @syhrh ,

Could you please tell me what DataCardValue15 is ?

Best Regards,

Bof

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft
In the list, it is a number column

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @syhrh ,

Please try DataCardValue15.Text

Best Regards,

Bof

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @syhrh ,

Please capital 'T'.

Best Regards,

Bof

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft

There's still an error

Was this reply helpful? Yes No