Answered

Submit only if 2 criteria are fulfilled

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a form with an attachments field, which is only a required field when another option is false.

I am currently hiding the 'Submit' button until all required fields are complete - except the attachments fields, as that is only required some of the time.

Many of my users are submitting a form which requires an attachment, but they don't attach anything, so the 'Submit' button is visable and can be selected, which takes them to the success screen even though their submission has actually not gone through.

I would like the 'Submit' button to only navigate to the success screen if it is successful, so far I have this (which doesn't work):

OnSelect = If(And(!IsEmpty(attachmentDataCard.Attachment), (DataCardValue1.Value=false)),disable,SubmitForm(Form1);Navigate(SuccessScreen,Fade)

Please can anyone help?

Submit only if xx=false and attachment is attached

Many thanks

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try this:
If(And(!IsEmpty(attachmentDataCard.Attachment), (DataCardValue1.Value=false)),SubmitForm(Form1);Navigate(SuccessScreen,Fade))
Now on the visible property of the button set the below variable:
If(And(!IsEmpty(attachmentDataCard.Attachment), (DataCardValue1.Value=false)),true,false)
Now we are enabling the submit only if our conditions are met.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @KrishnaV !

I have put your suggested code:
If(And(!IsEmpty(attachmentDataCard.Attachment), (DataCardValue1.Value=false)),SubmitForm(Form1);Navigate(SuccessScreen,Fade))
into the 'OnSelect' for my Submit button, however it returns the same error I was getting before - 'The function 'IsEmpty' has some invalid arguments'.
Did I put the code in the wrong place?

Thanks so much for your help! Neets
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You just need to make a little change.

set the submit button's OnSelect:

If(And(!IsEmpty(DataCardValue16.Attachments), (DataCardValue1.Value=false)),SubmitForm(Form1);Navigate(SuccessScreen,Fade))

// DataCardValue16 is the attachments control's name, please replace with yours.

set the submit button's Visible:

If(And(!IsEmpty(DataCardValue16.Attachments), (DataCardValue1.Value=false)),true,false)

// DataCardValue16 is the attachments control's name, please replace with yours.

Best regards,
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try this:
If(And(CountRows(DataCardValue180.Attachments), (DataCardValue1.Value=false)),SubmitForm(Form1);Navigate(SuccessScreen,Fade))
In the above formula DataCardValue180 is my control name please replace it with your control name.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for the suggestion, this does remove the 'The function 'IsEmpty' has some invalid arguments' error.
However, it doesn't solve the original query: Submit only if xx=false and attachment is attached.

I have solved with:

If(Or(IsBlank(DataCardValue1),IsBlank(DataCardValue2),If(AttachemntDataCard.Attachment)false)),notify("Please fill in ALL the required fields",NotificationType.Error),SubmitForm(Form1);Navigate(SuccessScreen))