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
@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.
@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!
@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😎😎
@hayleeadamson6449
Жыл бұрын
I love this video! Thanks for showing all of the options (even a person column! :))
@ShanesCows
Жыл бұрын
Glad it was helpful!
@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.
@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. kzitem.info/news/bejne/mWprk6yqjWqqkmU
@almanzaralbert1
Жыл бұрын
Hey, Young. Thanks. Oh yes dataverse and excel too.
@ShanesCows
Жыл бұрын
Thanks and Noted. :)
@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.
@victordauden9173
Жыл бұрын
Thx Shane, really interesting. Video idea request if not done yet: Filtering all types of columns for NULL & BLANKS
@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.
@dankirchner4460
Жыл бұрын
Excellent as always Shane. Big fan!
@ShanesCows
Жыл бұрын
Thanks 🤩
@AhmedBalfaqih
3 ай бұрын
As usual, excellent video. Thanks.
@ShanesCows
3 ай бұрын
My pleasure!
@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!
@oluwatobipaul6171
Жыл бұрын
Thank you Shane. This came in handy
@ShanesCows
Жыл бұрын
Glad to help
@MEPsideofBIM
Жыл бұрын
Great stuff, as usual! 💯 Cheers!
@ShanesCows
Жыл бұрын
Glad you enjoyed it!
@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 kzitem.info/news/bejne/p6mq0WRpnGuVlpw
@justinm5330
2 ай бұрын
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?
@chairattangthong
7 ай бұрын
❤thank you soon much Teacher 🙏❤️
@ShanesCows
7 ай бұрын
You are very welcome
@DanSeguin-m4y
10 ай бұрын
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?
@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.
@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. 🫤
@sheezahafeez6202
Жыл бұрын
yes plz make a video on Dataverse also
@nicholsodes3621
11 ай бұрын
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!
@RicksterLuna
Жыл бұрын
Dataverse version too please!
@ShanesCows
Жыл бұрын
Cool. Thanks for the vote 🤩🤩
@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.
@HPTeguh
5 ай бұрын
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
5 ай бұрын
lol nevermind. Found it.
Жыл бұрын
Every data column type on Dataverse. Can't wait. Especially with the corresponding AttributeTypeDisplayName API type field. (●'◡'●)
Пікірлер: 53