Power Platform Community Forum Thread Details

Hello Experts,

I need assistance to combine below 2 formulas.

SortByColumns(
 Search(
 Filter(
 'Graph MC Dump',
 Category.Value = Dropdown1.Selected.Value || Dropdown1.Selected.Value = "Select"
 ),
 SearchBox.Text,
 "Title",
 "MessageCenterID"
 ),
 "LastModifiedDateTime",
 Descending
)

If(
 And(
 Checkbox1.Value = true,
 Checkbox2.Value = true,
 Checkbox3.Value = true,
 Checkbox4.Value = true,
 Checkbox5.Value = true,
 Checkbox6.Value = true,
 Checkbox7.Value = true
 ),
 Filter(
 'Graph MC Dump',
 'Admin impact' = Checkbox1.Text && 'Feature update' = Checkbox2.Text && 'User impact' = Checkbox3.Text && 'Updated message' = Checkbox4.Text && 'New feature' = Checkbox5.Text && 'Retirement' = Checkbox6.Text && 'Major update' = Checkbox7.Text
 ),
 And(
 Checkbox1.Value = true,
 Checkbox2.Value = false,
 Checkbox3.Value = false,
 Checkbox4.Value = false,
 Checkbox5.Value = false,
 Checkbox6.Value = false,
 Checkbox6.Value = false
 ),
 Filter(
 'Graph MC Dump',
 'Admin impact' = Checkbox1.Text
 ),
 And(
 Checkbox1.Value = false,
 Checkbox2.Value = true,
 Checkbox3.Value = false,
 Checkbox4.Value = false,
 Checkbox5.Value = false,
 Checkbox6.Value = false,
 Checkbox6.Value = false
 ),
 Filter(
 'Graph MC Dump',
 'Feature update' = Checkbox2.Text
 ),
 And(
 Checkbox1.Value = false,
 Checkbox2.Value = false,
 Checkbox3.Value = true,
 Checkbox4.Value = false,
 Checkbox5.Value = false,
 Checkbox6.Value = false,
 Checkbox6.Value = false
 ),
 Filter(
 'Graph MC Dump',
 'User impact' = Checkbox3.Text
 ),
 And(
 Checkbox1.Value = false,
 Checkbox2.Value = false,
 Checkbox3.Value = false,
 Checkbox4.Value = true,
 Checkbox5.Value = false,
 Checkbox6.Value = false,
 Checkbox6.Value = false
 ),
 Filter(
 'Graph MC Dump',
 'Updated message' = Checkbox4.Text
 ),
 And(
 Checkbox1.Value = false,
 Checkbox2.Value = false,
 Checkbox3.Value = false,
 Checkbox4.Value = false,
 Checkbox5.Value = true,
 Checkbox6.Value = false,
 Checkbox6.Value = false
 ),
 Filter(
 'Graph MC Dump',
 'New feature' = Checkbox5.Text
 ),
 And(
 Checkbox1.Value = false,
 Checkbox2.Value = false,
 Checkbox3.Value = false,
 Checkbox4.Value = false,
 Checkbox5.Value = false,
 Checkbox6.Value = true,
 Checkbox6.Value = false
 ),
 Filter(
 'Graph MC Dump',
 'Retirement' = Checkbox6.Text
 ),
 And(
 Checkbox1.Value = false,
 Checkbox2.Value = false,
 Checkbox3.Value = false,
 Checkbox4.Value = false,
 Checkbox5.Value = false,
 Checkbox6.Value = false,
 Checkbox6.Value = true
 ),
 Filter(
 'Graph MC Dump',
 'Major update' = Checkbox7.Text
 ),
 'Graph MC Dump'
)

Categories:

Building Power Apps

Hey @AshishJaiswal

You should be able to use the following as a replacement:

SortByColumns(
 Search(
 Filter(
 'Graph MC Dump',
 //Have moved all non-filter conditions to the left for ease-of-viewing
 Dropdown1.Selected.Value = "Select" || Category.Value = Dropdown1.Selected.Value,
 !(Checkbox1.Value) || 'Admin impact' = Checkbox1.Text,
 !(Checkbox2.Value) || 'Feature update' = Checkbox2.Text,
 !(Checkbox3.Value) || 'User impact' = Checkbox3.Text,
 !(Checkbox4.Value) || 'Updated message' = Checkbox4.Text,
 !(Checkbox5.Value) || 'New feature' = Checkbox5.Text,
 !(Checkbox6.Value) || 'Retirement' = Checkbox6.Text,
 !(Checkbox7.Value) || 'Major update' = Checkbox7.Text
 ),
 SearchBox.Text,
 "Title",
 "MessageCenterID"
 ),
 "LastModifiedDateTime",
 Descending
)

Cheers,

Sancho