Thank you for putting these videos together Shane. They have saved me countless days of effort and headache. I have the reached point where my wife hears your voice more often than mine! The way you break down each concept into simple steps, and then gradually merge them into solution, as well as do it all in an entertaining way is a rare gift. You're awesome dude.
@@ShanesCows Haha Shane you are like Wasabi. The first time you taste it it stings a bit, but then you get used to it and love it lol .. keep up all of the awesome videos!!
Done it with Concurrent: Create two buttons, one that Launches, the other that exits (true). Then create another button that does concurrent with Select both (I've put Launch first). It works.
Was looking for a "dropdown blanking" technique last week, but could not get anything to work. As you were talking about the "AllowEmptySelection" property, immediately paused your video, applied it to my four cascading dropdowns and it worked just like that. 👍👍👍 Wanted to use Notifications last week, but did not for the same reason you mentioned (User would have to close notification window", but now with timer parameter, its all GO! ✔✔✔ Thanks !!!
I like to use Self for Tooltips. If the text box can't fit unusually long answers on the screen, set tooltip to Self.Text, then the user can hover over the text/label to see the full text. You can highlight many controls and do this to all of them at once.
Aa usual, excellent video. Thanks for this. I still think selection of same value by user in drop-down making it blank is rather a bug and not a good user experience.
That was my first reaction, too, but then I looked at it as a deselect. When blank & user clicks, it selects. When selected & user clicks, it deselects. If users understand it that way (training), then it could be good UX.
Thanks, Shane, "Self" looks like a huge time saver if I do say so my.....self ;-P The Outlook connector caused issues with "guest users" in our environment being able to sign in to the app initially, ie they might have a gmail address so that connector didn't let them sign in, so cutting the Outlook connector and using "mailto:" functionality instead is the current workaround for still letting them quickly share deeplinks and such, although it's too bad no more html formatting etc.
Great video. I'm having issues with Exit(true) when running my app on the mobile version of powerapps. It leaves the account logged in, asking only for my text verification code. Have you had any issues with this?
I immediately thought of using Concurrent to launch Exit and Launch at the same time, but Exit is not allowed in Concurrent. :-( too bad Love to see your vids. Learned a lot. Thanks.
Hi Shane, Thanks for tipp with launch into target 'Self'. This combined with a very simple .html page, which just inherits a window.close from Javascript OnLoad brings you the solution of closing the PowerApps Window. Regard Michael Source html> window.close();
Awesome video..you provide a great level of detail in every step. Thank you for that. Had a doubt on "Close Window" - is this possible through any of the functions..exit will help you exit and launch will pop open a new web address..but can't figure out closing the current window after clicking on a button in Power Apps
Cool video, especially for the Launch. Too bad, as mentioned in Microsoft Docs, this features does not supported Embed Apps. Do you have any tricks for this ? My initial plan is to embed and use this kind of "call a webpage" inside Dynamics 365, then the page still open in the window tile, not replacing my whole Dynamics 365 screen. Thanks Shane.
As usual great job. Thank you. You often make my day! Can you advise a video or a course of yours where it becomes clearer how plans could/should be used to minimize organisation budget licensing with powerapps?
Hey Gilles I don’t have a class that covers licenses specially. 😑 If you have questions you can try www.PowerApps911.com contact us and we might be able to help
How can I ask you a more in-depth question that takes a bit of explaining to ask? I am having trouble with using SharePoint lookup columns in PowerApps. I want to be able to ask and link screenshots if need be to get an answer. I have tried everything I can find with no luck at all. Great videos!
Hi Shane, I have seen your videos and they are great, I was able to program a complete app to take the training attendance data from my work team, but I would like to know if it is possible to make the questions mandatory, since some do not fill all the fields that are requested. I appreciate your answer and I hope you can help me
Yes. Look at this video and just think about setting the displaymode of the submit button to disabled if they don’t enter the info. ruclips.net/video/IvapIsBbM-U/видео.html
I'm not sure if this is because my link has to to with SharePoint, but the LaunchTarget doesn't recognize 'Blank' like you showed. Not that I need to use it but was trying it. The only options were New and Replace
As helpful as always. Thank you! Is there a way to "reuse" the items of a dropdown in another one? I have 5 dropdowns with a list of cities and I want the same items in all of them, but I don't want to update all 5 dropdowns (items) whenever I need to add a city to the list.
Yes you can! Put the items in a collection and then use the collection for the items property. ruclips.net/video/yS6mTRlmuls/видео.html Create the collection OnStart for your app.
Thanks for the vid Shane. The blank drop down is so helpful and I will too change a couple of of my apps. I wonder if you have any thoughts / experience with producing documentation for Power Apps - my managers are thrilled with the Apps I’m making but IT department are wary due to lack of documentation and legacy issues. Do you have any templates or best practise for this?
I cover it in my class a bit. Most formulas are self documenting. If not I use // to add code comments. Finally you can make a screen at the end of the app, that only show to makers, that has notes about The Who, what, when, why of the app
Hi, I have a doubt here. We can open a new tab using Launch function but is there any way we can replace the earlier opened tab instead of multiple new tabs? I mean if I click on Launch button then it should not open a tab if the tab is already opened, it should replace the new tab.
Thank you for sharing, It's really helpful. In launch function I'm getting error on LaunchTarget.'Self' But getting below option - Launch("URL", {}, LaunchTarget.Replace), Any idea? Thank you
Hi Shane, thanks for another awesome video. With the launch issue, can you launch into a new window and log out of the PowerApps environment? I know that it would leave a redundant browser tab open but might be a workaround
hello Shane, the power apps is possible to create APP for general public or just for the company? I want to make an APP for people who do not have a microsoft account.
Hello Mr.Shane, Thank you for the Allowempty Selection, BUT As soon as i use AllowEmptySelection, i cant seem to disable all my other dropdown like i usually did, eg. If(Dropdown_System.Selected.Result="",Disabled,Edit) Can you suggest me how i can disable my other dropdown unless the Dropdown of the AllowEmptySelection was is selected.
If someone is using your app and they close their browser mid way through completing, does the app / forms / collections reset and not save any of their data?
Thanks Shane!!! do you know if I can get a touch position with self? , now I have three galleries covering the screen with a "hundred" squares labels to get "the touchpoint " and also change the color when it is touched. Works but the load are slow and is not exactly because of the gallery limits.
Notify standard appearance is 10 seconds. With 0 it stands forever. How do you handle launching an another app with launch und target self? I’m using a if-statement because it makes a different if I want that new app starting in my browser or in my mobile power app app. ;). And concerning the exit() function: do you know a way to modify the confirm exit manual during runtime? If I’m using a variable for the confirm message, the standard message appears. :(. And Lust not least: nice video - as always! 😎
Enjoying your videos! It doesn't look like you have covered it, so I wanted to ask if you can direct me to an existing video or maybe you can address it in a future video: Use PowerApps with PowerAutomate using the Flow within a Flow method to connect to an Excel Spreadsheet in OneDrive for Business (or even a Sharepoint List) without giving permissions to end users so that you can read from and write to a table. The app I am working on now is failing to connect to the data unless I explicitly give permissions to the individual account to the folder where the spreadsheet resides. It works fine from the web if I only give permission to the spreadsheet, but using the app on the phone it gripes until I give edit permissions at the folder level. Thanks in advance!
Jason I haven't covered it. What I would recommend? Switch to using a better data source, maybe SharePoint, instead of Excel. Excel has so many issues when you try to build full solutions on it.
Thank you... In my code part Exit(true/false) function not working.... please help. i tried Exit()also. i applied this logic to Close button.. will it works for Close button(X) ?
@@ShanesCows i did it it worked... lol... im not a programmer but your videos are easy to understand and i have been successful in many apps that i have created..
Shane, when I select the choice item in the drop down again to clear the field, it does clear the item in the form but does not clear the item in the sharepoint list. Is this an issue with SP lists?
Thank you Shane for your tips and sharing. I'm facing an issue with launch for the apps embedded in SharePoint modern page. My code is - Launch("Google.com",{ q: "PowerApps"}, LaunchTarget.Replace,{}), Working in App Player, Not working from SharePoint Page. Any idea? Thanks in advance.
I have Notify for one Datepicker field which is "Selection Date is should not less than today." But i'm Getting this error even when form is loading at start.
Hi can you do a video on the audit app? which allow you to save a photo to a particular question. I am stuck in creating it using SharePoint as datasource. Thank you
hi shane... thanks for the great video. i would like to ask one question... i am new to this app. i have an sharepoint table with various eng name like krc, ns, ps, sp,... with n number of calls for each one. if i want to group them with name and call count how to do this plz?
Hey Shane, love your work for the Microsoft Community! Maybe somebody can help me with a problem. I have 2 entitys ("Tasks" and "Table1") . Now i have a a Lookup Field on Tasks, pointing on the Table1. Now when i go on Powerapps on a Item in Table 1, i want to see a lists of all Tasks which lookup is on the selected item. So i thought about filtering on the selecteditem and on the lookup. But filtering on the lookup doesnt work. Can anybody help me with this problem? You would safe my day!
@@ShanesCows I have an application that requires that when a user logs in, they are presented with information that is different from that of another user. At the moment I have created a username and password in a Sharepoint list. But how do you create a login screen using an email account in Office 365?....thanks for your help, I like so mucho your channel in RUclips. :) greetings from El Salvador.
For some reason I cant get the exit buttons to work, I've down the onselect Exit(true) & Exit(false) but nothing is happening. (Very Very new to powerapps)
Thank you for putting these videos together Shane. They have saved me countless days of effort and headache. I have the reached point where my wife hears your voice more often than mine! The way you break down each concept into simple steps, and then gradually merge them into solution, as well as do it all in an entertaining way is a rare gift. You're awesome dude.
Thanks 😍 There are a few people have posted similar. There spouse is tired of my voice. 😜
@@ShanesCows Haha Shane you are like Wasabi. The first time you taste it it stings a bit, but then you get used to it and love it lol .. keep up all of the awesome videos!!
The allowing empty selection was EXACTLY what I was looking for! Thanks for your great videos, as always.
Done it with Concurrent: Create two buttons, one that Launches, the other that exits (true). Then create another button that does concurrent with Select both (I've put Launch first). It works.
You are a 🤩 comment pinned. Hope everyone sees it.
Hi Shane. Great video. Your little tips videos are my favorite. Hope to see more of that.
More to come!
Worth it for the blank drop down option only haha Thanks Shane
Thanks 😊
Antoher bullseye from the master of PowerApps, Mr. Shane Young!!!!
Thanks Frank
Great to have self! managing Requeried with visible or fills, colors, etc depending on another property. So much simple.
Agreed!
Was looking for a "dropdown blanking" technique last week, but could not get anything to work. As you were talking about the "AllowEmptySelection" property, immediately paused your video, applied it to my four cascading dropdowns and it worked just like that. 👍👍👍 Wanted to use Notifications last week, but did not for the same reason you mentioned (User would have to close notification window", but now with timer parameter, its all GO! ✔✔✔ Thanks !!!
Love it! 😍
I like to use Self for Tooltips. If the text box can't fit unusually long answers on the screen, set tooltip to Self.Text, then the user can hover over the text/label to see the full text. You can highlight many controls and do this to all of them at once.
Solid! I like it. 😎
Thanks a lot Shane for sharing this video.
Happy to help
As soon as I saw "self" appear, I was wondering how long it would take you to cover it 😉 this is one simple amazing time saving thing!
Agreed. We are loving it.
Thanks again Shane another great video!!! . Just used the Notify, self and email in the app im building today. btw awesome new header.
Thanks Lee. You are the first to comment. 😍 It made me happy.
Thanks Shane for the create video!
You are welcome Marcel
you are amazing, you won a new subscriber
Happy to help. Have a great day. 🐶
Thank you dear you are awesome as usual
Glad to help. 😀
Aa usual, excellent video. Thanks for this. I still think selection of same value by user in drop-down making it blank is rather a bug and not a good user experience.
Yeah, it's kinda weird, not sure if I like it or not really.
Fair. I like it but 🤷♂️
That was my first reaction, too, but then I looked at it as a deselect. When blank & user clicks, it selects. When selected & user clicks, it deselects. If users understand it that way (training), then it could be good UX.
Thanks, Shane, "Self" looks like a huge time saver if I do say so my.....self ;-P The Outlook connector caused issues with "guest users" in our environment being able to sign in to the app initially, ie they might have a gmail address so that connector didn't let them sign in, so cutting the Outlook connector and using "mailto:" functionality instead is the current workaround for still letting them quickly share deeplinks and such, although it's too bad no more html formatting etc.
Keep your jokes to your...self 😂😂😂😂 I like MailTo also
Great video. I'm having issues with Exit(true) when running my app on the mobile version of powerapps. It leaves the account logged in, asking only for my text verification code. Have you had any issues with this?
I haven't done much with Exit for customer apps and haven't seen that scenario before. SOrry, I am no help.
I immediately thought of using Concurrent to launch Exit and Launch at the same time, but Exit is not allowed in Concurrent. :-( too bad
Love to see your vids. Learned a lot. Thanks.
You can set them as button actions and then have another button that selects those buttons. Select is permitted in Concurrent and it actually works.
Glad to help. 😀
Hi Shane,
Thanks for tipp with launch into target 'Self'. This combined with a very simple .html page, which just inherits a window.close from Javascript OnLoad brings you the solution of closing the PowerApps Window.
Regard Michael
Source
html>
window.close();
Thank you for Sharing Michael. 😀
Awesome video..you provide a great level of detail in every step. Thank you for that. Had a doubt on "Close Window" - is this possible through any of the functions..exit will help you exit and launch will pop open a new web address..but can't figure out closing the current window after clicking on a button in Power Apps
I don't know how to force the window closed. :(
You are my real MVP!!! thanks for this
Thanks 😊
Really liking the Launch to Outlook button. One question, how would I incorporate attachments into the mailto: commands?
I don’t think it is possible 😑
@@ShanesCows Thanks! I ended up using the built-in email screen with the collection you showed in another video added to it's send button. :)
Cool video, especially for the Launch. Too bad, as mentioned in Microsoft Docs, this features does not supported Embed Apps.
Do you have any tricks for this ?
My initial plan is to embed and use this kind of "call a webpage" inside Dynamics 365, then the page still open in the window tile, not replacing my whole Dynamics 365 screen.
Thanks Shane.
I wish I did. But I got nothing
the default interval for notify is 10 seconds, and to enforce permanent notifications, you need to specify 0
Thanks for sharing 😀
Awesome stuff!!!! Greatly appreciate it!
Thanks 🙏
Thanks for this, Shane. can you also teach us how to add value to the ones already in the dropdown options.
Not any great ways. You would have to put the values in a collection, add new values to collection, and then use the collection to feed the Dropdown
As usual great job. Thank you. You often make my day! Can you advise a video or a course of yours where it becomes clearer how plans could/should be used to minimize organisation budget licensing with powerapps?
Hey Gilles I don’t have a class that covers licenses specially. 😑 If you have questions you can try www.PowerApps911.com contact us and we might be able to help
How can I ask you a more in-depth question that takes a bit of explaining to ask? I am having trouble with using SharePoint lookup columns in PowerApps. I want to be able to ask and link screenshots if need be to get an answer. I have tried everything I can find with no luck at all. Great videos!
www.PowerApps911.com and click contact us
Hi Shane, I have seen your videos and they are great, I was able to program a complete app to take the training attendance data from my work team, but I would like to know if it is possible to make the questions mandatory, since some do not fill all the fields that are requested. I appreciate your answer and I hope you can help me
Yes. Look at this video and just think about setting the displaymode of the submit button to disabled if they don’t enter the info. ruclips.net/video/IvapIsBbM-U/видео.html
I'm not sure if this is because my link has to to with SharePoint, but the LaunchTarget doesn't recognize 'Blank' like you showed. Not that I need to use it but was trying it. The only options were New and Replace
You would use New. They updated the function. 😑
As helpful as always. Thank you!
Is there a way to "reuse" the items of a dropdown in another one? I have 5 dropdowns with a list of cities and I want the same items in all of them, but I don't want to update all 5 dropdowns (items) whenever I need to add a city to the list.
Yes you can! Put the items in a collection and then use the collection for the items property. ruclips.net/video/yS6mTRlmuls/видео.html Create the collection OnStart for your app.
Thanks for the vid Shane. The blank drop down is so helpful and I will too change a couple of of my apps. I wonder if you have any thoughts / experience with producing documentation for Power Apps - my managers are thrilled with the Apps I’m making but IT department are wary due to lack of documentation and legacy issues. Do you have any templates or best practise for this?
I cover it in my class a bit. Most formulas are self documenting. If not I use // to add code comments. Finally you can make a screen at the end of the app, that only show to makers, that has notes about The Who, what, when, why of the app
I'm new to Power Apps. Is it possible to notify the user when your app is running in the background?
Hi, I have a doubt here. We can open a new tab using Launch function but is there any way we can replace the earlier opened tab instead of multiple new tabs? I mean if I click on Launch button then it should not open a tab if the tab is already opened, it should replace the new tab.
Not that I know of.
Thank you for sharing, It's really helpful.
In launch function I'm getting error on LaunchTarget.'Self'
But getting below option
- Launch("URL", {}, LaunchTarget.Replace),
Any idea?
Thank you
This blog post explains why powerapps.microsoft.com/en-us/blog/formulas-launch-to-self-and-self-operator/
Hi Shane, thanks for another awesome video. With the launch issue, can you launch into a new window and log out of the PowerApps environment? I know that it would leave a redundant browser tab open but might be a workaround
That sound like it would work. 😀
Hi there - have you figured out a way to close the actual TAB the app is running in?
Nope 😑
hello Shane, the power apps is possible to create APP for general public or just for the company? I want to make an APP for people who do not have a microsoft account.
Not the general public
@@ShanesCows ok, thanks you!
Hello Mr.Shane, Thank you for the Allowempty Selection, BUT
As soon as i use AllowEmptySelection, i cant seem to disable all my other dropdown like i usually did,
eg.
If(Dropdown_System.Selected.Result="",Disabled,Edit)
Can you suggest me how i can disable my other dropdown unless the Dropdown of the AllowEmptySelection was is selected.
Use IsBlank(Dropdown.selected.column) instead
Thanks Shane... nice video.. How comfortable are you with Portal Apps? Shall we work more on Portal or Canvas App?
I haven’t explored portals yet. One day!
"Shall we work more on Portal or Canvas App?" Who's your target audience?
I love Canvas Apps! 😎
Thank you Shane. What about Launch, after this Navigate to new screen and on a property On visible of a new Screen enter this Exit(true)?
Interesting idea. Will have to try it. thanks
If someone is using your app and they close their browser mid way through completing, does the app / forms / collections reset and not save any of their data?
Correct. If you want to save all of that you would have to build logic to save things automatically as they enter it.
Thanks Shane!!!
do you know if I can get a touch position with self? , now I have three galleries covering the screen with a "hundred" squares labels to get "the touchpoint " and also change the color when it is touched. Works but the load are slow and is not exactly because of the gallery limits.
Not sure on the one. Sorry
Notify standard appearance is 10 seconds. With 0 it stands forever. How do you handle launching an another app with launch und target self? I’m using a if-statement because it makes a different if I want that new app starting in my browser or in my mobile power app app. ;). And concerning the exit() function: do you know a way to modify the confirm exit manual during runtime? If I’m using a variable for the confirm message, the standard message appears. :(. And Lust not least: nice video - as always! 😎
Thanks. I haven’t dug in enough but post back as you solve each one. 😎
Does this by any chance solve the "zoom-problem" with dropdowns on iphones?
I don’t know but I doubt it changes the behavior
Enjoying your videos! It doesn't look like you have covered it, so I wanted to ask if you can direct me to an existing video or maybe you can address it in a future video:
Use PowerApps with PowerAutomate using the Flow within a Flow method to connect to an Excel Spreadsheet in OneDrive for Business (or even a Sharepoint List) without giving permissions to end users so that you can read from and write to a table. The app I am working on now is failing to connect to the data unless I explicitly give permissions to the individual account to the folder where the spreadsheet resides. It works fine from the web if I only give permission to the spreadsheet, but using the app on the phone it gripes until I give edit permissions at the folder level.
Thanks in advance!
Jason I haven't covered it. What I would recommend? Switch to using a better data source, maybe SharePoint, instead of Excel. Excel has so many issues when you try to build full solutions on it.
Thank you... In my code part Exit(true/false) function not working.... please help. i tried Exit()also. i applied this logic to Close button.. will it works for Close button(X) ?
Hi Shane, considering AllowEmptySelection, how would I disable a second dropdown until first dropdown is no longer blank?
Figured it out: If(IsBlank(DropDown_Region.SelectedText.Value), DisplayMode.Disabled, DisplayMode.Edit)
Glad you got it. 🐶
Can you add a video of running total in PowerApps. Thanks Shane!
Look for my video on Sum. ruclips.net/video/DF4KX1oSrVI/видео.html
great tips
Thanks 😊
Shawn great videos as always.. The notify will work simoultaneously with the submit function? Using a sharepoint list...
Yes or you could put Notify in the OnSuccess property of the form to have it run after the submit is actually done.
@@ShanesCows i did it it worked... lol... im not a programmer but your videos are easy to understand and i have been successful in many apps that i have created..
Shane, when I select the choice item in the drop down again to clear the field, it does clear the item in the form but does not clear the item in the sharepoint list. Is this an issue with SP lists?
I think you need to save it back.
I love you Shane
😍
spend few hours to add dynamically blank entry to my dropdown lol. No i use allowemptyselection..
BTW, 77780 points - good job ;-)
Nice work!
Good new things
Glad you liked them. Hopefully they make your apps more awesome! 😎
Thank you Shane for your tips and sharing. I'm facing an issue with launch for the apps embedded in SharePoint modern page. My code is - Launch("Google.com",{ q: "PowerApps"}, LaunchTarget.Replace,{}), Working in App Player, Not working from SharePoint Page. Any idea? Thanks in advance.
I don’t think you need the final {} but I have never seen it not work before. 😕
@@ShanesCows It seems some issue with Power App Player. Tried in old way, insert the App as a Iframe and it worked.
Thank you.
I have Notify for one Datepicker field which is "Selection Date is should not less than today." But i'm Getting this error even when form is loading at start.
You might have to change when you do the check to avoid conflicts while the app loads.
On fire 🎉 soo cool thanks
Thank you! 🔥
Hi can you do a video on the audit app? which allow you to save a photo to a particular question. I am stuck in creating it using SharePoint as datasource. Thank you
Try looking at this ruclips.net/video/NwbqdA9j8Ek/видео.html
@@ShanesCows Thank you sir I will look thru it cheers!!! :)
How to close the form after submitting to SharePoint site?
how to possible filter on multiline of Text Field without delegation?
I don’t think it is possible
hi shane... thanks for the great video. i would like to ask one question... i am new to this app. i have an sharepoint table with various eng name like krc, ns, ps, sp,... with n number of calls for each one. if i want to group them with name and call count how to do this plz?
There is a GroupBy function that might help.
Thank goodness I was right. I say that a lot a work 🤣😜
Great job! 😁
Hey Shane, love your work for the Microsoft Community! Maybe somebody can help me with a problem.
I have 2 entitys ("Tasks" and "Table1") . Now i have a a Lookup Field on Tasks, pointing on the Table1. Now when i go on Powerapps on a Item in Table 1, i want to see a lists of all Tasks which lookup is on the selected item. So i thought about filtering on the selecteditem and on the lookup. But filtering on the lookup doesnt work. Can anybody help me with this problem? You would safe my day!
Hoping to do a video on Lookup columns soon that might help
may you explain how create screen login with credentials of user with Office365?
You have to login to open the app so I have never made a login screen in the app. Not sure you can
@@ShanesCows I have an application that requires that when a user logs in, they are presented with information that is different from that of another user. At the moment I have created a username and password in a Sharepoint list. But how do you create a login screen using an email account in Office 365?....thanks for your help, I like so mucho your channel in RUclips. :) greetings from El Salvador.
For some reason I cant get the exit buttons to work, I've down the onselect Exit(true) & Exit(false) but nothing is happening. (Very Very new to powerapps)
Exit might not work when you are in the studio. Did you publish your app and try it that way
Noticed it works when using the app on my phone
how to implement in component
I haven't tried yet.
man i literally cant get exit to work and its such an easy function... not even Exit(false)
Hmmm. I haven't ran into scenarios where it didn't work. Sorry
Good day I have two apps and i want to exit and return to the previous app however it redirects to dynamics 365. Any help on this please thank you. 😄
Not sure. Check the other people's comments for some ideas other people have tried.