If Logic in Form Submission

(0) Share

Report

Posted on by as733y

224

Can someone help me with the If statement for a Visible part of an Icon?

Below is what I had, but then realize it wasn't completely correct.

Basically it's was a form with Officer (combobox), Service (combobox), Amount (text input) and Attachments as required fields and the visible portion was if the form was valid.

Now I need to add a checkbox for missing receipt so the form should require the Officer, Service, Amount, and Attachment OR Missing Receipt checked off before the submit button is Visible.

The below code is what I had, but I didn't realize you could just check off the Missing Receipt and the submit button would appear, so I have faulty code.

Which part do I need to fix?

If(!IsBlank(DataCardValue1)&&!IsBlank(DataCardValue4)&&!IsBlank(DataCardValue3)&&(!IsEmpty(DataCardValue7.Attachments)||DataCardValue5.Value),true,false)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@as733y -

As I understand it, the Office, Service, Amount and Attachments DataCards are required. However, if the "Missing Reciept" checkbox is checked, then the Attachments field is not required.

On the Required property of the Attachments DataCard, enter:

!'Your CheckBox Name'.Value

On the Visible property of the Button, enter:

'Your Form'.Valid

Was this reply helpful? Yes No
Verified answer

as733y 224 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you for your reply @Amik

I went to sleep and ended up with the below which I believe is working.

If(Form.Valid&&Or(!IsEmpty(DataCardValue7.Attachments)||DataCardValue5.Value),true,false)

Was this reply helpful? Yes No