Learn to Filter SharePoint columns for Power Apps

[@steventhawe1598]

Thank you, Shane. Despite my years of experience in developing PowerApps, I occasionally overlook the simplest tasks like this, and I truly value your assistance.

[@ShanesCows]

Happy to help

[@dankirchner4460]

Excellent as always Shane. Big fan!

[@ShanesCows]

Thanks 🤩

[@dougydoe]

I enjoyed that!! I actually replicated it in my environment as I watched it. I've been developing Apps for a while so not particularly a novice but these columns can be problematic when you're in the flow of things and need to do something quickly so as a quick reference, its brilliant!! Yes, a Dataverse video option would be great as well. Thanks for sharing.

[@hayleeadamson6449]

I love this video! Thanks for showing all of the options (even a person column! :))

[@ShanesCows]

Glad it was helpful!

[@StefaniClaypool]

I would like Dataverse video for filtering to compare the differences. Thanks Shane, I took detailed notes today and learned about a lot of simple things I have struggled with that are a lot clearer. now

[@ShanesCows]

Cool, thanks!

[@AhmedBalfaqih]

As usual, excellent video. Thanks.

[@ShanesCows]

My pleasure!

[@oluwatobipaul6171]

Thank you Shane. This came in handy

[@ShanesCows]

Glad to help

[@siva_playlist0119]

Big fan as always, enjoy your approach to explaining... Please do a Dataverse version too. Thanks

[@ShanesCows]

Thank you. You vote has been added😎😎

[@MEPsideofBIM]

Great stuff, as usual! 💯 Cheers!

[@ShanesCows]

Glad you enjoyed it!

[@almanzaralbert1]

Hey, Young. Thanks. Oh yes dataverse and excel too.

[@ShanesCows]

Thanks and Noted. :)

[@none-qq9lg]

Do you have a single app where you can demonstrate all the various features and functions that can be utilised within power apps? Would be great to see!

[@ShanesCows]

No, there are 100s or 1000s of things you can do in Power Apps. I wouldn't even know where to begin. Are you looking for technical or business ideas? Maybe I can help.

[@none-qq9lg]

@@ShanesCows a combination of both common technical and business elements would be great to see!

[@keithdavies9150]

Great video as always Shane, one subject I'd likeyou to tackle is when the PowerApps studio page glitches. I've had a few recently and can't work out the causes - examples include: page completely goes blank, selecting a control and any attribute only shows the fill color. The only way out is to reload and override view mode. Very frustrating. Keep up the good work.

[@blairforbes1132]

Hey Shane, is it possible to filter the OPTIONS within the dropdown with the values from a Choices column? Basically I have options in the column that I don't want at a specific point in the form and need to "remove" some of the options from the choice column.

[@ShanesCows]

Yes, I don't follow exactly what you are asking but still pretty sure it is yes. :) Choices(SharePoint.Column) produces a table. Filter can filter any table. :) Filter(Choices(SharePoint.Column), Value = "Buddy is awesome") would do exactly what you think.

[@avinoamrothenberg1244]

Great summery. BTW - you CAN use > < etc. on the ID column. Just use the Value function - Filter('ListName',Value(ID)>20) It's not delegable, but works. 🤷‍♂

[@ShanesCows]

Interesting. Still stinks it is not delegable. BOO. Thanks for sharing.

[@ParrishS]

This video has been extremely helpful, as have several of your others. I am missing something simple probably . I used this code for a dropdown filter for a sharepoint choice column, but am not sure how to modify it to pull from the lookup. Or(LocationDropdown.Selected.Value = Blank (), LOCATION.Value = locationDropdown.Selected.Value) The name of the column is STATION. The name of the IN THIS COLUMN: is STATION/BUILDING.

[@victordauden9173]

Thx Shane, really interesting. Video idea request if not done yet: Filtering all types of columns for NULL & BLANKS

[@DanSeguin-m4y]

