Answered

Conditional Concatenation of multiple inputs based on toggling Check boxes

(0) Share

Report

Posted on by stayinginsync

139

Building a PowerApp with SharePoint list as a base. Found several Concatenate and IF posts in the forum and throughout the web, but couldn't find what I was looking for. Hoping someone here can help.

Inputs:

cboComboBox1.Selected.SharePointColumnName (Lookup)
cboComboBox2.Selected.SharePointColumnName (Lookup)
chkCheckBox1.Value
txtTextBox1.Text
chkCheckBox2.Value
txtTextBox2.Text
txtTextBox3.Text

What I want to accomplish:

If chkCheckBox1.Value = false && chkCheckBox2.Value = false, then txtTextBox3.Text =

Concatenate(
 cboComboBox1.Selected.SharePointColumnName, " ",
 txtTextBox2.Text
 )

If chkCheckBox1.Value = true && chkCheckBox1.Value = false, then txtTextBox3.Text =

Concatenate(
 cboComboBox1.Selected.SharePointColumnName, " ",
 cboComboBox2.Selected.SharePointColumnName, " ",
 txtTextBox2.Text
 )

If chkCheckBox1.Value = false && chkCheckBox2.Value = true, then txtTextBox3.Text =

Concatenate(
 cboComboBox1.Selected.SharePointColumnName, " ",
 txtTextBox1.Text, " ",
 txtTextBox2.Text
 )

If chkCheckBox1.Value = true && chkCheckBox2.Value = true, then txtTextBox3.Text =

Concatenate(
 cboComboBox1.Selected.SharePointColumnName, " ",
 cboComboBox2.Selected.SharePointColumnName, " ",
 txtTextBox1.Text, " ",
 txtTextBox2.Text
 )

I was hoping that this would work, I should have known that it would not be this easy:

Concatenate(
 cboComboBox1.Selected.SharePointColumnName, " ",
 If(chkCheckBox1.Value = true, 
 Concatenate(cboComboBox2.Selected.SharePointColumnName," ")
 ),
 If(chkCheckBox2.Value = true,
 Concatenate(txtTextBox2.Text," ")),
 textBox3.Text
 )

Thanks in advance.

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I like to do the testing first for readability. Something like the function below.
I would also suggest to look into the Concat() function. That will improve readability a bit further.

If(
//both false
And(
!chkCheckBox1.Value,
!chkCheckBox2.Value
),
Concatenate(
cboComboBox1.Selected.SharePointColumnName,
" ",
txtTextBox2.Text
),
//1 true, 2 false
And(
chkCheckBox1.Value,
!chkCheckBox2.Value
),
Concatenate(
cboComboBox1.Selected.SharePointColumnName, " ",
cboComboBox2.Selected.SharePointColumnName, " ",
txtTextBox2.Text
),
//1 false, 2 true
And(
!chkCheckBox1.Value,
chkCheckBox2.Value
),
Concatenate(
cboComboBox1.Selected.SharePointColumnName, " ",
txtTextBox1.Text, " ",
txtTextBox2.Text
),
//else, so bot true
Concatenate(
cboComboBox1.Selected.SharePointColumnName, " ",
cboComboBox2.Selected.SharePointColumnName, " ",
txtTextBox1.Text, " ",
txtTextBox2.Text
)
)
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@stayinginsync

This is my go at it:

With({ condition1:Concatenate( //Both checkboxes checked cboComboBox1.Selected.SharePointColumnName, " ", cboComboBox2.Selected.SharePointColumnName, " ", txtTextBox1.Text, " ", txtTextBox2.Text ), condition2:Concatenate( //Checkbox1 checked cboComboBox1.Selected.SharePointColumnName, " ", cboComboBox2.Selected.SharePointColumnName, " ", txtTextBox2.Text ), condition3:Concatenate( //Checkbox2 checked cboComboBox1.Selected.SharePointColumnName, " ", txtTextBox2.Text ), Condition4: textBox3.Text //Neither checkbox checked }, If( chkCheckbox1.Value and chkCheckbox2.Value, condition1, chkCheckbox1.Value and !chkCheckbox2.Value, condition2, !chkCheckbox1.Value and chkCheckbox2.Value, condition3, !chkCheckbox1.Value and !chkCheckbox2.Value, condition4, ) )
stayinginsync 139 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Thanks. That did the trick. I'll look into Concat too.
stayinginsync 139 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous , @Drrickryp ,

Thank you both. I ended up using @Anonymous 's. However, while this technique works great for the initial FormMode.New of the SharePoint form, when I go to Edit the SharePoint item, txtTextBox3.Text is not populating with the cboComboBox1, nor cboComboBox2 Parent SelectedItems, just the txtTextBox1.Text &txtTextBox2.Text.

This was after the work I did with @WarrenBelz in this thread.

Thanks in advance.