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. :) th-cam.com/video/vpYkOccwn4Y/w-d-xo.html If not enjoy the 400ish videos I have and enjoy the journey, learn Power Apps is fun.
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 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?
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
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 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
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
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??
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 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? th-cam.com/video/49O284deOAI/w-d-xo.html Also there is a new version of this video that is much better about emails. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
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. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
I had problems being allowed to use the Office365 outlook. Just using the normal outlook.com works just aswell, you just have to replace the "," in the code to ";".
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. :)
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.
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.
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, 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?
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.
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?
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
For the data connection, I saw you used the admin account and it sent the emails from that account. Is there a way to set the data connection to use the credentials of the user logged in so the email is sent from their account?
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. th-cam.com/video/DF4KX1oSrVI/w-d-xo.html
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. 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
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.
The key is the body of the email is HTML. So you need to write the html for multiple rows. is a line break. THere is an updated version of this video available here th-cam.com/video/vpYkOccwn4Y/w-d-xo.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!
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?
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
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?
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?
@@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??
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)
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
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.
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, 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.
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.
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?
You get the link and send them the link without much effort. If you need the file then try to store the file in the app in a variable and see if that will work. Never tried.
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.
Hi Shane. There is a way for the mail to be sent to the user who is logged into the PowerApps without writing it to the text entry I have an idea and I imagine that instead of Office365.SendEmail (TextInput1; "Our first PowerApps Email"; "Our Email Message Here.") * '' TexInput '*' It would be replaced, but I don't know how please help ! Thank you !
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
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.
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.
Thank you for the helpful videos, Shane. Just getting started. Our IT department locks down most everything, but so far PowerApps has remained open and could help our workgroup a lot. Everything in the tutorial worked fine up until around the 8:50 mark when I typed "ThisItem.L..." and it did not resolve to '{Link}'. I only get the Intellisense red, squiggly line and a mouseover message of "Invalid name." Web search showed others trying to use Launch with a variety of parameters, none that work for my site. Not sure if the missing "Link" is something I need to enable on my end or what. Any ideas?
No, mine is blank, not like yours (where it's showing '{Link}'. If I was working in some other MS dev environ, I'd suspect a missing Reference or equivalent. Not too sure here. App Info shows my PowerApps release as 2.0.795, for whatever that's worth. If nothing pops to mind, please don't burn any more time. This may be unique to my site. The rest of your videos (and the others) have been golden. I can hardcode the link and send it that way; I just need to find a way to direct it to the displayed/selected name. Thank you again for posting these vids, they really, really help a lot!
Lucky for you it drives me crazy not to fix this stuff. :) I am pretty sure the issue is your button is not inside the form. Look at my screenshot from the time stamp you shared. My button is on a card in the form. You have to be within the form to use ThisItem. Does that make sense?
I matched up my screen with yours before I sent off my query :) and just to make sure, now, I pulled/re-added the button and textbox with the same results. I'll try this from home today, see if it behaves differently, and update you. Everything else has worked wonderfully--not always a normal condition. This may be an issue at my site and how they've configured O365/PowerApps.
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.
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?
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
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?
Hi Shane, thank you for the video! One question! May I know how do I send an email with all the contents from the edited form? For example in your case, at 8:45 - instead of the link, I want to send the "Title, Color, Animal, Created, Created By, Modified and Modified By" together with the email message. I am using One Drive Excel if you need to know. Thanks in advance!! :)
Hi Shane! Thanks for the quick reply! However I've tried but the "ThisItem." function does not work for me. The error message shown: "Name isn't valid. This identifier isn't recognized. This error appears most commonly when a formula refers to something that no longer exists (for example, a control that you've deleted).
Hi shane, Ive watched alot of your videos but this one has me a little confused, can you advise where im going wrong, Office365Outlook.SendEmailV2("Email.Address@gmail.com","Please reorder Toner","Can you please order more of the following: " & Tonercode_Dropdown.Selected.Value & Quantity_Input.Text) I've been playing around but cant seem to get both information on the email and if they are they are not spaced out to make it easier to read. Would appreciate the help. Thanks
![Power Apps Send Email With A Button [Power Platform Series - Ep. 7]](/img/n.gif)
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. :) th-cam.com/video/vpYkOccwn4Y/w-d-xo.html If not enjoy the 400ish videos I have and enjoy the journey, learn Power Apps is fun.
Thanks Shane! This was an excellent presentation -- I wish all coding topics were explained with this level of clarity.
Thanks David. 😎
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 th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
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. 😂
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
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!!
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.
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. 😀
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
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. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html Hopefully that gets you everything you ever wanted to know.
Thanks Shane! How could we submit the form to save values in SP and send an email using the same button?
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 th-cam.com/video/TXYmk4d7wi8/w-d-xo.html
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 th-cam.com/video/AnERfGIE8gw/w-d-xo.html
So much information and easy to get. Great work Shane
Thanks
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 th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
@@ShanesCows thank you 🙂🙂🙂🙂🙂
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. 🤷♂️
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(...)
Good stuff, very well explained Shane!!
There is a new version if it helps :) th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
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? th-cam.com/video/49O284deOAI/w-d-xo.html Also there is a new version of this video that is much better about emails. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
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. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
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
I had problems being allowed to use the Office365 outlook. Just using the normal outlook.com works just aswell, you just have to replace the "," in the code to ";".
Cool
Sir Shane, how can you send an email to yourself using Power App?
So you can send an email from PowerApps and also have PowerApps connect to Flow then send the email from/via Flow?
Yes
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.
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
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.
th-cam.com/video/2rfAQe1kK8M/w-d-xo.html in that video I offer some more ideas for you
I really learn from your video. It's well delivered. Keep up the good work!
Thanks
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.
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. 😀
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 th-cam.com/video/FpXrF5NDZbI/w-d-xo.html
Thank You. It worked and as a result I finished my task. It was really cool.
Glad to help. 😀
Hey Shane, tnx for this video.
you helped me a lot!
Glad to hear it!
Dear Shane, can you please post all email formulas?
At training.powerapps911.com the curated library option has downloads and scripts
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 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.
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.
Can we use same the connector for exchange on-premises? Any way to send an email to exchange?
I don't think so. You may be able to use the SMTP connector though to hit Exchange.
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 😑
I really appreciated you explanation. Thank you so much.
You're very welcome!
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
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
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. th-cam.com/video/gLhrHxvKBdI/w-d-xo.html
For the data connection, I saw you used the admin account and it sent the emails from that account. Is there a way to set the data connection to use the credentials of the user logged in so the email is sent from their account?
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. th-cam.com/video/DF4KX1oSrVI/w-d-xo.html
Thank you Shane. Good help man!
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.
Can you do this with a Gmail account as well as there is an option for Gmail in the connections part
I have never done it but I am sure you can.
Hi shane, how to make multiple carbon copy email o how to send to multiple emails? i've been trying many ways but nothing works.
Try ForAll against the list of email addresses
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
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. 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.
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.
How do you make the email output on multiple lines (rows).
Thanks.
The key is the body of the email is HTML. So you need to write the html for multiple rows. is a line break. THere is an updated version of this video available here th-cam.com/video/vpYkOccwn4Y/w-d-xo.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?
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!!!!!!
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. th-cam.com/video/AnERfGIE8gw/w-d-xo.html
@@ShanesCowsThank you so much, Shane! That's exaclty what I needed. You're simply the best!
Hi Shane,
Quick question, how do you get the sender email to have the user logged into the app instead of mine?
If you are using Office365Outlook.Sendmailv2 it should always come as the person who clicked the link.
You're the man @shane 👏🏽
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?
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
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.
I cant find the "Hinttext" in my powerapps. Has it been removed or substituted??
Hi Shane.. when button is triggered a flow will start and flow has an email attachment. email should go to one who logged In. Is it possible?
Yes. Use user().email
shane,i am working through customize forms from sharepoint list,IN power apps i am getting ThisItem bt not {link}.Help me with this
Not sure. Sorry
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??
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.
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?
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
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 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 th-cam.com/video/AnERfGIE8gw/w-d-xo.html
Hi teacher
May I use the same logic,but I want to teams someone directly
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 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?
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.
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.
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. 🤩
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, 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.
Shane, How can i attach a file? this file is in sharepoint
You get the link and send them the link without much effort. If you need the file then try to store the file in the app in a variable and see if that will work. Never tried.
Is there a way to get an email to be sent automatically when an alert is shown, I.E i have Icon 5 with the syntax (Visble), If(ThisItem.Quantity
Replied to your other comment about this.
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 th-cam.com/video/FpXrF5NDZbI/w-d-xo.html
Hi Shane.
There is a way for the mail to be sent to the user who is logged into the PowerApps without writing it to the text entry
I have an idea and I imagine that instead of
Office365.SendEmail (TextInput1;
"Our first PowerApps Email"; "Our Email Message Here.") * '' TexInput '*' It would be replaced, but I don't know how
please help !
Thank you !
User().Email
And if we need to add attachments at this email? Please, help me. I have "attachements" field in my app
Here you go my latest video shows you sending email attachements. th-cam.com/video/V3feURQfY3M/w-d-xo.html
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, 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?
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.
Thank you for the helpful videos, Shane. Just getting started. Our IT department locks down most everything, but so far PowerApps has remained open and could help our workgroup a lot. Everything in the tutorial worked fine up until around the 8:50 mark when I typed "ThisItem.L..." and it did not resolve to '{Link}'. I only get the Intellisense red, squiggly line and a mouseover message of "Invalid name." Web search showed others trying to use Launch with a variety of parameters, none that work for my site. Not sure if the missing "Link" is something I need to enable on my end or what. Any ideas?
When you do ThisItem. what does it offer you in the dropdown? Anything?
No, mine is blank, not like yours (where it's showing '{Link}'. If I was working in some other MS dev environ, I'd suspect a missing Reference or equivalent. Not too sure here. App Info shows my PowerApps release as 2.0.795, for whatever that's worth.
If nothing pops to mind, please don't burn any more time. This may be unique to my site. The rest of your videos (and the others) have been golden. I can hardcode the link and send it that way; I just need to find a way to direct it to the displayed/selected name. Thank you again for posting these vids, they really, really help a lot!
Lucky for you it drives me crazy not to fix this stuff. :) I am pretty sure the issue is your button is not inside the form. Look at my screenshot from the time stamp you shared. My button is on a card in the form. You have to be within the form to use ThisItem. Does that make sense?
I matched up my screen with yours before I sent off my query :) and just to make sure, now, I pulled/re-added the button and textbox with the same results. I'll try this from home today, see if it behaves differently, and update you. Everything else has worked wonderfully--not always a normal condition. This may be an issue at my site and how they've configured O365/PowerApps.
We need to keep trying. There is nothing that IT did to make this not work. I am all but positive it is your button isn't on a card. :)
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.
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!!
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
Hi, no error in the code, but I have not received an email. What is the difference with SendEmalV2?
Full video on v2 😍 Everything about sending emails with PowerApps
th-cam.com/video/gyrU7XljKOw/w-d-xo.html
awesome work buddy...keep rocking...
😎
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?
Perfect, thank you so much! It's so simple when you explain! 😍
You're so welcome!
Hi Shane, thank you for the video!
One question! May I know how do I send an email with all the contents from the edited form? For example in your case, at 8:45 - instead of the link, I want to send the "Title, Color, Animal, Created, Created By, Modified and Modified By" together with the email message.
I am using One Drive Excel if you need to know.
Thanks in advance!! :)
Instead of ThisItem.Link use ThisItem.Title & ThisItem.Color (etc) just use the & between them to include multiple properties.
Hi Shane! Thanks for the quick reply!
However I've tried but the "ThisItem." function does not work for me. The error message shown: "Name isn't valid. This identifier isn't recognized. This error appears most commonly when a formula refers to something that no longer exists (for example, a control that you've deleted).
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!!
How to develop cascading dropdown?
I have a video on exactly that.
Can you use HTML in the body of the email so you can hide the URL behind a text hyperlink?
Hi shane, Ive watched alot of your videos but this one has me a little confused, can you advise where im going wrong,
Office365Outlook.SendEmailV2("Email.Address@gmail.com","Please reorder Toner","Can you please order more of the following: " & Tonercode_Dropdown.Selected.Value & Quantity_Input.Text)
I've been playing around but cant seem to get both information on the email and if they are they are not spaced out to make it easier to read.
Would appreciate the help. Thanks
Answered your other comment on this.