I have a column in sharepoint list as a hyperlink type, when I created the canvas app, that field is coming up just a text box. Do you have any ideas how to make the field on the form as an hyperlink?

[@cvkealey]

It's important to note that "User().Email" is actually the "user principal name", which *can* differ from the "email" of the user in Active Directory. Best practice is for those to be the same, but it's quite possible you'll run into situations where it is not. The UPN will be at the end of the "claims" value that's stored in the person column in SharePoint, so I often use that just in case the email & UPN don't match.

[@ShanesCows]

Yup, thanks.😎 I talked about some of that chaos in this video for anyone wanting to dig deeper. kzbin.info/www/bejne/bmWYXquqiZ2slZI

[@chairattangthong]

❤thank you soon much Teacher 🙏❤️

[@ShanesCows]

You are very welcome

[@justinm5330]

Hey Shane! Loved this video. I noticed your comments about Managed Metadata columns being non-delegable and recommending against using them, however I was wondering what a good alternative would be. I have a Sharepoint list with one, for tagging one or multiple metadata 'tags' to certain offices. These would be a static list of items, which is why I opted to use the Managed Metadata column. Currently I've concatenated them into a string (in app) displayed per gallery item in my app to be able to filter by search 'tags' in that concatenated label, but the performance is atrocious unfortunately. Any recommendations?

[@ealexander2488]

Hi Shane! Can you make a video where you have all these filters together for one gallery to choose multiple filters at one time?

[@ShanesCows]

This video should help you understand how that would work kzbin.info/www/bejne/fKTXnGNpmJ6Xmck

[@nicholsodes3621]

Is there a way to create a collection from a sharepoint, that only contains columns in which a certain value exists? I have a sharepoint list with 400 columns, and i am looking at 1 row of data at a time, but not all columns have values, so i only want to see the columns that meet a specific date criteria? I know this is a horrible setup, just something i inherited and am trying to make the most of the existing structure so that i don't have to completely rebuild it. Thanks!

[@michelhegeraat5430]

I'm wondering why my sharepoint lists don't have this Managed Metadata column.

[@ShanesCows]

I wonder if Administrators can turn them off, they aren't very common these days.

[@michelhegeraat5430]

@@ShanesCows Seems I can create such a column, but I don't yet understand the questions asked. I guess these columns only exist when created. I thought they were auto created like ID, created created by. etc.

[@McIlravyInc]

I use calculated columns for status...in hopes of reducing logic in the app and flows...but of course it doesn't work as (I) intended. :( And I thought about a mirror column but that adds complication as well.

[@ShanesCows]

Sorry, always seems to be some challenge. 🫤

[@ericzheng4838]

YesNo Column returns a delegation warning with function Not() is because Not(True) actually contains both False value and Blank value. Blank value here means if this column is not mandatory, it might be created with neither True nor False but Blank, so there is actually 3 defined values in YesNo column: True/False/Blank

[@ShanesCows]

Are you sure you can set it to be blank? I think there is a default so if you don't pass yes or no then it will go to default. I don't think it is suppossed to be blank but not sure.

[@HPTeguh]

Hi, Shane. I'm trying to do a filter against a Lookup Column. It returns some data within the collection but it's not returning all of the data based on the filter query. The collection itself only have less than 500 rows of data. Any advise?

[@HPTeguh]

lol nevermind. Found it.

[@sheezahafeez6202]

yes plz make a video on Dataverse also

[@asimrehan73]

🎉 i did the 100th like 👍

[@ShanesCows]

🥳

[@RicksterLuna]

Dataverse version too please!

[@ShanesCows]

Cool. Thanks for the vote 🤩🤩

[@joek2904]

What is the best approach to filter list items over 2000 when you want all items NOT created by the user. is not delegatable... what are our options?

Every data column type on Dataverse. Can't wait. Especially with the corresponding AttributeTypeDisplayName API type field. (●'◡'●)

[@ShanesCows]

Thanks and Noted. :)