Hey Shane! Thanks for all of the videos you put out. One thing I've noticed is that there are a decent amount of RUclips videos and other content out there about how to do things in Power Apps and about Power Platform certifications. I think all of this is great, but one video I'd love to see would be a video on what career paths are available for people who want to work full time in the Power Platform. I think that this is fairly established for people who do Power BI, but what does the day in the life of an Power App Maker or a Power Automate specialist look like? Maybe there are not more videos like this out there because the Power Platform is still pretty new not too sure, but a video that talks about the career paths someone can take with Power Platform would be something I'd be interested in.
That is a good idea for a video. I have thought about it a couple of times. I actually did a Short on job titles ruclips.net/user/shorts8JnQCleQ7Xo But I will give this a think, I see how it would be helpful. :) Thanks
hey Shane, thanks for this video. It helped me understand how vertical and horizontal containers work. I never used them before. However I have found a small glitch. If you unselect checkboxes in the gallery and click the Select All button, unselected checkboxes are not selected again. To fix this issue I added 'UpdateContext({varReset:true});UpdateContext({varReset:false})' in OnSelect of the 'Select All' button, the same way than what was done for the Unselect button.
Hi Shane, many thanks for this very useful video! I have come across a strange 'anomaly', which I thought I'd share in case you have also come across this too. I used your technique to count how many items have been selected in a gallery via a checkbox and it works fine when you just have a normal gallery in a maincontainer of a 'Header and footer' screen layout say. The figure is displayed in a label just like your example. So I used: CountRows(Filter(Gallery1.AllItems, Checkbox1.Value)). However, if you edit the gallery and add a container first, then add a checkbox and other fields that you wish to display within that container, then whenever you select the checkbox, using that same formula - we get the total number of rows displayed every time we select any of the checkboxes, rather than the count of how many were selected. So in my case even though I selected one checkbox, the figure says 8, as there's eight items in total. Is there some formulaic way we can overcome that, or is this one of the 'features' that we just have to accept, and not have containers for each row of data?
Hello Shane, thank you for the video. Do you have a video on using 'select all' option to only select filtered items in the gallery, rather than all items in the gallery?
wow! ironically, this video links to my Q in your last vid on named formulas and delegation of tables stored in these Vs using collections. I didn't realize you could filter Galleries with ref to themselves as opposed to the source data. I'm looking to get around non-delegable barriers when comparing galleries to each other. So in my example, gal 2 is based on a list patched from records selected from a master Sharepont list. And Gal 1 is itself based on the master list, filtering out any records the user previously patched to to the list Gal 2 is based on (so they cannot re-select the same item into their 'personal list' - i.e. a copy of an item from the master list in conjunction with their User ID will be the filter conditions used in Gal 1). This means the that while Gal 1 will never have issues relating to delegation because the number of records wont exceed 2000, Gal 2 could repeat the same records across different users hence get v large. Tried sticking to 'Starts With' and 'Filter' but invariably the comparison check between galleries requires operators that are non-delegable e.g. items property for Gal 1 being: Filter('datasource for Gal 1', Not(Title exactin 'data source for Gal2'.Title) AND User().FullName in Lower(FullName)).Title))
Thank you! This got me started. Your videos are always helpful! I have a parent SP list that is connected to another SP list using the IDcopy column to a RefID column. There are numerous records on the child SP list per single record on the parent list. How can I select multiple parent items (IDcopy) and pull all pertaining records on the child list? End goal is to export to excel.
Happy new year 🎉 & Thanks for the video, for the next video😅: If you can add how to patch the checked in anther page? Maybe visualize the checked ✔️ item before patching form another page 🙏🏽. I used a Navigation function but didn't quite work 😂. Have a great day
Hey Shane, Thanks for the works. Is there a possibility to implement "Shift" key Mutiple selection, just like how to can do in Excel/Outlook where hold shift key will allowed users to select all items in-between
If you store your data in a collection, you can include a Boolean value to store the checkbox value as well as a calculated row value. You can then add select range button to update the collection with the true/false values with a row range.
Hey Shane! I need an information , for you is possible manage all ms planner with power app? I have had a good result with power bi, but it’s just to view. I need a power apps that are able to modify all my plan. It’s possible or I can found some limitations? Thanks for all ! You are my guide on ms word
Thanks, Shane. You're always my inspiration. Only a question: is there a limit (100) with this code? I have more than 100 items and the only way I have found to increase de Countrows is running trhough the gallery untill the end. Is there any other way to avoid this limit? Thanks.
Hi Shane!! Thats not the subject of the video, but i noticed you've done something i'm struggling with. How could i show the image of each item in the gallery like this? I have a list of employees and im trying to show them in a gallery with their profile photos as the image of the gallery. The list have a "person" column type and the photos are appearing in sharepoint, but when i try to configure the field image of the list, it only allows me to select sample image or upload one, and if i do so, the same image appears to all items. Thanks!!
You need to use the Office 365 User connector to retrieve each users photo. Very brief intro in this old video. PowerApps User Function and intro to Office 365 User connector ruclips.net/video/FpXrF5NDZbI/видео.html
Hi Shane, i tried your way to reset checkboxes on click of cancel button, but somehow its not working. I have a SharePoint integrated form. I have a choice column which i created as gallery with checkboxes. On new item, if i am selecting the checkboxes, on click of cancel it should clear the checkboxes. but its not happening, when opening the form again, the checkboxes remained checked. Please advise on how to proceed. Thanks in Advance!
Hey shane can please help me how to patch a multi select combobox inside a gallery to a sharepoint list when the column type selected in the combobox is people or group type?
Try this video ruclips.net/video/BUUCATSKNK0/видео.html it talks about getting the base64 for images (from your gallery would be fine) and then embedding it different places, include in HTML.
Hi Sir, how do you add the selected items from the gallery into the collection? when I select multiple items from the gallery, only 1 get added into the collection
@@ShanesCows there is no Reset property anymore and for Default I use Checked property to be able to make same functionality as the one described in your video ( one that is uses context variables) for check/uncheck checkboxes in my Teams app
Instead of showing the number of gallery items checked, what if you wanted to show in a label outside the gallery the actual selections? I tried using the concatenate function and failed.
😹 I got a new camera and clearly I need to spend more time adjusting the color. 😹 I have fought this issue for years, my skin has a lot of redness built in, so if I get the color wrong I look super red on camera. I promise my face is its normal pale wierdo color in person. 😳
Good Evening Shane Hope you are well and happy new year all the best going forard for the year ahaed. At the end of the video you asked for requests, you also meantioned the next video was going to be on looping throw for all and the deep linking. Please may you add into the link deep linking side of the request a understaning standing of using the http// deep link and then using the mobile app launcher where you can deep link with Parma's into a mobile Micorosft app. My question is how would you do the mobile app launch from lets say a email or a link on a task in planner, its simple and all your deep linking vidoes work like maigc but would like to be able to send the person to the moble app if they have Power Apps downloaded on the mobile. Say you give options in the email to open in a web browser or in the mobile Microsoft Power Apps passing the same prams without having to open the web browser and then launch then to mobile from within the Online App. Hope I explained that well. Thank you and love the videos ❤
@@ShanesCows Thank you. I have tried but haven't gotten it right. Use case is sending a email to a front line staff member that will open the email or task in planner from there phone. So having it open in the browser when using a tablet or phone sometimes will be better to have the app open in the Microsoft Power App Mobile straight from the link. I have done it on the on start where I check to see the device screen size or in the past from April's video using the acceleration and something else to check if it's a desk top or mobile. If it's mobile it will then do the app deep link and open the app again in the Microsoft Power App Mobile. But it first opens the web version from the link.
Thanks Shane. Because of you the people I work with think I'm smart.
Hey Shane! Thanks for all of the videos you put out. One thing I've noticed is that there are a decent amount of RUclips videos and other content out there about how to do things in Power Apps and about Power Platform certifications. I think all of this is great, but one video I'd love to see would be a video on what career paths are available for people who want to work full time in the Power Platform. I think that this is fairly established for people who do Power BI, but what does the day in the life of an Power App Maker or a Power Automate specialist look like? Maybe there are not more videos like this out there because the Power Platform is still pretty new not too sure, but a video that talks about the career paths someone can take with Power Platform would be something I'd be interested in.
That is a good idea for a video. I have thought about it a couple of times. I actually did a Short on job titles ruclips.net/user/shorts8JnQCleQ7Xo But I will give this a think, I see how it would be helpful. :) Thanks
Shane, THANK YOU! This is genius. Exactly what I was looking for to solve a problem selecting multiple items.
Awesome! Glad to help.
nice to learn with you Shane. Thanks for posting this type of video. Encouraging the new people to learn. Thank you really great!❤
Glad you enjoyed it!
hey Shane, thanks for this video. It helped me understand how vertical and horizontal containers work. I never used them before.
However I have found a small glitch. If you unselect checkboxes in the gallery and click the Select All button, unselected checkboxes are not selected again.
To fix this issue I added 'UpdateContext({varReset:true});UpdateContext({varReset:false})' in OnSelect of the 'Select All' button, the same way than what was done for the Unselect button.
Nice job Eric! 😎
Thank you for your work! Happy New Year!
Happy new year!
Hi Shane, many thanks for this very useful video! I have come across a strange 'anomaly', which I thought I'd share in case you have also come across this too. I used your technique to count how many items have been selected in a gallery via a checkbox and it works fine when you just have a normal gallery in a maincontainer of a 'Header and footer' screen layout say. The figure is displayed in a label just like your example. So I used: CountRows(Filter(Gallery1.AllItems, Checkbox1.Value)). However, if you edit the gallery and add a container first, then add a checkbox and other fields that you wish to display within that container, then whenever you select the checkbox, using that same formula - we get the total number of rows displayed every time we select any of the checkboxes, rather than the count of how many were selected. So in my case even though I selected one checkbox, the figure says 8, as there's eight items in total. Is there some formulaic way we can overcome that, or is this one of the 'features' that we just have to accept, and not have containers for each row of data?
I am not sure. I understand that by it isn’t working because the checkbox is now down a layer. Not sure how I would work around the issue though. 🤔
@@ShanesCows Hey not to worry. It must be just a limitation. Thanks for getting back though.
That is an excellent idea, Thank you for the tutorial.
Glad you liked it!
Hello Shane, thank you for the video. Do you have a video on using 'select all' option to only select filtered items in the gallery, rather than all items in the gallery?
Thank you so much for this video, Shane. It came in handy
wow! ironically, this video links to my Q in your last vid on named formulas and delegation of tables stored in these Vs using collections. I didn't realize you could filter Galleries with ref to themselves as opposed to the source data. I'm looking to get around non-delegable barriers when comparing galleries to each other. So in my example, gal 2 is based on a list patched from records selected from a master Sharepont list. And Gal 1 is itself based on the master list, filtering out any records the user previously patched to to the list Gal 2 is based on (so they cannot re-select the same item into their 'personal list' - i.e. a copy of an item from the master list in conjunction with their User ID will be the filter conditions used in Gal 1). This means the that while Gal 1 will never have issues relating to delegation because the number of records wont exceed 2000, Gal 2 could repeat the same records across different users hence get v large. Tried sticking to 'Starts With' and 'Filter' but invariably the comparison check between galleries requires operators that are non-delegable e.g. items property for Gal 1 being: Filter('datasource for Gal 1', Not(Title exactin 'data source for Gal2'.Title) AND User().FullName in Lower(FullName)).Title))
Wow thanks Shane 🙏🙏🙏
Glad it helped.
Thank you! This got me started. Your videos are always helpful! I have a parent SP list that is connected to another SP list using the IDcopy column to a RefID column. There are numerous records on the child SP list per single record on the parent list. How can I select multiple parent items (IDcopy) and pull all pertaining records on the child list? End goal is to export to excel.
Happy new year 🎉 & Thanks for the video, for the next video😅:
If you can add how to patch the checked in anther page? Maybe visualize the checked ✔️ item before patching form another page 🙏🏽.
I used a Navigation function but didn't quite work 😂.
Have a great day
I will see what I can do
Nice. Thanks for sharing and Happy New Year 🥳🥳
Thank you! You too! Hopefully lots of cool stuff to come this year! 🐶
This is exactly what I was looking for 👍🏻👍🏻👍🏻
Awesome! Glad to help :)
Hey Shane, Thanks for the works. Is there a possibility to implement "Shift" key Mutiple selection, just like how to can do in Excel/Outlook where hold shift key will allowed users to select all items in-between
Not that I know of.
If you store your data in a collection, you can include a Boolean value to store the checkbox value as well as a calculated row value. You can then add select range button to update the collection with the true/false values with a row range.
Excellent as always and reinforces things I'd already put into practice. Reassuringly I'd done this the same way! :) HNY
Happy new year!
Hey Shane! I need an information , for you is possible manage all ms planner with power app?
I have had a good result with power bi, but it’s just to view.
I need a power apps that are able to modify all my plan.
It’s possible or I can found some limitations?
Thanks for all ! You are my guide on ms word
Thanks, Shane. You're always my inspiration. Only a question: is there a limit (100) with this code? I have more than 100 items and the only way I have found to increase de Countrows is running trhough the gallery untill the end. Is there any other way to avoid this limit? Thanks.
Hi Shane!! Thats not the subject of the video, but i noticed you've done something i'm struggling with. How could i show the image of each item in the gallery like this? I have a list of employees and im trying to show them in a gallery with their profile photos as the image of the gallery. The list have a "person" column type and the photos are appearing in sharepoint, but when i try to configure the field image of the list, it only allows me to select sample image or upload one, and if i do so, the same image appears to all items. Thanks!!
You need to use the Office 365 User connector to retrieve each users photo. Very brief intro in this old video. PowerApps User Function and intro to Office 365 User connector
ruclips.net/video/FpXrF5NDZbI/видео.html
Excellent, thanks!
Happy to help. Have a great day. 🐶
Hi Shane, i tried your way to reset checkboxes on click of cancel button, but somehow its not working. I have a SharePoint integrated form. I have a choice column which i created as gallery with checkboxes. On new item, if i am selecting the checkboxes, on click of cancel it should clear the checkboxes. but its not happening, when opening the form again, the checkboxes remained checked. Please advise on how to proceed. Thanks in Advance!
Hey shane can please help me how to patch a multi select combobox inside a gallery to a sharepoint list when the column type selected in the combobox is people or group type?
This video explains the syntax that it is looking for ruclips.net/video/b4Fb57UsJLI/видео.html
Thank you so much 😅 but I would like to know that How to show a picture that selected from gallery (SharePoint) in HTML sending email ?
Try this video ruclips.net/video/BUUCATSKNK0/видео.html it talks about getting the base64 for images (from your gallery would be fine) and then embedding it different places, include in HTML.
@@ShanesCows thank you so muchhh it's already complete! :)
Hi Sir, how do you add the selected items from the gallery into the collection?
when I select multiple items from the gallery, only 1 get added into the collection
When is second video available
Très intéressant
Gracias
on new controls Reset , Default properties doesn't exist any more, or at least on my end in power apps for Teams
Ugh, does the Reset function work on them? I honestly haven't used the new functions much at all.
@@ShanesCows there is no Reset property anymore and for Default I use Checked property to be able to make same functionality as the one described in your video ( one that is uses context variables) for check/uncheck checkboxes in my Teams app
IDK Why my checkbox doesn't have Reset propertie can you help me out?
It is because you are using the new modern controls and they don't have a Reset property. :( Not sure how to do this with the new controls.
Many thanks for this video!! am I the only one who can't find the reset property on the checkbox object?
Are you using the Classic or Modern checkbox. I haven't looked at the Modern to confirm the do the same.
Instead of showing the number of gallery items checked, what if you wanted to show in a label outside the gallery the actual selections? I tried using the concatenate function and failed.
Excelent idea
Thanks. I thought it would be helpful. 😎
CAn you link the next video please?
ruclips.net/video/fmLCnIeYcn4/видео.html
ur..what's going on about your red face
😹 I got a new camera and clearly I need to spend more time adjusting the color. 😹 I have fought this issue for years, my skin has a lot of redness built in, so if I get the color wrong I look super red on camera. I promise my face is its normal pale wierdo color in person. 😳
Good Evening Shane
Hope you are well and happy new year all the best going forard for the year ahaed.
At the end of the video you asked for requests, you also meantioned the next video was going to be on looping throw for all and the deep linking. Please may you add into the link deep linking side of the request a understaning standing of using the http// deep link and then using the mobile app launcher where you can deep link with Parma's into a mobile Micorosft app. My question is how would you do the mobile app launch from lets say a email or a link on a task in planner, its simple and all your deep linking vidoes work like maigc but would like to be able to send the person to the moble app if they have Power Apps downloaded on the mobile. Say you give options in the email to open in a web browser or in the mobile Microsoft Power Apps passing the same prams without having to open the web browser and then launch then to mobile from within the Online App.
Hope I explained that well.
Thank you and love the videos ❤
I have never tried to do the app linking, I get what you are asking. I will put it on my list to look at. :)
@@ShanesCows
Thank you. I have tried but haven't gotten it right. Use case is sending a email to a front line staff member that will open the email or task in planner from there phone. So having it open in the browser when using a tablet or phone sometimes will be better to have the app open in the Microsoft Power App Mobile straight from the link. I have done it on the on start where I check to see the device screen size or in the past from April's video using the acceleration and something else to check if it's a desk top or mobile. If it's mobile it will then do the app deep link and open the app again in the Microsoft Power App Mobile. But it first opens the web version from the link.