How and when to use Base64 expression in Microsoft flow.

I have created a flow that gets trigger on update of an "account" entity record and creates a Note(Annotation) record in Dataverse, This note has a PDF attachment.

Flow is like this, in the last step, I am creating a note in Dataverse and attaching a newly created PDF in it:



But, I am getting the below error while attaching pdf in a note:

Invalid character in field 'documentbody': '', hexadecimal value 0x04, is an invalid character.

The reason behind it is the "Document" column, Flow accepts a file content in "Base64", hence I have to change it to base64:



Below are steps to convert it in "Base64":

Step 1: Click on the Document text box as highlighted below then click on "Expression".

Step 2: Search for "Base64" and put bracket().



Step 3: Click on "Dynamic Content", keep the cursor in between the bracket() and click on "File Content"




Step 4: Click ok.


Now, the Document Text box has the following value:



Step 5: Save the flow and test it. 


Issue resolved. 😀



Cheers,
Rocker














Comments

Post a Comment

Popular posts from this blog

Power Automate: Create and attach Dataverse note or activity with an entity record through MS flow

Image
There was a requirement where a note(annotation) will be created once an account is created in Dataverse. I have created a Microsoft flow to achieve this functionality. Below is the screenshot of the flow: It was not a difficult flow but I was getting below error in last step i.e, "Create a note and attach PDF" Resource not found for the segment. The reason for this error was assigning "Account id" in regarding: To resolve the above error, I have set "accounts(Account)" in regarding and it worked. You can also use "/accounts(Account)". Conclusion : Whenever you are creating a #Dataverse note or activity through #MSflow then use "entityname(entityid)" or "/entityname(entityid)" in regarding and don't forget to add suffix "S" in entityname. Cheers, Rocker
Read more

{Error:Fetch XML}: The date/time format is not valid, or the value is outside the supported range

Image
  Error:  The date/time format is not valid, or the value is outside the supported range One day, I was getting below error message in a workflow: The reason behind this error was fecth XML. I was using date parameter in condition attribute of fetch XML, Below is image of my code: I have changed date format to “yyyy-MM-dd” and error has been resolved . Cheers, Rocker
Read more

How to set privilege for Activity Attachment (activitymimeattachment) in Dynamics 365 or PowerApps

Image
One day, some of the users in my Dynamics 365 CE environment were not able to attach a document against an appointment and other activities. A user who has a basic(user-level) create, global read, business unit edit, and global "append and append to" privileges on activities, trying to attach a document against an activity that is owned by another user/team. But unable to do it and getting an "insufficient privilege" message. We know that there is no privilege in the security role for "Attachment" and many people suggest that attachments are handled by "Note(annotation)" privilege. I have increased the notes privilege to global but no luck. After doing some research, I came to know that the "Activity attachments(Activitymimeattachment)" privilege depends on Activities. When I increased the activity  "Create, Append and append to" privilege to Global(Organization) then attachment also inherited this privilege. Hence users are a
Read more