Two If statements that i need to combine for PowerApps gallery
Budget: $30 – $250 USD
See attached videos and the msapp as well. The second screen(HomeScreen_2) from the top screen is the important one. Two if statements, on pulling from a list for search and two dropdowns, the other if is pulling from a hidden gallery to show on a pagination gallery. One if is for a search and two dropdowns referencing a List "Hardware Inventory - Items". The other if statement has a 'galhidden' referencing the inventory item and the main gallery with pagination. I want to combine them but one is referencing the list and the other is referencing the hidden gallery(not visible) with the main gallery showing the pagination that is visible.
If(
varDataCount < varDelegationLimit,
Sort(
Filter(
Filter(
'Hardware Inventory - Items',
('Item Type'.Value = Dropdown2_3.Selected.Value || Dropdown2_3.Selected.Value = Blank()) && ('Assignment Type'.Value = Dropdown2_4.Selected.Value || Dropdown2_4.Selected.Value = Blank())
),
SearchBox_1.Text in 'Assigned To'.DisplayName || SearchBox_1.Text in 'Item Type'.Value || SearchBox_1.Text in 'NADA Asset Tag Number'
),
'Assigned To'.DisplayName,
varSortDirection
),
Sort(
Filter(
'Hardware Inventory - Items',
('Item Type'.Value = Dropdown2_3.Selected.Value || Dropdown2_3.Selected.Value = Blank()) && ('Assignment Type'.Value = Dropdown2_4.Selected.Value || Dropdown2_4.Selected.Value = Blank ())
),
'Assigned To'.DisplayName,
varSortDirection
)
)
If(icoNext.DisplayMode=DisplayMode.Disabled,LastN(FirstN(galHidden.AllItems,drpPaginationSize.Selected.Value*varPageNumber),drpPaginationSize.Selected.Value(drpPaginationSize.Selected.Value*varPageNumberCountRows(galHidden.AllItems))),LastN(FirstN(galHidden.AllItems,drpPaginationSize.Selected.Value*varPageNumber),drpPaginationSize.Selected.Value))
If(
varDataCount < varDelegationLimit,
Sort(
Filter(
Filter(
'Hardware Inventory - Items',
('Item Type'.Value = Dropdown2_3.Selected.Value || Dropdown2_3.Selected.Value = Blank()) && ('Assignment Type'.Value = Dropdown2_4.Selected.Value || Dropdown2_4.Selected.Value = Blank())
),
SearchBox_1.Text in 'Assigned To'.DisplayName || SearchBox_1.Text in 'Item Type'.Value || SearchBox_1.Text in 'NADA Asset Tag Number'
),
'Assigned To'.DisplayName,
varSortDirection
),
Sort(
Filter(
'Hardware Inventory - Items',
('Item Type'.Value = Dropdown2_3.Selected.Value || Dropdown2_3.Selected.Value = Blank()) && ('Assignment Type'.Value = Dropdown2_4.Selected.Value || Dropdown2_4.Selected.Value = Blank ())
),
'Assigned To'.DisplayName,
varSortDirection
)
)
If(icoNext.DisplayMode=DisplayMode.Disabled,LastN(FirstN(galHidden.AllItems,drpPaginationSize.Selected.Value*varPageNumber),drpPaginationSize.Selected.Value(drpPaginationSize.Selected.Value*varPageNumberCountRows(galHidden.AllItems))),LastN(FirstN(galHidden.AllItems,drpPaginationSize.Selected.Value*varPageNumber),drpPaginationSize.Selected.Value))