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. :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html If not enjoy the 400ish videos I have and enjoy the journey, learn Power Apps is fun.
Thanks to you I have created the perfect fill-out form. As a person with zero coding experience, I can say you are great explaining everything so people like me can understand.
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!!!
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?
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html Hopefully that gets you everything you ever wanted to know.
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. 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
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.
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
Great video and exactly what I needed. I have been working on a project to migrate our current intranet (PHP) into our SharePoint and O365 tenant and I am finding Power Apps VERY useful. And I just subbed to your channel. Good stuff
I am soon going to be tackling using power apps with flows. I wouldn't mind seeing that, unless you have already done one. Also, I watched the one with variables and I have a screen with one form and would like to set the variable value at the time of the app starting and I have yet to figure that out
So usually to set a variable at the start you can go to the first Screen and set the OnStart property. That is the closest thing to initializing you are going to get. I actually show it in an upcoming video. Here is the doc. docs.microsoft.com/en-us/powerapps/controls/control-screen
Great, thanks for the info. I will pay around with it as when I go to set the variable in the screen, it tells me that Context variables are not allowed. Even though I have one screen and one form. Instead of using (UpdateContext) I will just try to use Set on the variable and see what happens.
EDIT: And I just read this at the link you sent: "You can't set context variables with the UpdateContext function because no screen has appeared yet. However, you can pass context variables in the Navigate function and create and fill a collection by using the Collect function." So I will try to Navigate OnStart and see if that works
Hi Shane, 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 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.
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?
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?
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. :)
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 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
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.
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
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 ";".
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.
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.
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
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?
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 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?
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.
What is wrong in my formula? The email will not go. Error says " your formula is missing a column 'Contentbytes' with a type of 'blob' Office365.SendEmail("agoolman@","MY subject Policy forms" , "Body text" & Name.Text,{Attachments:Table({name:"peninput.jpg",Contentbytes:signature.Image , '@odata.type':""})})
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
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html
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?
@@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??
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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html
Hi, Shane , your videos are incredible, you help so much!! One question , if I create the connection with office365 and publish the app, will other internal users also be able to click ‘send email’ and send from their own emails? How does the connection work, or do I have to do something different to enable this? Thank you
Yes, it will use their OUtLook to send the email. 😀 Here is an updated version of this topic to help you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html
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
HI! Great video. The only problem we're encountering is that for the other "users" they have to have "write" permissions on the XLS file. Up to here OK... but how do you prevent them from not opening the XLS files and changing all the data, etc?
@@ShanesCows Thought so!!! Thanks for your reply! We're trying to use a SQL-Database but trying to create a prototype without spending (right now) any many => I'll keep you updated
Hi Shane, 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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-49O284deOAI.html Also there is a new version of this video that is much better about emails. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html
Nice vid as always, quick question, is there a way to change the "From who" the email is send to the current user of the apps? You use the MOD Admin when you create your connection, will it always be from that email adress that the mail will come from?
Fantastic and simple . Thanks for the video. I actually need to send an Email through a generic Email id and not the one which i logging in with . Can i do that ? Or can I use ( Id A ) to develop in Power Apps and inside that (ID 2) to send email ?
Hi Shane, First of all, amazing video... Second, you can help me, I need to do exactly that, but instead of sending an email, I need to send an invite to the outlook calendar, could you help me?
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 Shane I have a list in sharepoint and my application in PowerApps, I need that in each form of these that I have in my application before giving it save a notification email arrives in which in the body of the message with html tell me the `` ID '' which brings by default each list, that is to say if 105 queries have been made and a user will make a query when saving and sending the form you should receive an email telling you that your query has the ID 106. With what variable in the message body can I call this ID?
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?
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?
One further question...I was able to get my date picker selections to show up in the body of my email, however, I can't get any of my dropdown selections or text input selections to show up. Any idea why that might be?
Hi Shane! This is very helpful,thank you very much!! but what if Instead of manually typing the person's name I want to add a combobox so that my users are searchable. I keep getting errors when i try to use that option instead, any ideas as why?
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.
Hi Shane, great video! One question. How do you send an email to the person who created the form? I have a form with an 'approve' and 'reject' button, and once somebody clicks one of the buttons, the creator should receive an email. I tried something like: 'ThisItem.Author.Email' but that doesn't seem to work. Any suggestions?