Answered

How do I combine these two functions in the ITEMS property of my table?

(0) Share

Report

Posted on by VV-05122257-0

Hello - I'm new to Power Apps. I would like to add the following 2 functions below to Items property.

Function 1: Filter('Strategic Housing Engagement Form',drpOfficerName.Selected.Value="All" || 'Officer Name'.Value=drpOfficerName.Selected.Value)

Function 2: If (varPageSize=1,FirstN('Strategic Housing Engagement Form',varPageSize*drpPageSize.SelectedText.Value),
LastN(
FirstN('Strategic Housing Engagement Form',varPageSize*drpPageSize.SelectedText.Value),
drpPageSize.SelectedText.Value
)
)

How do I combine these two functions in the ITEMS property of my table? I'm appreciated for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @YV1 ,

Probably something like this

With( { _Data: Filter( 'Strategic Housing Engagement Form', drpOfficerName.Selected.Value = "All" || 'Officer Name'.Value = drpOfficerName.Selected.Value ), _Factor: varPageSize * drpPageSize.Selected.Value }, If( varPageSize = 1, FirstN( _Data, _Factor ), LastN( FirstN( _Data, _Factor ), drpPageSize.Selected.Value ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
VV-05122257-0 55 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Warren. It works.

Was this reply helpful? Yes No