tag:blogger.com,1999:blog-3970629459363259828.post880843957763338529..comments2024-03-29T18:39:50.323+13:00Comments on Linn's Power Platform Notebook: Send Email from Dynamics 365/Microsoft Dataverse with Attachment from Notes Using FlowLinn Zaw Winhttp://www.blogger.com/profile/16015532694415495453noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-3970629459363259828.post-34057884759465675762022-10-05T09:11:17.232+13:002022-10-05T09:11:17.232+13:00Linn, this post is a couple years old, but I have ...Linn, this post is a couple years old, but I have been searching for a proper example of how to do an outgoing email notification in D365 using power automate (in other words, the type of email notification that you might have once generated using a classic workflow process in D365), but I have not found one that works for me. Seems like an unfulfilled need.<br /><br />The fact that you are using a QUEUE as the FROM party is interesting. However, I tried that and it gave me the following error: Could not find email address for recipient of type 'Queue' with ID 'ee633de6-4e3a-eb11-a813-000d3a591e88'.<br /><br />I had previously been setting the FROM to "systemusers(e7633de6-4e3a-eb11-a813-000d3a591e88)" and it accepts this, but I cannot say if that is correct because I still haven't gotten this to work completely.<br /><br />If Power Automate is intended to be "easy" for the average user, they have certainly missed the mark on this. I'm an experienced developer and I cannot seem to find the information on how to do this correctly.Jrichviewhttps://www.blogger.com/profile/16697462049031483125noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-61963482364231768982022-05-10T17:25:37.866+12:002022-05-10T17:25:37.866+12:00After numerous searches, I finally stumbled upon t...After numerous searches, I finally stumbled upon this post and found exactly what I needed. Thank you so much for sharing your knowledge and expertise!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-30325775268746467412022-03-25T18:06:50.226+13:002022-03-25T18:06:50.226+13:00That's possible. I have never done it for Azur...That's possible. I have never done it for Azure Blob Storage but you should be able to use this Get blob content using path (V2) action in the Azure Blob Storage connector.<br />https://docs.microsoft.com/en-us/connectors/azureblob/#get-blob-content-using-path-(v2)<br /><br />For SharePoint, you can use Get file content action in the SharePoint connector.<br />https://docs.microsoft.com/en-us/connectors/sharepointonline/#get-file-content<br /><br />Here are some examples.<br />https://docs.microsoft.com/en-us/microsoft-365/community/power-automate-send-sharepoint-files-as-attachments<br /><br />https://youtu.be/bGG_dTBK6a8Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-17183691031597804932022-03-11T14:59:17.589+13:002022-03-11T14:59:17.589+13:00Dear, I have a requirment to send customer stateme...Dear, I have a requirment to send customer statements, which are residing outside CRM (most probably in Azure blob storage or share point, how can we reteive those customer statements and send them in bulk email) Anonymoushttps://www.blogger.com/profile/12284924187983280522noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-15726464294961311302021-09-17T01:38:43.122+12:002021-09-17T01:38:43.122+12:00You can use the SendTemplate unbound action to use...You can use the SendTemplate unbound action to use an email template but you can't dynamically attach the files https://benitezhere.blogspot.com/2020/03/how-to-send-email-using-email-template-with-power-automate.htmlLinn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-9619986899075301802021-09-16T15:47:36.415+12:002021-09-16T15:47:36.415+12:00G'day Linn,
Love the Post thank you!
Is ther...G'day Linn,<br /><br />Love the Post thank you!<br /><br />Is there a way I can use an email template with this flow. E.g. where the subject and Description are both filled out from an email template within dynamics?<br /><br />Thanks Anonymoushttps://www.blogger.com/profile/08592999513984810409noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-1902975972473549682021-07-30T10:19:55.838+12:002021-07-30T10:19:55.838+12:00Thanks for your feedback. I guess Microsoft has up...Thanks for your feedback. I guess Microsoft has updated the Dataverse connector to accept null values in the lookup field. I have updated the blog post.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-45326688534566222542021-07-29T08:40:08.208+12:002021-07-29T08:40:08.208+12:00AMAZING!! you just saved me from madness ;) BTW ...AMAZING!! you just saved me from madness ;) BTW the editor didn't recognized the 'undefined()' that you put as an empty string in the 'Attachments' field. I just put a 'null' expression and it did the trick. Thanks!✨Anonymoushttps://www.blogger.com/profile/00134937862536764308noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-89318962130981414852021-06-11T18:08:42.652+12:002021-06-11T18:08:42.652+12:00You're welcome, Anneke. 😊You're welcome, Anneke. 😊Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-67256827736031263852021-06-10T23:36:59.822+12:002021-06-10T23:36:59.822+12:00You've just done all my work for me! Thank you...You've just done all my work for me! Thank you once again Linn. You're a legend as always! :)Anneke Crousehttps://www.blogger.com/profile/14428622668362584389noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-54897373915519176622021-05-11T20:46:02.007+12:002021-05-11T20:46:02.007+12:00Once again, you have saved the day! Super post. I ...Once again, you have saved the day! Super post. I would not have delivered my project without this information. Many thanks.Anonymoushttps://www.blogger.com/profile/11068417820643057040noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-10265713887252039972021-05-05T17:35:36.020+12:002021-05-05T17:35:36.020+12:00I'm glad it helped, Mike.I'm glad it helped, Mike.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-9351892931246811412021-05-05T03:37:56.086+12:002021-05-05T03:37:56.086+12:00Thanks - this was a really useful page. I was able...Thanks - this was a really useful page. I was able to get it working. Would have taken ages to figure this out without this page!Mike Feingoldhttps://www.blogger.com/profile/06874555113664819822noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-31196787481060347602021-03-05T20:26:46.474+13:002021-03-05T20:26:46.474+13:00Thank you for mentioning it. Hope you'll conti...Thank you for mentioning it. Hope you'll continue to post :) <br />Katie Pagehttps://www.blogger.com/profile/08747962207571655262noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-15781537657296905822021-03-05T14:11:49.396+13:002021-03-05T14:11:49.396+13:00Hi Katie
You are missing a single quote after bod...Hi Katie<br /><br />You are missing a single quote after body/value and the square bracket [] need to be used to get the property ['queueid']<br /><br />Here is the updated expression<br />first(outputs('Get_user_for_email_to_come_from')?['body/value'])?['queueid']Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-15569866283844698112021-03-05T12:59:52.005+13:002021-03-05T12:59:52.005+13:00it is an invalid expression
it is an invalid expression<br />Katie Pagehttps://www.blogger.com/profile/08747962207571655262noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-80416680620646514762021-03-05T11:30:46.454+13:002021-03-05T11:30:46.454+13:00Hi
Thanks for
I am new to Flows.
I have a requi...Hi<br /><br />Thanks for<br /><br />I am new to Flows.<br /><br />I have a requirement to send an email on update of Lead owner, send an email. The sender must be fetch from queue's email address.<br /><br />However, I put it in the expression and says invalid expression:<br />first(outputs('Get_user_for_email_to_come_from')?['body/value])?('queueid')<br /><br />Any thoughts why?<br /><br />Thank you very much<br /><br />I have tried to type in the expression you have above but it says that Katie Pagehttps://www.blogger.com/profile/08747962207571655262noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-40017073362033554452020-09-12T20:50:55.796+12:002020-09-12T20:50:55.796+12:00This comment has been removed by the author.Saurabh Khoslahttps://www.blogger.com/profile/01714897267380532002noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-20319155660133769452020-08-02T16:39:11.480+12:002020-08-02T16:39:11.480+12:00Thank you. I have discovered the problem, was able...Thank you. I have discovered the problem, was able to import your solution (finally) and it's working. Thanks again for the help and this blog post, it's really taught me a lot about this type of Flow! <br />Anonymoushttps://www.blogger.com/profile/04094930471569368087noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-68732595712760133972020-07-31T10:42:40.064+12:002020-07-31T10:42:40.064+12:00You must create solution-aware flows to use the Co...You must create solution-aware flows to use the Common Data Service (current environment) connector. (i.e. you need to create your flow inside the solution to see the CDS (current environment) connector options)<br /><br />Even if you hvae created a flow outside of the solution and added into the solution later, Common Data Service (current environment) action will still not be available. CDS (current environment) connector is only available for flows which are created originally as part of the solution.<br /><br />https://docs.microsoft.com/en-us/power-automate/connection-cds-native<br /><br />https://debajmecrm.com/2019/11/24/quick-tip-common-data-service-current-environment-connector-not-showing-up-while-creating-microsoft-flows-power-automate/Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-76241100212811855232020-07-31T03:46:11.527+12:002020-07-31T03:46:11.527+12:00I think this is why I'm having a problem. When...I think this is why I'm having a problem. When I add step "Update a record", I only have one option for Common Data Service connector, I would expect to have "Common Data Service" AND "Common Data Service (Current Environment)". <br /><br />When I go to "Connectors" I do see both. But when I am editing my flow, I only see Common Data Service option and not the Common Data Service (Current Environment) option. Do you have any tips about that? Very strange that I'm not seeing that inside my flow. <br />Thank you!! Anonymoushttps://www.blogger.com/profile/04094930471569368087noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-23264376232443642662020-07-30T21:44:55.373+12:002020-07-30T21:44:55.373+12:00For the Update step, Common Data Service (current ...For the Update step, Common Data Service (current environment) connector needs to be used.<br />If you use CDS (current environment) connector, you should not have the Environment option.Linn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-40088078524502984192020-07-30T03:00:39.824+12:002020-07-30T03:00:39.824+12:00Thank you for your reply, I have tried using the f...Thank you for your reply, I have tried using the first of the two Attachments entity, but the option for Body, Filename and and Mime Type are not available when I use that option. Do you know why this might be? <br /><br />This is what I have set up:<br />Environment: current, Entity Name: Attachments (1st of 2), Record Identifier (assuming this is "Item ID" from your setup): Activity Mime Attachment. The other available fields are: Attachment Number, Entity Value, Attachment, Item, Item Type and Content Id. No option for Body, filename or Mime Type. <br /><br />Thoughts?Anonymoushttps://www.blogger.com/profile/04094930471569368087noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-90717869310455751282020-07-29T23:24:04.344+12:002020-07-29T23:24:04.344+12:00The following line mentioned in the Step 5 also ap...The following line mentioned in the Step 5 also applies to the step 6 too.<br />"Select the first one out of x2 "Attachments" in the Entity Name list for Attachment (ActivityMimeAttachment) entity."<br /><br />I also added the preview image in the blog post at step 6.<br />https://1.bp.blogspot.com/-vq8JEEmu3TU/XyFbhfXLaMI/AAAAAAABsI0/W6DLAJKqUOwoOJt0XZ6gAgb2vLWxOocIgCLcBGAsYHQ/s652/Update%2BAttachment%2BEntity.pngLinn Zaw Winhttps://www.blogger.com/profile/16015532694415495453noreply@blogger.comtag:blogger.com,1999:blog-3970629459363259828.post-46635535900515005282020-07-29T11:04:55.379+12:002020-07-29T11:04:55.379+12:00Hello Linn, I've created this as you have in y...Hello Linn, I've created this as you have in your instructions (thank you so much by the way!), however even after following the specific instructions I'm still getting the error {"error":{"code":"0x80040800","message":"The 'Update' method does not support entities of type 'attachment'."<br /><br />I can provide the entire error message and a screen shot of my flow setup if you'd like, I don't think I can do that as a comment here though. Any tips? Anonymoushttps://www.blogger.com/profile/04094930471569368087noreply@blogger.com