Answered

Adding two rows to gallery (table) with one IF-ELSE statement

(0) Share

Report

Posted on by CadelDev

I'm having an issue with my Power App. I have a button with an IF statement that checks if a certain TextField is blank or not. If it is, it adds a single row to the Gallery which I'm using instead of a DataTable. If it's not Blank, then it adds two rows.

Something like this:

If( [logic test] IsBlank(OptionalField); [if true] Collect(colTable; {RequiredField1: RequiredField1.Text; RequiredField2: RequiredField2.SelectedDate; RequiredField3: RequiredField3.Text); [if false] Collect(colTable; {RequiredField1: RequiredField1.Text; RequiredField2: RequiredField2.SelectedDate; OptionalField: OptionalField.Text) And Collect(colTable; {RequiredField1: RequiredField1.Text; RequiredField2: RequiredField2.SelectedDate; RequiredField3: RequiredField3.Text))

However this doesn't seem to work. How can I do this? I appreciate any reply. Thank you.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@CadelDev

Please consider changing your Formula to the following:

If(IsBlank(OptionalField.Text); Collect(colTable; {RequiredField1: RequiredField1.Text; RequiredField2: RequiredField2.SelectedDate; RequiredField3: RequiredField3.Text } ); Collect(colTable; {RequiredField1: RequiredField1.Text; RequiredField2: RequiredField2.SelectedDate; OptionalField: OptionalField.Text }; {RequiredField1: RequiredField1.Text; RequiredField2: RequiredField2.SelectedDate; RequiredField3: RequiredField3.Text } ) )

I hope this is helpful for you.
CadelDev 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh, so that's how it works. That worked! Thank you very much!