Just found this video today at the beginning of my powerapps journey. You explain this stuff so well that it still holds up over 5 years later. Cheers, Shane :)
🤩 Thanks. There is a newer version, though it is 3 years old now, if you wanted to see the topic covered better. :) ua-cam.com/video/vpYkOccwn4Y/v-deo.html If not enjoy the 400ish videos I have and enjoy the journey, learn Power Apps is fun.
Thanks to you I have created the perfect fill-out form. As a person with zero coding experience, I can say you are great explaining everything so people like me can understand.
Hi Shane, I've been using your videos and they are a great introduction to Power Apps. I am trying to send a link using the formula you provided. That formula is no longer valid, do you know what is the new way to formulate the "Link" part? ThisItem.'{Link}' doesn't work with single or double quotes. What am I doing wrong?
Already subscribed to your channel a few weeks back but just found this video. I had problem with email (still a newbie in PowerApps) but after watching your video, my problems were solved. Thanks very much!!!
Thanks for that video man!! Appreciated!! . I have a question in that same botton can you ( send email), save&close the data that you put on your form list and change an status column to Pending?
Hi I have been looking at a lot of your PowerApps videos and was wondering can you create an email with all the selected Items from a listbox contained in the body of the email if so do you have a video on it
Great walk through Shane breaking the processes down where they're easier to follow. Do you have a walk through of how to, using PowerApps, connect a name field to Office 365 Users and then send an email?
Hi Shane, I really enjoyed the video, i've watched many so far. I'm using the quicktasks app template and i can't seem to figure out how to add a second email address to the app, do you happen to know how one might do that?
Thanks a lot! It was very helpful!! Where in the sequence you add Reset form?? I am thinking about a suggestions form, and must be reset after someone sends the email
Lots of basic things have changed. Can you make one video on some of the key differences to help us navigate through these old videos. Their great, but I don't even know how to add a data card to the form.
Hi Shane, which is better... use Outlook connector/SendEmail or use Flow (I mean Power Automate... ugly name) to send the email? I think connecting with Flow is better since you can see the run history??
Hi Shane, great video but I have just tried this. And I get this message This formula uses scope, which is not currently supported for evaluation? what can I do to correct this?
Hey Shane! So appreciate what you do!!! I’m trying to have the body of the email include what a user has selected in a drop down input. Is that possible? Do you have a video that covers that?
Hi Shane, Nice video I have a question on email routing, is there a way to pass dynamically the to email address in power apps forms after clicking on submit button. It should dynamically take the email address from the Azure SQL Table. I have seen that we can achieve by using Flow, but would like to use the Powerapps itself, can you please suggest any idea ? Thanks.
Shane due to your videos, I actually feel like i'm learning! Let's say I had a checkbox on the screen before the details screen. If the checkbox was checked on the initial screen, I also want the checkbox on the details screen to get checked. how do I complete this task?
Set the checkbox on the first screen to set a variable when it gets checked. Have the second screen checkbox use that variable as the default value. :)
Hey Shane great videos. I am also trying and learning powerapps and your videos are helping me a lot. Could you please help me with some use cases in real world for the powerapps. Where we can take a real advantage of powerapps? Thanks
The first answer is I would make the group as a distribution list in Exchange. Then just send the email to the Distribution List. You could also change the to portion to be shane@example.com;bob@example.com that would work to send to multiple people.
Shane, first of all, thank you so much for all your vídeos. They have helped me a lot on my job. I just have one question. I have a data table which I filter depending on some parameters, is it possible to send this data table in the email body? I need to click on the email button and send the message with the data table in the body or as attachment. Thanks
Great video and exactly what I needed. I have been working on a project to migrate our current intranet (PHP) into our SharePoint and O365 tenant and I am finding Power Apps VERY useful. And I just subbed to your channel. Good stuff
I am soon going to be tackling using power apps with flows. I wouldn't mind seeing that, unless you have already done one. Also, I watched the one with variables and I have a screen with one form and would like to set the variable value at the time of the app starting and I have yet to figure that out
So usually to set a variable at the start you can go to the first Screen and set the OnStart property. That is the closest thing to initializing you are going to get. I actually show it in an upcoming video. Here is the doc. docs.microsoft.com/en-us/powerapps/controls/control-screen
Great, thanks for the info. I will pay around with it as when I go to set the variable in the screen, it tells me that Context variables are not allowed. Even though I have one screen and one form. Instead of using (UpdateContext) I will just try to use Set on the variable and see what happens.
EDIT: And I just read this at the link you sent: "You can't set context variables with the UpdateContext function because no screen has appeared yet. However, you can pass context variables in the Navigate function and create and fill a collection by using the Collect function." So I will try to Navigate OnStart and see if that works
Hi Shane I've been trying to use the Office365 Outlook connector and send and receive emails notification from my AAD guest users. It is possible to use this connector with external users?
Thanks for all the videos Shane it is making the PowerApps learning experience so much easier. Quick question what if I wanted to use a Dropdown List Control instead of a text box. At the moment my code looks a little like this - OnSelect = Office365.SendEmail(Email_Dropdown.Selected,"New Service Request Form", "SRF Number-" & DataCardValue111)
Thanks, that was brilliant I had used .Selected and .Value but not together. Are you looking at doing a video about using PowerApps and Sharepoint list in an Offline environment with local cache and then sync when the device regains internet connection? Cheers and thanks for your help and please keep doing these great videos.
Nice vid as always, quick question, is there a way to change the "From who" the email is send to the current user of the apps? You use the MOD Admin when you create your connection, will it always be from that email adress that the mail will come from?
@@ShanesCows sorry for another question but I don't find anything on the channel. is there a way to set a field as visible but protected in an update form??
Hi, Shane , your videos are incredible, you help so much!! One question , if I create the connection with office365 and publish the app, will other internal users also be able to click ‘send email’ and send from their own emails? How does the connection work, or do I have to do something different to enable this? Thank you
Great video Shane!! I have a question though - everything works except this: for the email address, I am using an email field on the screen that gets its data from a 'choice' list (lookup) that populates the email addresses - so obviously that's not a TextInput field. How do I pick that up with my 'Send email' button?
Hi Shane, that worked like a charm! I also tried "Text(Email.Value)" where 'Email' is the property name from the sharepoint list, which worked as well, but am going with your suggestion. Thanks, Shane - you are doing an awesome work. Many people are learning from you. Keep up the great work!
Hi Shane, is there a way to change the URL for the hyperlink in the body of the email to text. If so what would the code roughly look like for that....extreme newbie trying to teach herself how to build a Power App s be gentle. Thanks
Good video! I do have one question, when you set the subject, say you have it connected to an input box and the formula is “Subject” & Textinput1. Can it pull the data from the text input to create that as the subject or no?
Hi shane thos a great video and thank you it. Just want to ask also if powerapps can send a link or custom message to a messenger app like line & viber instead of email. Thanks
Hi Shane! What an amazing video! Very helpful I've got a question. What if i want to have a PREVIEW of how the email looks before I send it. For example, if the application could open an Outlook pop-up where I can see how it looks and send it from there. Thank you and keep up making this excellent content!
Hi Shane, How do I pick email ids entered/selected by users while using the form? I want to build a flow in which the user fills all approver emails, and the flow to trigger an email to the ids in the form.
Maybe this will help? ua-cam.com/video/49O284deOAI/v-deo.html Also there is a new version of this video that is much better about emails. ua-cam.com/video/vpYkOccwn4Y/v-deo.html
Hi Shane, thanks for all the great stuff! I am trying to set up an employee form that then sends a mail to a shared mailbox with the responses. Our organization has O365 but the mailboxes themselves are on-premise. This prevents me from adding O365 Outlook as a Connector. Any way around that?
Fantastic and simple . Thanks for the video. I actually need to send an Email through a generic Email id and not the one which i logging in with . Can i do that ? Or can I use ( Id A ) to develop in Power Apps and inside that (ID 2) to send email ?
Hi Shane! Great work! I just started out with powerapps to try to make the life easier in our organization. I want to be able to send an email to all the people in our crisis support team. I've got the data stored in an excel file. I'm using a button with the Launch function. Is there some way to send an email to all with one click so to speak?
I think the easiest solution would be to create an Exchange distribution list and then just send the email to the DL. Is that an option? If not I would have to think about how to send an email to a group from a list. I am sure it could be done, just not sure the mechanics. Could we hard code the list of who to send the email address to in the button?
Thanks for your suggestions. One of the perks with the app is that the members can edit their information and add a private email adress for when they are on vacation. So the exchange or the hard code solutions is unfortunately not an option. Would be great to find some solution.
I have learnt alot from watching you. What i need help with is being able to send information from a power app to Microsoft teams chat (not channel) is this possible and how would i go about it?? FYI i am not a programmer just dabbling and creating basic apps for my team in the field.
Hello Shane. Was trying to make a new line in the body. So one piece of info per line. Could you let me know how to do this with this method? Thanks man
thanks to ur videos. i learned a lot from it and was able to do a lot of stuff because of them. Not an IT person just a contracts professional trying to create a flow with power apps. i am struggling in configuring how i can auto-populate the entries in the power apps form i created to the flow-did put in “ask in powerapps” in the flow. tried several ways but they are not working. hope u can help.
Thank you Shane :) totally cool 😎. I have a Qs how can I add tick box n make sure the data is stored from share point? Cuz I’m first creating the list in share point then I’m designing in power app. But those buttons that I added in power apps don’t show while extracting the data in share point. I hope u could help plz
I have created a data collection form with the help of all your videos. But how do I now send my empty or partially completed form to someone to complete? Depending on the stage of each customer, they will be sent a different form, there will be 3. All feed back into the same list.
Shane, I have been watching your videos for a while now and they are extremely helpful. I am having an issue where my emails are not getting written to with the inputs. The title fields are there, but not the inputs. I have tried Office365Outlook.SendEmail() and Office365Outlook.SendEmailV2(), neither are working for the inputs. Not sure what I am doing wrong, any thoughts?
@@ShanesCows I have tried creating a new app completely and the SendEmailV2 is not working. The fields I want to write to an email are not writing, but the titles are there. Have you have idea why this would be happening?
HI! Great video. The only problem we're encountering is that for the other "users" they have to have "write" permissions on the XLS file. Up to here OK... but how do you prevent them from not opening the XLS files and changing all the data, etc?
@@ShanesCows Thought so!!! Thanks for your reply! We're trying to use a SQL-Database but trying to create a prototype without spending (right now) any many => I'll keep you updated
Hi Shane. First of all big thumbs up for the great video. I have a requirement were there is a SharePoint list with 3 to 4 link columns (which are links to other SharePoint documents) and on click of a button (anything equivalent) , all the documents referenced in the link columns need to be zipped and sent as an attachment to a set of people mentioned in the SharePoint list . the attachments with zipped link documents(not the link to document the document itself) Example: SharePoint List name : List1 ; SharePoint List Columns: Title, link1, link2, link3, Email address (not a people picker column similar to your textbox input) on click of a button an email needs to be sent to "Email address" with attachment (which is a zipped folder with link1 document(not the link to document the document itself) , link2 document , link3 document) thank you
Hi Shane, Thank you for these great videos. I would like to send emails to multiple recipients selected in the listbox, how do I do that? I am always getting the error of Invalid argument type, expecting a text value instead.
hey shane awesome videos. However, I think powerapps tutorial playlist videos are not sorted properly (videos' following parrt is not listed after each other.). Could you please check it if u have time. I would like to finish all the videos. Thanks for the awesome content.
Sorry I am slow. The playlist is only sorted by their release date. I doubt I will make it back to resort them. I do have a better sorting on training.powerapps911.com curated library if it helps.
I shane its so nice to learn from you!. I have query. Can we reply to an email with the help of powerapp (using the desktop outlook app) based on the email's message id. or Is there a way in powerapps so that we can send the tabular data along with all the color formatting as an email body. I have tried the rich text field but there i did not get the controls to format data like a table. please help ! And Lastly you teaching approach is awesome. Thanks a lot !
What if you wanted to format that email. You know make text bold, change text size, or change color? I have my app set up when you submit a form by clicking a button it send a no reply email to someone. It would be nice to have it look a little better.
You would need to create the HTML. Check out the updated version of this video that gets into that much deeper. ua-cam.com/video/vpYkOccwn4Y/v-deo.html
Hi Shane, Can I send multiple email to chkbox selected items (Collection Email field). I have gallery where my selected items store in collection with Name and Email address. Now I want to send email to everyone from my collection email address. I 'm failing to do that.
Hi Shane, First, this was a great video! You have helped me out a lot when it comes to figuring out the PowerApps process. My brain is just a little bit fried right now, so I apologize if this is a simple question. I have a Form that I created off a Sharepoint list that has a searchable Combobox1 that I use to fetch a user via Office365Users connection. Based on the selected user, I have a DataCardValue3 that will populate that user's manager. I created a formula based on OnSuccess that performs the following: Office365.SendEmail(DataCardValue3.Text,"Subject","Body",{Importance: Normal,IsHtml: true, Cc:"",Bcc:""});ResetForm(EditForm1);RequestHide() If I hardcode a value for the "To:", then the form successfully sends an email. If I use the "DataCardValue3.Text", the app returns the proper value (confirmed in hint plus a test label field). However the form fails to send the email, and says that the sendmail method has an invalid parameter for "To". Am I missing something simple here? TIA!
Hi Shane, I have a question, how can I get the data from a particular website to powerapps and send the same data through email, is there any options in powerapps to do that?
@@ShanesCows What about if I'm using the office365outlook connector as it's a business account? I'm unable to use this item but I am able to type in: Office365Outlook.SendEmailV2([email address],"Subject line,"Hello&", Please click on the link to approve: web.powerapps.com/apps/61c51dae-7f20-4e05-a91c-7fd8b516dce3?ID="&CurrentItem.ID) however when I click the link in the email, it doesn't take me to the display item page for that particular record. It takes me to the main gallery with the list of all items. do you know what I need to change for it to take me to the display page of that particular record?
Hi Shane, great video! One question. How do you send an email to the person who created the form? I have a form with an 'approve' and 'reject' button, and once somebody clicks one of the buttons, the creator should receive an email. I tried something like: 'ThisItem.Author.Email' but that doesn't seem to work. Any suggestions?
Hey Shane, can you tell me how to get the name of current logged in user in PowerApps? I am customizing a form in a SharePoint list and I need the name of current logged in user in a field of that list.
Is it possible to have some of the text in the email display with a different colored font? An example would be 'Name: Bob', where the person enters their name (Bob) and Bob displays in red font and Name: is black. I have tried entering code on the Email Button and nothing seems to work.
Shane, I attempted to add this exact email functionality to the EditForm in my app so that I could send the email directly from EditForm. However, it isn't sending the data from the ThisItem references I added. Office365Outlook.SendEmail(TextInputJobCoachEmailEditScreen, "New client assignment","Here is your new client's contact information. Please contact client within 24 hours to book an appointment." & Char(10) & Char(10) & "Name: " & ThisItem.FirstName & " " & ThisItem.LastName & Char(10) & "First Nation: " & ThisItem.FirstNation & Char(10) & "Email: " & ThisItem.ClientEmailAddress & Char(10) & "Phone1: " & ThisItem.Phone1 & Char(10) & "Phone2: " & ThisItem.Phone2 & Char(10) & "Assigned Job Coach: " & ThisItem.AssignedJobCoach & Char(10) & "Career Centre: " & ThisItem.CareerCentre & Char(10) & Char(10) & "Notes: " & ThisItem.Notes)
Love ur videos and the way u explain many thanks 🎉. Need ur help I have created power apps for safety compliance and don’t know how to add camera to take photos of non compliance and share it to the contractor responsible person via email through PowerApps, appreciate if you could guide me in this matter
Hey Shane! Keep goin in this video, I want to be able to select some of my entries on a gallery (more than 1 or 2) and send their information via e-mail, is that possible?
Hey Shane, I am trying to send a hard coded email to myself using the Office365.SendEmail() to my email account connected to 365. Obviously the code is written in the OnSelect of the button. I am not receiving any emails, but if I put in my gmail email, I get the email. Any advise? I already Whitelisted powerapps, flow and my onmicrosoft.com domains in exchange.
One further question...I was able to get my date picker selections to show up in the body of my email, however, I can't get any of my dropdown selections or text input selections to show up. Any idea why that might be?
Hi Shane! This is very helpful,thank you very much!! but what if Instead of manually typing the person's name I want to add a combobox so that my users are searchable. I keep getting errors when i try to use that option instead, any ideas as why?
Is it possible to send an e-mail from only one specific mailbox? Independent of which user is accessing the app. I want to make a "notification" mailbox, that the user can relate to the app.
Just found this video today at the beginning of my powerapps journey. You explain this stuff so well that it still holds up over 5 years later. Cheers, Shane :)
🤩 Thanks. There is a newer version, though it is 3 years old now, if you wanted to see the topic covered better. :) ua-cam.com/video/vpYkOccwn4Y/v-deo.html If not enjoy the 400ish videos I have and enjoy the journey, learn Power Apps is fun.
Thanks to you I have created the perfect fill-out form. As a person with zero coding experience, I can say you are great explaining everything so people like me can understand.
Awe. This makes me happy to read. 🤩 Congrats to you for getting it all working. 🤩
Shane, I am a subscriber after you said "get off my lawn! "
Lol
Just started watching your channel. Thanks for all the videos.
Have to have a sense of humor. 😂
Thanks Shane! This was an excellent presentation -- I wish all coding topics were explained with this level of clarity.
Thanks David. 😎
Hi Shane, I've been using your videos and they are a great introduction to Power Apps. I am trying to send a link using the formula you provided. That formula is no longer valid, do you know what is the new way to formulate the "Link" part? ThisItem.'{Link}' doesn't work with single or double quotes. What am I doing wrong?
Any luck with that? I have the same issue.
Already subscribed to your channel a few weeks back but just found this video. I had problem with email (still a newbie in PowerApps) but after watching your video, my problems were solved. Thanks very much!!!
Awesome, there is an updated version of this video if you still need help with email ua-cam.com/video/vpYkOccwn4Y/v-deo.html
Great video Shane! It's giving us the full range of possibilities regarding PowerApps and combining all your videos gives us an edge!
HI Shane, I really appreciate your PowerApps tutorials. Your videos helped me a lot to get more familiar with this Microsoft tool.
Happy to help
Nice overview of how to send an email Shane. Thanks. Now to figure out how to make that look real pretty. :)
Try the v2 version so you can use html. 😀
Shane you are the best!!! Your PowerApp Videos have helped me so much. You really know your stuff and you present it so well! Keep up the great work!!
Good stuff, very well explained Shane!!
There is a new version if it helps :) ua-cam.com/video/vpYkOccwn4Y/v-deo.html
So much information and easy to get. Great work Shane
Thanks
Thanks for that video man!! Appreciated!! . I have a question in that same botton can you ( send email), save&close the data that you put on your form list and change an status column to Pending?
Sure. If you know the function for each thing you just separate each function with a ; Sendemail(...);ResetForm(...);Navigate(...)
Hi Shane,
Everything worked perfectly, though i need help in adding all of the fields/columns included on the email body. Is that possible?
Yes. Just have to create the giant string. I think there is a good chance I am going to redo this video soon to cover more of this stuff.
Hi I have been looking at a lot of your PowerApps videos and was wondering can you create an email with all the selected Items from a listbox contained in the body of the email if so do you have a video on it
The Concat function is the answer. I think I show it in this video ua-cam.com/video/AnERfGIE8gw/v-deo.html
Great walk through Shane breaking the processes down where they're easier to follow. Do you have a walk through of how to, using PowerApps, connect a name field to Office 365 Users and then send an email?
Try this video ua-cam.com/video/FpXrF5NDZbI/v-deo.html
Hi Shane, I really enjoyed the video, i've watched many so far. I'm using the quicktasks app template and i can't seem to figure out how to add a second email address to the app, do you happen to know how one might do that?
Not off the top of my head. I don’t recommend using the templates and customizing them. Instead I use them for inspiration and build my own app.
I really appreciated you explanation. Thank you so much.
You're very welcome!
Thanks a lot! It was very helpful!! Where in the sequence you add Reset form?? I am thinking about a suggestions form, and must be reset after someone sends the email
OnSuccess property of the form. Also there is an updated version of this video ua-cam.com/video/vpYkOccwn4Y/v-deo.html
@@ShanesCows thank you 🙂🙂🙂🙂🙂
Lots of basic things have changed. Can you make one video on some of the key differences to help us navigate through these old videos. Their great, but I don't even know how to add a data card to the form.
I remade this whole video for that very reason. ua-cam.com/video/vpYkOccwn4Y/v-deo.html Hopefully that gets you everything you ever wanted to know.
Hi Shane, which is better... use Outlook connector/SendEmail or use Flow (I mean Power Automate... ugly name) to send the email? I think connecting with Flow is better since you can see the run history??
I prefer not to use Flow unless I have to. 🤷♂️
Hi Shane, great video but I have just tried this. And I get this message This formula uses scope, which is not currently supported for evaluation? what can I do to correct this?
That isn’t an error just a warning the preview tool cans display the value.
Hey Shane! So appreciate what you do!!! I’m trying to have the body of the email include what a user has selected in a drop down input. Is that possible? Do you have a video that covers that?
Office365outlook.sendemailv2(“shane@powerapps911.com”, “subject”, “Dropdown said: “ & Dropdown1.Selected.Value) that should do it
Thanks Shane! How could we submit the form to save values in SP and send an email using the same button?
Hi Shane, Nice video
I have a question on email routing, is there a way to pass dynamically the to email address in power apps forms after clicking on submit button. It should dynamically take the email address from the Azure SQL Table.
I have seen that we can achieve by using Flow, but would like to use the Powerapps itself, can you please suggest any idea ?
Thanks.
Formname.lastsubmit.emailaddresscolumn has your answer.
I really learn from your video. It's well delivered. Keep up the good work!
Thanks
Hey Shane, tnx for this video.
you helped me a lot!
Glad to hear it!
Shane due to your videos, I actually feel like i'm learning!
Let's say I had a checkbox on the screen before the details screen. If the checkbox was checked on the initial screen, I also want the checkbox on the details screen to get checked.
how do I complete this task?
Set the checkbox on the first screen to set a variable when it gets checked. Have the second screen checkbox use that variable as the default value. :)
@@ShanesCows hi Shane, would that be done by
Set(varCheckbox, true) for when checked
Then calling the varCheckbox in the 2nd checkbox for default?
@@shadowmage19 Yes, that should be the ticket.
Hey Shane great videos. I am also trying and learning powerapps and your videos are helping me a lot. Could you please help me with some use cases in real world for the powerapps. Where we can take a real advantage of powerapps? Thanks
Time sheets, purchase orders, expense reports, approvals are all popular first apps.
Hey Shane Thanks for the video! a question for you, can we send the email to a group of users and not just one ? How can we create this group ?
The first answer is I would make the group as a distribution list in Exchange. Then just send the email to the Distribution List. You could also change the to portion to be shane@example.com;bob@example.com that would work to send to multiple people.
Thanks a lot!
Hi Shane, can you please do a video explaining office365sendemailwithoptions in particular how to get the option buttons to action.
I covered it some in this email ua-cam.com/video/TXYmk4d7wi8/v-deo.html
Shane, first of all, thank you so much for all your vídeos. They have helped me a lot on my job.
I just have one question. I have a data table which I filter depending on some parameters, is it possible to send this data table in the email body? I need to click on the email button and send the message with the data table in the body or as attachment.
Thanks
Yes. Concat is the key. I think I show it here. ua-cam.com/video/AnERfGIE8gw/v-deo.html
@@ShanesCowsThank you so much, Shane! That's exaclty what I needed. You're simply the best!
Mate your amazing! But before that here is my intro! hehehehe. Hands down, continue doing this! Im going to follow you mate!
Thanks. Made my night. 🤩
Hello and thank you for all your tutorials. I'm looking for ways to schedule or delay sending messages ?
Flow has the ability to do that. So maybe use flow to send the emails and use the delay action
Thank you, I found how to send my emails in deferred but I can't put attachments.@@ShanesCows
Hey, thanks for your video. I learned a lot from it. Can u please make app to connect power apps with custom APIs or IBM OpenPages?
Did you see this video? Might be a solid jumping off place. ua-cam.com/video/gLhrHxvKBdI/v-deo.html
Great video Shane. Do you know if there is a way to hyperlink a word in the email body rather than just inserting the link?
I believe if you craft it in HTML it should flow through to the email.
Thanks. I'll give that a try.
Great video and exactly what I needed. I have been working on a project to migrate our current intranet (PHP) into our SharePoint and O365 tenant and I am finding Power Apps VERY useful. And I just subbed to your channel. Good stuff
Awesome! Let me know if there is other ideas or topics you would like to see me cover? I am always looking for inspiration.
I am soon going to be tackling using power apps with flows. I wouldn't mind seeing that, unless you have already done one. Also, I watched the one with variables and I have a screen with one form and would like to set the variable value at the time of the app starting and I have yet to figure that out
So usually to set a variable at the start you can go to the first Screen and set the OnStart property. That is the closest thing to initializing you are going to get. I actually show it in an upcoming video. Here is the doc. docs.microsoft.com/en-us/powerapps/controls/control-screen
Great, thanks for the info. I will pay around with it as when I go to set the variable in the screen, it tells me that Context variables are not allowed. Even though I have one screen and one form. Instead of using (UpdateContext) I will just try to use Set on the variable and see what happens.
EDIT: And I just read this at the link you sent: "You can't set context variables with the UpdateContext function because no screen has appeared yet. However, you can pass context variables in the Navigate function and create and fill a collection by using the Collect function." So I will try to Navigate OnStart and see if that works
Hi Shane I've been trying to use the Office365 Outlook connector and send and receive emails notification from my AAD guest users. It is possible to use this connector with external users?
I don’t think so 😑
Thanks for all the videos Shane it is making the PowerApps learning experience so much easier. Quick question what if I wanted to use a Dropdown List Control instead of a text box. At the moment my code looks a little like this - OnSelect = Office365.SendEmail(Email_Dropdown.Selected,"New Service Request Form", "SRF Number-" & DataCardValue111)
Paul try:
Email_Dropdown.Selected.Value
I think the .Value was all you were missing.
Thanks, that was brilliant I had used .Selected and .Value but not together.
Are you looking at doing a video about using PowerApps and Sharepoint list in an Offline environment with local cache and then sync when the device regains internet connection?
Cheers and thanks for your help and please keep doing these great videos.
Nice vid as always, quick question, is there a way to change the "From who" the email is send to the current user of the apps? You use the MOD Admin when you create your connection, will it always be from that email adress that the mail will come from?
The email will be from the user who clicks the button by default.
HI Shane, first of all, thank you for this!! But what if I want to add the Title of the list for example on my subject line. How would you add that?
Title of the list would have to be hard coded. No dynamic way to get it.
Hi Shane, thanks for your useful videos! Just a question: How can I do to send email to more than one address?
Separate the text by ;
@@ShanesCows Thanks Shane!
Glad to help. 😀
@@ShanesCows sorry for another question but I don't find anything on the channel. is there a way to set a field as visible but protected in an update form??
Hi, Shane , your videos are incredible, you help so much!! One question , if I create the connection with office365 and publish the app, will other internal users also be able to click ‘send email’ and send from their own emails? How does the connection work, or do I have to do something different to enable this? Thank you
Yes, it will use their OUtLook to send the email. 😀 Here is an updated version of this topic to help you. ua-cam.com/video/vpYkOccwn4Y/v-deo.html
Great video Shane!! I have a question though - everything works except this: for the email address, I am using an email field on the screen that gets its data from a 'choice' list (lookup) that populates the email addresses - so obviously that's not a TextInput field. How do I pick that up with my 'Send email' button?
Hi Arun - Are you using a Dropdown? Then you do Dropdown1.Selected.Value
Hi Shane, that worked like a charm! I also tried "Text(Email.Value)" where 'Email' is the property name from the sharepoint list, which worked as well, but am going with your suggestion. Thanks, Shane - you are doing an awesome work. Many people are learning from you. Keep up the great work!
Hi Shane, is there a way to change the URL for the hyperlink in the body of the email to text. If so what would the code roughly look like for that....extreme newbie trying to teach herself how to build a Power App s be gentle. Thanks
I am not sure what you mean Sara. Sorry
Thank You. It worked and as a result I finished my task. It was really cool.
Glad to help. 😀
Hi Shane how are you? One question I have . Can we execute an API from powerapps?
Two options. 1 create a custom connector. 2 use flow. 😀
Hi Shane thanks for the video. I would like to ask you if there’s a way to attach a table that I have in the app
What is in the table? The answer is yes. Look at ForAll for help.
Good video! I do have one question, when you set the subject, say you have it connected to an input box and the formula is “Subject” & Textinput1. Can it pull the data from the text input to create that as the subject or no?
Yes, correct
Hi Shane, great video! Is there some way to send an email like cc: or bcc: instead of To:?
Yes. After the body type , { and you will see there are options for both cc and bcc.
Hi, is it possible to change colour of the button when it's pressed to let know users that they already have sent e-mail? Thanks Shane.
You could. You would need to set the Fill of the button to be a variable and then change the variable when they send the email
Hi shane thos a great video and thank you it. Just want to ask also if powerapps can send a link or custom message to a messenger app like line & viber instead of email. Thanks
If they had an API then yes. Unfortunately I haven’t done it before.
Hi Shane! What an amazing video! Very helpful
I've got a question. What if i want to have a PREVIEW of how the email looks before I send it. For example, if the application could open an Outlook pop-up where I can see how it looks and send it from there.
Thank you and keep up making this excellent content!
Hi Shane, How do I pick email ids entered/selected by users while using the form? I want to build a flow in which the user fills all approver emails, and the flow to trigger an email to the ids in the form.
Maybe this will help? ua-cam.com/video/49O284deOAI/v-deo.html Also there is a new version of this video that is much better about emails. ua-cam.com/video/vpYkOccwn4Y/v-deo.html
Does the user need to have outlook installed on the cell phone for the email to be sent? or does he just need to have the office365 account? Thanks!
Hi Shane. Thank you as always for your vids. I've just added this button (successfully) but the link opens the wrong item. Any ideas??
Put a label on the screen to show the url to see if you can figure out why it is wrong.
Hi Shane, thanks for all the great stuff! I am trying to set up an employee form that then sends a mail to a shared mailbox with the responses. Our organization has O365 but the mailboxes themselves are on-premise. This prevents me from adding O365 Outlook as a Connector. Any way around that?
You can use the Outlook connector to send an email TO: any email address. So this should work?
Fantastic and simple . Thanks for the video.
I actually need to send an Email through a generic Email id and not the one which i logging in with .
Can i do that ?
Or can I use ( Id A ) to develop in Power Apps and inside that (ID 2) to send email ?
You can but you have to use the smtp connector to do so.
Hi Shane! Great work!
I just started out with powerapps to try to make the life easier in our organization.
I want to be able to send an email to all the people in our crisis support team. I've got the data stored in an excel file. I'm using a button with the Launch function.
Is there some way to send an email to all with one click so to speak?
I think the easiest solution would be to create an Exchange distribution list and then just send the email to the DL. Is that an option? If not I would have to think about how to send an email to a group from a list. I am sure it could be done, just not sure the mechanics. Could we hard code the list of who to send the email address to in the button?
Thanks for your suggestions.
One of the perks with the app is that the members can edit their information and add a private email adress for when they are on vacation.
So the exchange or the hard code solutions is unfortunately not an option.
Would be great to find some solution.
Perfect, thank you so much! It's so simple when you explain! 😍
You're so welcome!
I have learnt alot from watching you. What i need help with is being able to send information from a power app to Microsoft teams chat (not channel) is this possible and how would i go about it?? FYI i am not a programmer just dabbling and creating basic apps for my team in the field.
Not sure Ken. I haven’t tried yet. Have you looked to see if flow has any actions to help?
Hello Shane. Was trying to make a new line in the body. So one piece of info per line. Could you let me know how to do this with this method? Thanks man
Use the Char function. Char(10) will create a new line. I demo that with a bunch of other stuff in this video. ua-cam.com/video/DF4KX1oSrVI/v-deo.html
Thank you Shane. Good help man!
thanks to ur videos. i learned a lot from it and was able to do a lot of stuff because of them. Not an IT person just a contracts professional trying to create a flow with power apps. i am struggling in configuring how i can auto-populate the entries in the power apps form i created to the flow-did put in “ask in powerapps” in the flow. tried several ways but they are not working. hope u can help.
ua-cam.com/video/2rfAQe1kK8M/v-deo.html in that video I offer some more ideas for you
Thank you Shane :) totally cool 😎. I have a Qs how can I add tick box n make sure the data is stored from share point? Cuz I’m first creating the list in share point then I’m designing in power app. But those buttons that I added in power apps don’t show while extracting the data in share point. I hope u could help plz
Create your SharePoint list then choose the option for creating an app from your data.
I have created a data collection form with the help of all your videos. But how do I now send my empty or partially completed form to someone to complete? Depending on the stage of each customer, they will be sent a different form, there will be 3. All feed back into the same list.
YOu have to save the partial info to a data source and then query it back when your other editor wants to connect.
Shane, I have been watching your videos for a while now and they are extremely helpful. I am having an issue where my emails are not getting written to with the inputs. The title fields are there, but not the inputs. I have tried Office365Outlook.SendEmail() and Office365Outlook.SendEmailV2(), neither are working for the inputs. Not sure what I am doing wrong, any thoughts?
Post a new comment with your full formula. V2 should be correct
@@ShanesCows my formula is as follows:
Office365Outlook.SendEmailV2("adeluca@","Station Update", "Station Number: " & DataCardValue1.Text & "
" & "Manufacturer: " & DataCardValue2.Text & "
" & "Model: " & DataCardValue3.Text & "
" & "Size: " & DataCardValue4.Text & "
" & "Orifice Size: " & DataCardValue9.Text & "
" & "Cg Value: " & DataCardValue5.Text & "
" & "C1(Xt) Value: " & DataCardValue6.Text & "
" & "Cg Wide Open Value: " & DataCardValue7.Text & "
" & "Set Pressure: " & DataCardValue8.Text, {Importance:"Normal"})
@@ShanesCows I have tried creating a new app completely and the SendEmailV2 is not working. The fields I want to write to an email are not writing, but the titles are there. Have you have idea why this would be happening?
Hi, Shane. Is it possible to change the sender of the email via powerapps?
Not using this connector. Making a video on how to it with the SMTP connector is on my list for one of these days.
@@ShanesCows sweet! Looking forward to it. Your channel is a major help btw
So you can send an email from PowerApps and also have PowerApps connect to Flow then send the email from/via Flow?
Yes
These videos are great! I would like to know how to get the email to be sent from the user. Could you help with that?
The email automatically comes from the person who pressed the button. Nothing to configure.
Great video, thanks for your effort. You definitely save a lot of our times.
You are welcome!
Have you sent an email to more than one recipient using Powerapps? :) Really appreciate your help!!
HI! Great video. The only problem we're encountering is that for the other "users" they have to have "write" permissions on the XLS file. Up to here OK... but how do you prevent them from not opening the XLS files and changing all the data, etc?
You cannot. That is a big downside of Excel and SharePoint as data sources. Easy for the user to go around the app.
@@ShanesCows Thought so!!! Thanks for your reply! We're trying to use a SQL-Database but trying to create a prototype without spending (right now) any many => I'll keep you updated
Hi Shane. First of all big thumbs up for the great video. I have a requirement were there is a SharePoint list with 3 to 4 link columns (which are links to other SharePoint documents) and on click of a button (anything equivalent) , all the documents referenced in the link columns need to be zipped and sent as an attachment to a set of people mentioned in the SharePoint list .
the attachments with zipped link documents(not the link to document the document itself)
Example:
SharePoint List name : List1 ;
SharePoint List Columns: Title, link1, link2, link3, Email address (not a people picker column similar to your textbox input)
on click of a button an email needs to be sent to "Email address" with attachment (which is a zipped folder with link1 document(not the link to document the document itself) , link2 document , link3 document)
thank you
I would look at Flow. Not sure PowerApps can’t do it alone though.
This was exactly what I needed! Thank you!
That is awesome! Thanks for sharing.
Sir Shane, how can you send an email to yourself using Power App?
Hi Shane! I’ve followed the video, but it won’t let me type in Preview mode. Any help you can provide?
Not sure. Make sure you are using a supported browser?
Hi Shane,
Thank you for these great videos. I would like to send emails to multiple recipients selected in the listbox, how do I do that? I am always getting the error of Invalid argument type, expecting a text value instead.
Use the Concat function ua-cam.com/video/AnERfGIE8gw/v-deo.html
@@ShanesCows thank you Shane...☺️☺️
hey shane awesome videos. However, I think powerapps tutorial playlist videos are not sorted properly (videos' following parrt is not listed after each other.). Could you please check it if u have time. I would like to finish all the videos. Thanks for the awesome content.
Sorry I am slow. The playlist is only sorted by their release date. I doubt I will make it back to resort them. I do have a better sorting on training.powerapps911.com curated library if it helps.
I shane its so nice to learn from you!.
I have query. Can we reply to an email with the help of powerapp (using the desktop outlook app) based on the email's message id.
or
Is there a way in powerapps so that we can send the tabular data along with all the color formatting as an email body.
I have tried the rich text field but there i did not get the controls to format data like a table.
please help !
And Lastly you teaching approach is awesome.
Thanks a lot !
You can sent hte email as HTML and this gives you all of the controls I think you want.
What if you wanted to format that email. You know make text bold, change text size, or change color? I have my app set up when you submit a form by clicking a button it send a no reply email to someone. It would be nice to have it look a little better.
You would need to create the HTML. Check out the updated version of this video that gets into that much deeper. ua-cam.com/video/vpYkOccwn4Y/v-deo.html
Thanks Shane. Is there a way to email all emails in a Collection?
Great question. That is tomorrow's video actually. Your timing is perfect. :) Stay tuned.
Hi Shane, Can I send multiple email to chkbox selected items (Collection Email field). I have gallery where my selected items store in collection with Name and Email address. Now I want to send email to everyone from my collection email address. I 'm failing to do that.
YOu need the Concat function. I think I show it in this video ua-cam.com/video/AnERfGIE8gw/v-deo.html
Hi Shane,
First, this was a great video! You have helped me out a lot when it comes to figuring out the PowerApps process.
My brain is just a little bit fried right now, so I apologize if this is a simple question. I have a Form that I created off a Sharepoint list that has a searchable Combobox1 that I use to fetch a user via Office365Users connection. Based on the selected user, I have a DataCardValue3 that will populate that user's manager.
I created a formula based on OnSuccess that performs the following: Office365.SendEmail(DataCardValue3.Text,"Subject","Body",{Importance: Normal,IsHtml: true, Cc:"",Bcc:""});ResetForm(EditForm1);RequestHide()
If I hardcode a value for the "To:", then the form successfully sends an email. If I use the "DataCardValue3.Text", the app returns the proper value (confirmed in hint plus a test label field). However the form fails to send the email, and says that the sendmail method has an invalid parameter for "To".
Am I missing something simple here? TIA!
Weird that seems correct. 😐 you see only a valid email for the text of that control?
Hello Shane, do you have a vid that shows how to send an email in an HTML format? thanks
I don’t. That is a good idea I should cover. 😀
Hi Shane, I have a question, how can I get the data from a particular website to powerapps and send the same data through email, is there any options in powerapps to do that?
I think that might be better done via Flow. I haven't done it but with the HTTP actions you can do a Get so should be possible.
@@ShanesCows thank you very much Shane!!!!!!
Thanks for the great info! I'm not seeing ThisItem as an option when I start typing. Could this be a license-specific function?
Nope. ThisItem is only available in a Form or a Gallery though. That is probably the difference.
@@ShanesCows What about if I'm using the office365outlook connector as it's a business account? I'm unable to use this item but I am able to type in:
Office365Outlook.SendEmailV2([email address],"Subject line,"Hello&", Please click on the link to approve: web.powerapps.com/apps/61c51dae-7f20-4e05-a91c-7fd8b516dce3?ID="&CurrentItem.ID)
however when I click the link in the email, it doesn't take me to the display item page for that particular record. It takes me to the main gallery with the list of all items. do you know what I need to change for it to take me to the display page of that particular record?
Hi Shane, great video! One question. How do you send an email to the person who created the form? I have a form with an 'approve' and 'reject' button, and once somebody clicks one of the buttons, the creator should receive an email. I tried something like: 'ThisItem.Author.Email' but that doesn't seem to work. Any suggestions?
User().Email should do the trick. More details in this video. ua-cam.com/video/FpXrF5NDZbI/v-deo.html
Hey Shane, can you tell me how to get the name of current logged in user in PowerApps? I am customizing a form in a SharePoint list and I need the name of current logged in user in a field of that list.
This video has what you need. PowerApps User Function and intro to Office 365 User connector ua-cam.com/video/FpXrF5NDZbI/v-deo.html
Is it possible to have some of the text in the email display with a different colored font? An example would be 'Name: Bob', where the person enters their name (Bob) and Bob displays in red font and Name: is black. I have tried entering code on the Email Button and nothing seems to work.
Yes. Use HTML in the body of the email.
This is a Great Video!! Can you please explain how to embed video in an email. I tried using tag but that is not working.
I have never done it. Sorry.
Shane, I attempted to add this exact email functionality to the EditForm in my app so that I could send the email directly from EditForm. However, it isn't sending the data from the ThisItem references I added.
Office365Outlook.SendEmail(TextInputJobCoachEmailEditScreen, "New client assignment","Here is your new client's contact information. Please contact client within 24 hours to book an appointment." & Char(10) & Char(10) & "Name: " & ThisItem.FirstName & " " & ThisItem.LastName & Char(10) & "First Nation: " & ThisItem.FirstNation & Char(10) & "Email: " & ThisItem.ClientEmailAddress & Char(10) & "Phone1: " & ThisItem.Phone1 & Char(10) & "Phone2: " & ThisItem.Phone2 & Char(10) & "Assigned Job Coach: " & ThisItem.AssignedJobCoach & Char(10) & "Career Centre: " & ThisItem.CareerCentre & Char(10) & Char(10) & "Notes: " & ThisItem.Notes)
What record is it using?
awesome work buddy...keep rocking...
😎
Hi Shane, Great Video! I have followed the same but in Tab mode, In my case, the "link(URL)" in the received text is missing!!
Put URL in a label. Does it show what you expect?
Keep up the good work Mr. young !
Thanks. Just put out a new video today trying to keep up. :) Let me know what you think.
Love ur videos and the way u explain many thanks 🎉. Need ur help I have created power apps for safety compliance and don’t know how to add camera to take photos of non compliance and share it to the contractor responsible person via email through PowerApps, appreciate if you could guide me in this matter
Is it possible to send the e-mail and also send a mobile push notifications? Im a free user, I noticed in premium features you can notify...
I think it is only a premium feature. Sorry. Never really messed with it.
Shane Young got it....maybe some flows management with notification? Hope in the future you discover something.😆
Sending a Flow notification is free.
Hey Shane! Keep goin in this video, I want to be able to select some of my entries on a gallery (more than 1 or 2) and send their information via e-mail, is that possible?
PowerApps Email Multiple Attachments ua-cam.com/video/V3feURQfY3M/v-deo.html This video show multiple attachments.
Hey Shane, I am trying to send a hard coded email to myself using the Office365.SendEmail() to my email account connected to 365. Obviously the code is written in the OnSelect of the button. I am not receiving any emails, but if I put in my gmail email, I get the email. Any advise? I already Whitelisted powerapps, flow and my onmicrosoft.com domains in exchange.
Never had a problem getting emails to myself. 😑 The come as low priority by default. Any chance company spam filter is blocking them?
One further question...I was able to get my date picker selections to show up in the body of my email, however, I can't get any of my dropdown selections or text input selections to show up. Any idea why that might be?
Dropdown.selected.value or Textinput.text is what you need.
Hi Shane! This is very helpful,thank you very much!! but what if Instead of manually typing the person's name I want to add a combobox so that my users are searchable. I keep getting errors when i try to use that option instead, any ideas as why?
Combobox.Selected.Mail should work
@@ShanesCows Thank you so much!!
Is it possible to send an e-mail from only one specific mailbox? Independent of which user is accessing the app. I want to make a "notification" mailbox, that the user can relate to the app.
Possible via the SMTP Connector. I have this on my list to make a video about but don't have anything I can easily share yet. Boo me.