Learn to Filter SharePoint columns for Power Apps

[@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?

[@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!

[@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.

[@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.

[@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😎😎

[@almanzaralbert1]

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

[@ShanesCows]

Thanks and Noted. :)

[@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.

[@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.

[@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.

[@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?

[@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!

[@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!

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

[@ShanesCows]

Thanks and Noted. :)

[@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

[@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. 🫤

[@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

[@asimrehan73]

🎉 i did the 100th like 👍

[@ShanesCows]

🥳

[@hayleeadamson6449]

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

[@ShanesCows]

Glad it was helpful!

[@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

[@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.

[@AhmedBalfaqih]

As usual, excellent video. Thanks.

[@ShanesCows]

My pleasure!

[@victordauden9173]

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

[@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.

[@dankirchner4460]

Excellent as always Shane. Big fan!

[@ShanesCows]

Thanks 🤩

[@chairattangthong]

❤thank you soon much Teacher 🙏❤️

[@ShanesCows]

You are very welcome

[@oluwatobipaul6171]

Thank you Shane. This came in handy

[@ShanesCows]

Glad to help

[@MEPsideofBIM]

Great stuff, as usual! 💯 Cheers!

[@ShanesCows]

Glad you enjoyed it!

[@RicksterLuna]

Dataverse version too please!

[@sheezahafeez6202]

yes plz make a video on Dataverse also