PowerApps Send email - Everything you need to know about sending mail via Outlook and Power Apps

Поделиться
HTML-код
  • Опубликовано: 2 авг 2020
  • In this video, you will learn about Power Apps Send Email capabilities. We explore Microsoft365Outlook connector and how to set the To, Cc, Bcc, From, Attachments, Importance, html body, and more. So much fun with email.
    Concat function for combining email address and making tables • Create nested data tab...
    Send email attachments deep dive • PowerApps Email Attach...
    Using Deep Linking in your app • PowerApps Deep Linking...
    Power Apps Training training.PowerApps911.com
  • НаукаНаука

Комментарии • 309

  • @mikeboling6777
    @mikeboling6777 3 года назад +5

    Shane thanks for all of your videos they have been a tremendous help. I've been watching all of them for a couple months now preparing for my place of employment to start utilizing Power Apps. I've been informed we are now going to be utilizing model driven apps. I love the way you teach and was hoping you could point me in the right direction for resources to continue to learn.

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Hey Mike i haven’t done much with model driven. Boo me. 😑

  • @WildPedal
    @WildPedal 3 года назад

    Thanks for this video Shane, you have taught me so much about PowerApps over the last few months! Always well delivered with enough information to get you going but with lots of other little tips along the way.

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Glad you like them and love the puppy picture!

    • @WildPedal
      @WildPedal 3 года назад

      @@ShanesCows He's one of my two canine overlords!

  • @Molton11
    @Molton11 3 года назад +1

    I am almost worried how good I will be at Power apps after watching your videos!! Greetings from the Czech Republic.

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Glad to hear that! Work hard and you will be the best!

    • @Molton11
      @Molton11 3 года назад

      @@ShanesCows Shane, sorry for bothering you - you must go crazy from all the comments. However I wonder if you could help. I connected D365 Finance to my canvas powerapp. I want to create purchase requisitions using powerapps. The problem is I need to submit the requisition with a number sequence ID that D365 expects. Can I solve this? Or am I using power apps incorrectly when I try to do this? Thank you! Lukas

  • @tnorman3329
    @tnorman3329 3 года назад +2

    Was redirected here from earlier video. Thank you so much for this!

  • @MrSmileyFella2
    @MrSmileyFella2 3 года назад +1

    You really helped me out a lot, thank you Shane. Youre doing great work :)

  • @srishtiu2092
    @srishtiu2092 5 месяцев назад +1

    Thanks Shane your videos are very informative and unique and really helps me out during my training period

  • @sundrapillay6668
    @sundrapillay6668 3 года назад +1

    Thanks Shane awesome video and for all your effort to teach and share your knowledge

  • @danielmfm
    @danielmfm Год назад +1

    awesome explanation for attachments - it saved my project!

  • @tomaseriksson6416
    @tomaseriksson6416 3 года назад +1

    Thanks Shane, i love your content!

    • @ShanesCows
      @ShanesCows  3 года назад

      You are welcome 🙏 Have a great day!

  • @melvin9993
    @melvin9993 3 года назад +1

    Very comprehensive and useful. Cheers

  • @stayalive1017
    @stayalive1017 2 года назад +1

    The function changed to Office365Outlook.SendEmailV2 you´re welcome oh and Shane thanks for the effort you´ve put into this

  • @alexshteinberg1227
    @alexshteinberg1227 3 года назад +5

    Nice one, this is exactly what I was looking for...:)

  • @ibtissamchabiba
    @ibtissamchabiba 3 года назад +1

    Hi Shane, thanks for another awesome video!

  • @datalevi
    @datalevi 2 месяца назад +1

    This video is a lifesaver, thank you for sharing this!

    • @ShanesCows
      @ShanesCows  2 месяца назад

      Glad it was helpful!

  • @janemaxey8974
    @janemaxey8974 3 года назад +4

    So helpful, Shane, as always and you do an awesome job of breaking it down. Love the use of labels as secret decoder rings!
    Is it possible to add more than 1 Bcc email address?
    Thanks!!

    • @ShanesCows
      @ShanesCows  3 года назад +2

      Yes, separate them by a ;

  • @mandijohnson-fisher5370
    @mandijohnson-fisher5370 2 года назад +1

    Thank you!! This helped me resolve an issue I was having using Launch("mailto:") and is better than it was.

  • @fullstackingwithgabriel322
    @fullstackingwithgabriel322 3 года назад +1

    Thanks Shane. Awesome video and info.

  • @swarchaakataria6818
    @swarchaakataria6818 3 года назад

    Hi Shane - love your videos - have been a great help!!! I am trying to combine two apps - shopping cart and email and want to send the email to the person who placed the order with the Order Id - but order ID is a variable - any idea on how can I do this ? I am also storing the variable in a container

  • @mikal4580
    @mikal4580 3 года назад +1

    Hey Shane, came here from an earlier episode. I have a slightly involved question, I want to send out a duplicate email to multiple people. But these people are going to be different every time. For example I want to send an email to everyone in a SharePoint list that has a column value of 1 or of 2. Should I use a ForAll or should I use a Flow? Thank you!! You've been a big help.

  • @johannawinsor558
    @johannawinsor558 3 года назад +1

    Hi Shane!
    Thank you for this super helpful video!
    Do you happen to have another where you go into depth on getting an image into the html table/format so that you can embed a variable image into the body of the email?

    • @ShanesCows
      @ShanesCows  3 года назад

      This is probably the best I have. ruclips.net/video/bIne3DD3HAg/видео.html

  • @ameensajid9857
    @ameensajid9857 Год назад

    HI Shane.. thanks, this is really helpful. Is there a way to send email using the email address provided in the form itself? Like, link the email to the "Requestor" datacard in the form itself and upon submission can we send the entire form content to these requestors?

  • @heloisaheng3189
    @heloisaheng3189 3 года назад +1

    Hi Shane thank you for the great video, you're Super!

  • @deoram65
    @deoram65 2 года назад +1

    Hello Shane, Great video as always! One question, I want to fetch the outlook contact groups(My contacts) and send an email to that group. I am able to send an email to an O365 group but not the contact groups. Kindly suggest how it can be done. Thanks in advance!

  • @jipraddaude
    @jipraddaude 3 года назад +1

    Hey Shane! Excellent video like always....speaking of emails, what about actionable emails (messages)? I know its more like a Flow thing but I think it would be very useful an approach on how to integrate that type of email with an App waiting for some user button action.
    Thanks!

    • @ShanesCows
      @ShanesCows  3 года назад

      I think I show email with options in this video. ruclips.net/video/umBegXooiKU/видео.html

  • @7chour
    @7chour 2 года назад

    Thank you Shane for this video.
    I was wondering if it is possible to add one or many attachements (based on the user choice) from an existing table in Dataverse where we have already loaded our files.
    Thank you in Advance

  • @vandanno4896
    @vandanno4896 2 года назад +1

    Hi Shane! Thank you for this super video!
    Is it possible to add a notification when mail sent on Power Apps?
    Like a message "Mail sent" show up when we clicked "Send email".
    Otherwise my users may click 10times...to be sure.

  • @snowliezzz
    @snowliezzz 2 года назад

    Very helpful! I have a question, can I trigger email notifications to send emails without triggering the "button" everytime PowerApps has an update? Thank you so much

  • @lisafrench499
    @lisafrench499 2 года назад

    Hi Shane, just being introduced to power Apps and looking for so e information. I'm looking to create a workflow for external users go submit a product inspection request. Can external users be given access, or do you have to create a special account for external user access? Also can power Apps link to other systems like Oracle?

  • @DoruntinaSadiku
    @DoruntinaSadiku 2 года назад +1

    Hi Shane, thanks for sharing this! I just wanted to know if there exists some time of solutions to send emails in Outlook Groups (with Group Id or such) becuase I didn't found a standard solution yet. So instead of the personal calendar I would need to display the Outlook groups calendar and also to create meeting from Power Apps to the group. Such solution would help me for my use case. Thank you!

  • @JeMasLT
    @JeMasLT 3 года назад +3

    Thank you. Very helpful. Do you have any video on error handling?
    Like: iferror, isblankorerror, how to handle system errors, like you getting lets say calendar event, and if it does not exists you get system error. How to do something like try catch.

    • @ShanesCows
      @ShanesCows  3 года назад +2

      I haven't made any content on that... added to the list.

  • @HasmukhJain1982PNQ
    @HasmukhJain1982PNQ Год назад +1

    Hey Shane, thank you for sharing your knowledge, you'll be blessed for that. I just have one question, what if one wanted to send an email to someone outside the organization. How do we get that email address in the "To:" Dropdown?

    • @ShanesCows
      @ShanesCows  Год назад

      That is up to you. Power Apps doesn't care what the email address is as long as it is text. So you could have a text input control name inpEmail and then set your TO in the formula to be inpEmail.Text and Power Apps would be happy.

  • @tommcardle7827
    @tommcardle7827 3 года назад +1

    Great videos! I appreciate everything you do Shane! Is there a way to send out emails from a generic email address as notifications. For example: I am making an Asset Checkout application. When a user checks out something from the inventory, I want an email or notification to go out to that user as a confirmation and to the application owner (and others) as informational for awareness, but I don't want the user to have to sign into outlook every time they login to the app.

    • @ShanesCows
      @ShanesCows  3 года назад

      Yes, using the SMTP connector. It is on my video list to make. Soon I hope.

  • @valentinanovara7122
    @valentinanovara7122 3 года назад +1

    Great video as usual Shane! I have a question if possible: I have a gallery, filtered by a dropdown, how do I email only the filtered items and not the entire gallery?thank you Valentina

    • @ShanesCows
      @ShanesCows  3 года назад

      Gallery.AllItems has a table of the records. Use it combined with Concat to get the email addresses.

  • @teresaagustin5191
    @teresaagustin5191 3 года назад +1

    Hi Shane, thanks for another awesome video! I’m interested in generating a pop-up window when “need more info” is selected from a drop down (versus setting a contextual variable in on select of a button). Is that possible to do OnChange? Have you had to do that for a customer yet? If so, would you mind recording a video on the topic?

    • @ShanesCows
      @ShanesCows  3 года назад

      Your Dropdown has an OnChange property where you can put code the same as OnSelect of a button. 😀

    • @teresaagustin5191
      @teresaagustin5191 3 года назад

      Shane Young great, thank you 😊

  • @BrijeshSingh-dq9kn
    @BrijeshSingh-dq9kn 3 года назад +1

    Great video Shane. One question, what's the maximum number of emails we can send from the SharePoint list using power automate in one click?

    • @ShanesCows
      @ShanesCows  3 года назад

      I don’t know of a limit.

  • @brightonalbert3237
    @brightonalbert3237 3 года назад +1

    clap clap now i know what i will do in case i get a request like that thank you

  • @danielhampson5918
    @danielhampson5918 3 года назад +1

    Hi Shane, great deep dive on email video. I still have one question though. In one of your Videos you send a email and had three buttons, well at least that is what it looked like. One of them had Good Job written on it. Anyway, are thoose written via HTML and secondly can a click on one of them update the sharepoint list. Like an approval?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      I think I talk about using Email with Options in this video to do something very similar to that ruclips.net/video/umBegXooiKU/видео.html if you go to www.powerapps911.com and fill out the contact form you will get an email to see what it looks like. 😀

  • @alanvelazquez9144
    @alanvelazquez9144 2 года назад +1

    Hi Shane, great video! One question is there any way to have your signature on the email? Thanks!

    • @ShanesCows
      @ShanesCows  2 года назад

      Alan email signatures are stored in your Outlook client, not in Exchange online. :( So I don't think you can get them.

  • @sujikim6809
    @sujikim6809 3 года назад +1

    Thanks for the video! I do have a question for you... I have a combo box and want to send email to users that are selected in the combobox. I did as what you said and the result come back as “builtinicon:mail” instead of emails. Any help would be great!

    • @ShanesCows
      @ShanesCows  3 года назад

      Sorry I am slow. Check the syntax of your Concat function.

  • @chestergarettcalingacion6631
    @chestergarettcalingacion6631 3 года назад +1

    Hi Shane, is it possible to just preview the email first but not send it right away? I would want to give the users the chance to review the email before sending in case they would want to add some extra discussions. Great vids, been a follower and learned so much from you!! Lots of love dude

    • @ShanesCows
      @ShanesCows  3 года назад

      Use Mailto ruclips.net/video/OGcofeqPFlc/видео.html

  • @punit45232
    @punit45232 3 года назад +1

    How did you configure your Combo Box, so you can type in it?
    I have a separate search Text Input Box where user’s type in their name and it populates in the Combo Box.

    • @ShanesCows
      @ShanesCows  3 года назад

      You can set the ComboBox to IsSearchable = true and then you can define the search field. Should work from there 😎

  • @rhyssunderland3561
    @rhyssunderland3561 3 года назад +2

    Hi Shane, great video, one question I have is how do you reset the values in each field for when a user wants to submit another email so that they aren't greeted with the text they previously sent.
    Edit: just figured it out for anyone wondering you can include:
    & Reset(TextInput1)

  • @barbloke1566
    @barbloke1566 3 года назад

    Superb chap!

  • @01097906
    @01097906 2 года назад +1

    Hello Shane, thanks for sharing, quick question, how do you send the email to a different person every time coming from a gallery, I want to improve the Meeting notes App from the PowerApps template to be able to attach docs also, and send those attachments to the attendees.

    • @ShanesCows
      @ShanesCows  2 года назад +1

      The to field is just text. You can pass it different values each time. The question is how do you want to get those values.

    • @01097906
      @01097906 2 года назад

      @@ShanesCows thanks, well I have a gallery where the emails are located and you can add / eliminate emails, so I don't know how to get that text in order to use the Office365Outlook.Sendemailv2

  • @SA-kt3wt
    @SA-kt3wt 2 года назад

    Hi Shane.
    I have an odd one.
    I use the launch function in my app for email. For a few people for some reason, this doesn't work. They click on the email button (launch) and nothing happens. For me, and others, it works perfectly. I've asked them to check their connections and their connections are the same as mine, and they use the desktop outlook email.
    I cannot understand why this is happening as we are all set up the same. Could it be to do with permissions (e.g., they clicked "never" accidentally when the "what do you want to open with (gmail or outlook)" option came up?

  • @powerappstw
    @powerappstw 3 года назад +2

    amazing video, one question, do I need to give send as permission to everyone to send email from a specific sender?

    • @ShanesCows
      @ShanesCows  3 года назад +2

      The emails typically come from the user who clicks the button. If you want the email to come from a SendAs then yes, you will need to give permissions.

    • @fla1910
      @fla1910 3 года назад

      @@ShanesCows Hi, please, do you have any solution for when we have an open access power apps solution and we cannot grant access to everyone in the shared mailbox?

  • @ianalexandertorres6189
    @ianalexandertorres6189 3 года назад +1

    Hi Shane, does power apps have a limitation on number of SP list connection? i do have 30+ SP list with same structures on different url and planning to create a one app for that. or should i go with SQL? thanks in advance

    • @ShanesCows
      @ShanesCows  3 года назад +1

      I don’t think so. I have had a lot but never counted them.

  • @umaraziz7109
    @umaraziz7109 3 года назад +1

    Hi Shane, great vid! How do I add new lines to the body text of the email? Thanks

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Email body is HTML. So you can use to create blank lines.

  • @JoshCanahan
    @JoshCanahan 2 года назад +1

    Thank you!! very nice; and then, if you send email from form how can you Put in BCC the same email address from the people who do the form? exist any way?

  • @lasherza
    @lasherza 2 года назад +1

    Shane you a legend! . but i got a problemo - My users are not visible in the combobox?. I jsut see like blank rows...no names appear.. do i need to right the concat formula too?

    • @ShanesCows
      @ShanesCows  2 года назад

      Click on the combo box in Studio. Then on the right click on Field. Choose a name field, you are showing a blank field right now.

  • @nipun399
    @nipun399 3 года назад +1

    It is awesome video shane :)....how to print dynamic table in Outlook without header?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      This video show how to use the Concat function to make a dynamic table. Also, you can use this ruclips.net/video/bfXV_GXc_JM/видео.html to learn more about it. This one produces a PDF but once it shows you how to make the HTML you could apply that to an email.

  • @dannymceleney2231
    @dannymceleney2231 3 года назад +1

    Using the new Microsoft365Outlook connector how would the code now look from your Video No2 when sending the PenInput image as an attachment? Cheers

    • @ShanesCows
      @ShanesCows  3 года назад

      Only part that would be different is the email function name. The code for package up the signature is the same.

  • @shaileshtp
    @shaileshtp 2 года назад +1

    Thank you sir 😊

  • @andres777video
    @andres777video Год назад +1

    Hey Shane, loved your videos!
    Q: I was trying to encrypt emails using Power Apps with Outlook, any tips on that ?

    • @ShanesCows
      @ShanesCows  Год назад

      I haven’t tried that one. Sorry. Let me know what you find. 😊

  • @ramisolipe7001
    @ramisolipe7001 2 года назад +1

    Amazing!

  • @maxgraham7645
    @maxgraham7645 2 года назад +1

    Hi Shane, thank you so much for the video. I am having issues with having PowerApps properly sending the emails. The powerapp is connected to a sharepoint list which records data the user enters once the powerapp form is submitted. When I submit the form or some other members of my group submit the form, the app properly sends the email to my director. However when other members across my organization (not within my group) submit the form no email is being sent. Is this an issue with permission levels in the sharepoint list? All of the people using the form are part of my organization/company and have outlook accounts within the organzation.

    • @ShanesCows
      @ShanesCows  2 года назад

      It shouldn't be a security issue. I would put a simple button to send a test email on the screen and have one of those people press it. Does it work? I am not sure what your challenge is.

  • @aprilsuk7311
    @aprilsuk7311 3 года назад +1

    Hi Shane, I have used your method of uploading files to a Sharepoint Document Library using the stole attachment control, and its working fantastic! I have built my entire flow based on that video, and when I'm the one submitting the form using the Outlook Send Mail V2 option it works fine. When I try to change the connection in PowerAutomate to a different account (a service account with a no-reply email address) I constantly get a "Failed during HTTP Send Request" error when I try to re-attach the updated Flow to the Submit button. I've tried editing the app and the flow as the service account, and I still get the same error. If I change the email notifications to "Mail" they work fine, or if I am the connection for the Outlook Send Mail it works fine (but sends emails from my personal address), but the second I change the connection it fails again. We are using the same account as the connection for a different automated flow, and it works fine. Are you aware of any problems caused by changing the connection when using an Instant flow vs. an automated flow?

    • @ShanesCows
      @ShanesCows  3 года назад

      I think you need to remove the flow from the Power App and then add it again.

  • @michaeldacampora5467
    @michaeldacampora5467 3 года назад +1

    Hi Shane great job with the videos. Is there any way on earth one can embed images in the body of a powerapps email, or any type of workaround? Ctrl-C, Ctrl-V would be a big help in my teams process flow.

    • @ShanesCows
      @ShanesCows  3 года назад

      This video. ruclips.net/video/bIne3DD3HAg/видео.html 😀

  • @tamannagupta4685
    @tamannagupta4685 2 года назад +1

    Hey Shane, Great video as always Thanks! Just a quick question if i add the outlook connector I’m using that to generate an OTP and send it to the user but i want the email to be sent by a service account instead it’s going from that logged in users account, I don’t want to provide the from as access to all the users so that they can do that any workaround without giving access?

    • @ShanesCows
      @ShanesCows  2 года назад +1

      This is one way I did exactly that. ruclips.net/video/l8NJkauGJ7U/видео.html

    • @tamannagupta4685
      @tamannagupta4685 2 года назад

      Thanks Again Shane ! Much appreciated your help! I had another query in which i want to check if a library contains files or not if it does then let the user open a power app screen and start the approval process but if not then that user should be directed to a power apps screen where there it is showing that please upload a file in the library then start your approval is there any way to trigger the flow on uploading a file or creating a new library and run to check and update the file count so that way we can figure out if there’s any thing in the library or the user is just running approval on an empty library? Any ideas for this i tried the inbuilt function of file count that is in Sharepoint but I’m unable to use that in power apps so any work around for this?

  • @samiraslan9735
    @samiraslan9735 3 года назад +1

    Very nice video and well explained, I have a question what if I want the emails to always come from the app creator ? like if we have forms and it doesn't matter who filled it -> once it is filled the app creator notify someone from his email.
    Thanks!

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Maybe something like this? ruclips.net/video/l8NJkauGJ7U/видео.html

    • @samiraslan9735
      @samiraslan9735 3 года назад

      @@ShanesCows Thanks!

  • @narenderguguloth8469
    @narenderguguloth8469 3 года назад +1

    Hi Shane
    You didn't show that what you used deep linking mail . can I get that functions ... Please

    • @ShanesCows
      @ShanesCows  3 года назад

      This video ruclips.net/video/A5Pi5P2YKds/видео.html

  • @ealexander2488
    @ealexander2488 Месяц назад +1

    Do you have a video where you select multiple records in a gallery and send an email for each record with a click of one button?

    • @ShanesCows
      @ShanesCows  Месяц назад

      This video would have the mechanics Power Apps Select Multiple Items in A Gallery
      ruclips.net/video/wpZbYPvPO68/видео.html

  • @freyalunn1179
    @freyalunn1179 2 года назад

    65,000 more views on that last video since you posted this :D

  • @sridharmohan8647
    @sridharmohan8647 2 года назад

    thanks for the video. Its awesome. wat if i need to send email to different recipients based on dept; for eg; if I select Dept A - while submitting form it should trigger to person A; if I select Dept B - while submitting form it should trigger to person B; Any suggestions please

  • @ginoginetto9389
    @ginoginetto9389 Год назад

    Hi Shane,
    tks for your molto helpful video. If it's possible I have a question for you. I understund how send an email from Powerapps, but I don't understand if it’s possible update a specific column in LIST whit a label “send” each time that I send a email. Es. I have a list of user and i want to know which user I have send the email e which no, I hope you have understand my english i write from Italy.. Tks in adv

  • @jl1399
    @jl1399 10 месяцев назад

    how might you have all the email information be on another screen but have it still email the user with the information the other email screen?

  • @PallaviSingh-wg9be
    @PallaviSingh-wg9be 3 года назад +1

    In powerapps can we use lookup function inside patch function?
    Actually I want to use some refrence name instead of column names in patch function. For ex instead of writing column name I will write any label which will have column name in patch function.
    Please revert if this can be done!!
    Thankyou

    • @ShanesCows
      @ShanesCows  3 года назад

      Not possible I don’t think. Sorry

  • @trolllogic2897
    @trolllogic2897 Год назад +1

    Hey Shane thanks for the updates as always! I would like to know though, is it possible to use this connector to send an email notification from the app without having your name seen as the sender. Like making the app itself as the sender. I know their Mail connector but that thing's depreciated. Thanks in advance!

    • @ShanesCows
      @ShanesCows  Год назад +1

      Not this connector but I did it differently in this video. ruclips.net/video/l8NJkauGJ7U/видео.html

    • @trolllogic2897
      @trolllogic2897 Год назад

      @@ShanesCows Hi! sorry for the very late reply but just wanna say thanks!

  • @joaoaayub
    @joaoaayub 2 года назад +1

    Hi Shane! Thanks for all your videos, it´s really helpful. I hope you can help me with a duplicate email problem. I made a Offline APP and when it sync to my Sharepoint it was supose to send an email, but I don´t no why, sometimes it send a lots of blank emails. Thanks again.

    • @ShanesCows
      @ShanesCows  2 года назад

      I assume you are using a table to loop through that you are sending emails from? Maybe filter the table for blank records and only send for records that are not blank?

  • @michaelkelly3017
    @michaelkelly3017 3 года назад +1

    Hi, Great video, really helped a lot. Question though, how would I send a form through outlook?

    • @ShanesCows
      @ShanesCows  3 года назад

      I am not sure. I have not done forms or adaptive cards in Outlook.

    • @michaelkelly3017
      @michaelkelly3017 3 года назад

      @@ShanesCows oh maan. I'm really struggling with getting a button to submit a form then get the results of that form to send off through outlook.

  • @GregBosma
    @GregBosma 3 года назад +1

    I was hoping to email the view (image) of a bar graph table I created.
    I understand that if I can capture the table as and image to a collection or some other location I can use the SharePoint attachment resource you mentioned here to "attach" that image.
    How can I capture the "static" image of the table into a table. (do you have another video I could reference or could you advise)
    Thanks GB

    • @ShanesCows
      @ShanesCows  3 года назад

      Hi Greg. There is no way to take what see on the screen and send it. You would need to create a table via HTML would be you best chance. Maybe SVGs?

    • @GregBosma
      @GregBosma 3 года назад

      @@ShanesCows Thanks Shane - I appreciate you helping me to avoid a rabbit trail.

  • @ivancuervo777
    @ivancuervo777 3 года назад +2

    Hello Shane, I have this challenge: sending emails in bulk with parameters from a list, the issues is that I understand I need to save the attachment first to the attachment column in the list, and then send the bulk emails. How can I achieve that?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Give this a watch. I show you how I sent out bulk emails. ruclips.net/video/umBegXooiKU/видео.html

  • @vitradie6643
    @vitradie6643 3 года назад +1

    Hey Shane, I have a sharepoint list which contains deeplinks for all the screens i've created in powerapps. I've been able to send email with this link using the ThisItem.'PowerApps Deeplink', however how do i shorten it to just show a hyperlink eg. "click Link" (similar to what you have in your video) instead of the whole url sting which looks messy?
    thanks

    • @ShanesCows
      @ShanesCows  3 года назад

      You need to create an html A tag. www.w3schools.com/tags/tag_a.asp

  • @vargjohansson6830
    @vargjohansson6830 7 месяцев назад +1

    Hey thanks a lot, but how make it to clear the fill boxes after sending?

    • @ShanesCows
      @ShanesCows  7 месяцев назад

      You can use the Reset function. Reset(TextInput1) for example

  • @claires9018
    @claires9018 6 месяцев назад +1

    I have written HTML for my email body, however, I can’t wrap my head around where PowerApps expects the various ” and & operators so I keep seeing the error Expected operator. We expect an operator such as +,*, or & at this point in the formula . Do you have an videos that explains this syntax further?

    • @ShanesCows
      @ShanesCows  6 месяцев назад

      Try writing plain HTML for the body first SendEmailV2(User().Email, "Subject goes here", "Body goes here")
      Once you get that to work then slowly add a bit of html until you find the piece that trips you up. One guess might be that you are using " inside of your html like That wouldn't work in Power APps. But anywhere you are using " you can change it to ' and that would work.
      HOpe that helps

  • @chanokponyongyat9928
    @chanokponyongyat9928 3 года назад +1

    Thank you very much. This is really helpful.
    However, I can't see the formula of sending email with deep link. I'd like to send email with url, but not showing the url address.

    • @ShanesCows
      @ShanesCows  3 года назад

      You have to write the html to do so. This video may help ruclips.net/video/A5Pi5P2YKds/видео.html

  • @joshhoward5187
    @joshhoward5187 2 года назад

    Hi Shane,
    Videos always very useful, but I'm trying to make a form on Powerapps that is then emailed, I can't find a video that helps,
    Basically the key question is; how can I take multiple Text inputs and put them into the one body of an email?
    Please help!

  • @launi3928
    @launi3928 2 года назад +1

    Hey this video was helpful, but I was wondering if I was able to send a copy of an edit form they filled out created by a sharepoint list in power apps to users if they wanted one. I have done a lot of research on this issue, but I have hit a dead end. I have no idea how I can create this feature for the users. Any insight?

    • @ShanesCows
      @ShanesCows  2 года назад

      Create html to represent the form and send it as the body of the email.

  • @aravindadamarla
    @aravindadamarla 3 года назад +1

    @shane is it possible to send email only to Bcc , and no recipients in to and cc ?

    • @ShanesCows
      @ShanesCows  3 года назад

      I don't know... I have never tried.

  • @jjayceeb
    @jjayceeb 2 года назад

    Hi how can i send email the new update in edit forrm and submit the changes at the same time. :)

  • @chris_thornborrow
    @chris_thornborrow 3 года назад

    Shane im smilimg. I'm old enough to understand Cc and Bcc. Carbon Copy.
    in the days of hand written mail, carbon copy paper was used to keep a copy of the letter.Bcc was new when email was introduced. Blind carbon copy.
    make a carbon copy but dont let people know you are doing it. I wonder if theses terms will be around after another 50 years of email?

  • @vishalaramasamy9357
    @vishalaramasamy9357 2 года назад

    You said chewy could have granted these permissions right? Can you give more information on how to achieve that? Because I don't have access to admin center , but a user has been added in admin center by IT team. I can't add send as permissions . Even though a user has been added , I am not able to send email of that user's behalf. Please help. Thanks in advance.

  • @MriduDaGreat
    @MriduDaGreat 2 года назад

    Thanks for eudcating us…i have a requirement to automate thr browser from outlook. Through power automate i was able to send the email with links and attachments. But the requirement is to open the browser as soon as the user opens the email body. Kindly share any information ℹ️ thank you!!

  • @jamalsutter
    @jamalsutter Год назад +1

    Great video. What if I set up an app like this up for an organization, but I get another job and my Outlook account is eventually deleted. Will the send email function still work, even though I would no longer have a 365 account?

    • @ShanesCows
      @ShanesCows  Год назад +1

      Yes, the email comes from the person who clicks the button in the app, not you.

    • @jamalsutter
      @jamalsutter Год назад

      @@ShanesCows thanks! That's good to know. I'm working on a few powerapp applications for an organization, but I won't be working for them for too much longer.

  • @1234567potro1234567
    @1234567potro1234567 2 года назад

    HI great video, But I'm having a problem, when I send an email based on input, when the email is sent it doesn't pull the input that was written on the combox, text input, etc.. I'm using HTML Text just like in the video.

  • @TheMemery76
    @TheMemery76 Год назад +1

    Do you happen to have a video about how to use SharePoint flows to do some of these things in email or can you point me in the right direction??

    • @ShanesCows
      @ShanesCows  Год назад

      Sorry, I don't follow what you are looking for?

    • @TheMemery76
      @TheMemery76 Год назад

      You created an email in power app, I need to be able to use a flow, not an app. I ALMOST have it figured out, but I can't quite get there. I was hoping you'd know - or have a resource that would - how to create the flow to send an email AND Cc a person/group when a status changes, for example.

  • @zombiexter8731
    @zombiexter8731 Год назад

    Can I Send a dynamic table with attachment files?

  • @mardithpascua8112
    @mardithpascua8112 3 года назад +1

    Hello shane, just wondering re sa premium accounts for powerbi, if i have a premium account, technically, I can use SQL Database as a back-end/repository for my data. If I am going to publish the apps and let other users with just standard account, are they allowed to Create/Edit/Update/Delete data connected to the SQL Database?

    • @ShanesCows
      @ShanesCows  3 года назад

      Not they have to have a premium license also b

  • @yunierdr00
    @yunierdr00 Год назад +1

    Is there a way that the emails generated from PowerApps or a flow to come from PowerAutomate or PowerApps, instead of the user?

    • @ShanesCows
      @ShanesCows  Год назад

      There are a few ways. This is how we did it for a few customers ruclips.net/video/l8NJkauGJ7U/видео.html You could also use the connector called "Mail" and it comes from a generic Microsoft account.

  • @kmuralikrishna1582
    @kmuralikrishna1582 3 года назад +1

    Really Great ...
    Can we send email to Azure Ad users ..? using Microsoft365Outlook connector ..?
    Can we configure/HardCode(Shared Mail Box) From Email instead of connected account, so that it will trigger always from HardCoded email?
    Please reply.

    • @ShanesCows
      @ShanesCows  3 года назад

      Try this ruclips.net/video/l8NJkauGJ7U/видео.html

  • @BenjaGm
    @BenjaGm 2 года назад +1

    Hi Shane, do you know how to transpose the html table? Thanks!

    • @ShanesCows
      @ShanesCows  2 года назад +1

      We have done it but it is painful. No quick pointer. Sorry. Brute force 😑

    • @BenjaGm
      @BenjaGm 2 года назад

      @@ShanesCows I managed to do it. The bad thing is getting a PDF from that table shows a mess between rows and columns.

  • @matthieublanpain546
    @matthieublanpain546 3 года назад +2

    Any way to have both: html inside the body AND open the email (in outlook) as draft to let user add info to the body before to send it?

    • @ShanesCows
      @ShanesCows  3 года назад

      www.w3docs.com/snippets/html/how-to-create-mailto-links.html should have the answers.

    • @matthieublanpain546
      @matthieublanpain546 3 года назад +1

      @@ShanesCows thank you for your reply Shane. And by the way thank you for sharing very educative videos. It was a great help to me. I did not ask correctly my question. Let me give an example: I want to use Launch("MailTo: to get the email in draft because the sender may decide to add /modify the given template, and I want to include a deeplink to Powerapps inside the body. My deeplink works well in a browser, but it is not displayed as a hyperlink in the email.

  • @corvanharten635
    @corvanharten635 2 года назад +2

    Good afternoon Shane, I do have a small question. On a separate screen I do Create a "HTML Text" body. This is updated after few seconds. I created a timer on a send button waiting for 20 seconds. On timer end it has the create mail stuff with sent, subject and as body the "HTML Text". But every time I nicely wait the 20 seconds it sends over an email with "Put HTM text here" Only after sending a 2nd time the body is attached. What am I doing wrong here? I do like your Video's switching back and forth between them to get stuff done. Thank you.

    • @ShanesCows
      @ShanesCows  2 года назад

      You will need to put the HTML control on the screen the Send button is on. YOu can set Visible to false so no one sees it.

    • @corvanharten635
      @corvanharten635 2 года назад

      If I only knew it was this simple, Thank you

  • @sakthiswaryalaganderan4236
    @sakthiswaryalaganderan4236 2 года назад +1

    hi shane can u upload a video like after submit a form it will email the details to the sender?

    • @ShanesCows
      @ShanesCows  2 года назад +1

      I replied to your other comment with a guide. :)

  • @vishalaramasamy9357
    @vishalaramasamy9357 2 года назад

    Hi , I really like your videos. They are very informative.
    I would like to know how to send email from power apps using power automate flow WITH ATTACHMENTS. I found how to send a normal email. But I am not sure how to send email with attachments in power apps using power automate flow. Can you please help me with this?

  • @scottclaxton8714
    @scottclaxton8714 3 года назад +2

    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

    • @ShanesCows
      @ShanesCows  3 года назад

      The body is html text. So you can format it to look as nice or as ugly as you want. 😀 your syntax looks good for basic text though.

    • @scottclaxton8714
      @scottclaxton8714 3 года назад +1

      @@ShanesCows the body is fine that shows up but for some reason the value selected in tonercode_dropdown.selected.value & quantity_input.text doesn't show on the email body

    • @tonimalcolm2660
      @tonimalcolm2660 3 года назад +1

      @@ShanesCows Hi Shane - So Glad to have found you. I have the same problem as @Scott Claxton and see you haven't yet replied to his question. I hope you have a solution for us!

  • @teresaagustin5191
    @teresaagustin5191 3 года назад +1

    Hello again Shane. I have more than 999 people in my organization. In the video you mention you have a video that covers a workaround. I don't see it in the video list you provided. Can you please let us know which one to watch? Thanks!

    • @teresaagustin5191
      @teresaagustin5191 3 года назад +1

      Nevermind Shane, I just saw your Contact function link above. Have a great day! Give Chewy a pat for me :)

    • @ShanesCows
      @ShanesCows  3 года назад

      This one is that referenced video ruclips.net/video/QhGV4AhCFRc/видео.html

    • @ShanesCows
      @ShanesCows  3 года назад

      Chewy says thanks🐶

    • @teresaagustin5191
      @teresaagustin5191 3 года назад

      Shane Young Thanks Shane! I used to have a Golden Doodle too. They are sweet dogs.

  • @jl1399
    @jl1399 Год назад +1

    How would you use this method to send an email from the person that last modified the form?

    • @ShanesCows
      @ShanesCows  Год назад

      The email always comes from the person who "presses the button" or triggers the action in Power Apps. So if you put the SendEmailV2 function OnSuccess of your form then the email would come from the user who submitted the form, not you the person who made the app.

  • @13Demonico
    @13Demonico Год назад

    I'm sending the email fine from a shared address, but the sent item shows up in my personal mailbox. I need it to save in the sent items of the shared account. I can't seem to figure this out. Help!

  • @ChaitanyaKondaveeti
    @ChaitanyaKondaveeti 3 года назад +1

    Is their any limitation with outlook 365 connector like 10k emails per day? How can we over come that?