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.
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.
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
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. 🤷♂
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.
Yup, thanks.😎 I talked about some of that chaos in this video for anyone wanting to dig deeper. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-845-xtT8y_0.html
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.
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
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.
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!
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.
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?
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?
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.
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.
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.
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!
@@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.
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?