Unanswered

Need help on Items property formula to use filters and search box on Gallery of canvas app...

(0) Share

Report

Posted on by TMaith

Hi everybody,

I'm still trying to write to successfully write a formula to filter and search the gallery in my employer's canvas app. My research says there IS a way to filter and search in one function, but when I try to replicate the function, mine doesn't work. I need help from a more experienced user. Below is screenshot of my gallery showing the formula I have written. Can someone let me know what I'm doing wrong? Thank guys... I appreciate it. NOTE: I realize narrative is spelled incorrectly, but I didn't create the Sharepoint list, I'm just in charge of making changes to the existing app.

Here is what I have in my Items property:

Search(
AddColumns(Filter('Weekly Digest', Created >= Date(2021, 1, 12), Group = GroupDD, AppropriateAudienceforContent = AudienceDD, SearchBox.Text, Category, Narative, Group, Title)
)

PowerApps Screenshot of Gallery Items Property 101022.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@TMaith

The syntax of your formula is way off!

What is the need for AddColumns? What is your Filter criteria? What are the columns you want to search?

My assumptions in looking at your Formula are that you want to search Category, Narative, Group, and Title with the SearchBox.Text

But I cannot figure out why you have an AddColumns function in there.

Was this reply helpful? Yes No
TMaith 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Morning Randy! I just copied that formula from someone online and tried to update it with my values. I really don't know if the addcolumns is necessary. I have a search box and two different dropdowns on my gallery screen. Your assumption is correct. I need my users to be able to use the search box and/or the two dropdowns. Thank you for responding...

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@TMaith

No problem...let's get it fixed up!

Need some info though:

What kind of column is Group, AppropriateAudienceforContent, Category, and Narative?

What is GroupDD, and AudienceDD? And, if the DD means they are dropdowns, then what is the Items property of them?

Was this reply helpful? Yes No
TMaith 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Randy Hayes, here are the details... And yes, GroupDD and AudienceDD are dropdown boxes.

Group: choice column which allows multiple selections => DEI, Environmental Dredging & Restoration, Environmental Operations, Finance, Human Resources, IT, Safety & Compliance, Technical Environmental Services, W/WW Operations, W/WW Engineering

*The items property is currently set to: SortByColumns(Distinct('Weekly Digest', Group),"Result")

Category: choice column which allows multiple selections => Awards, Client/Customer Service, DEI, Education/Training, Employee Spotlight, General, Project Spotlight

*The items property is currently set to: SortByColumns(Distinct('Weekly Digest', AppropriateAudienceforContent),"Result")

Appropriate Audience for Content: choice column that allows one 1 selection => Internal Newsletter, External Newsletter, External Website, Social Media

Narrative: Multi-line text column (where users actual type up the story)

Thank you for your help!!

Was this reply helpful? Yes No
TMaith 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi guys, below is my final formula and it works like a dream.

Filter('Weekly Digest',StartsWith(Category,SearchBox),Group=GroupDD.Selected.Result, 'Appropriate Audience for Content'=AudienceDD.Selected.Result)

Was this reply helpful? Yes No