cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhender
Frequent Visitor

Attachment content cannot be null or empty

Hi all,

 

I know this question has been asked before but there was no solution so I figured I'd ask again.

 

I built a simple but fairly long flow that takes the information from a SharePoint list entered from Powerapps, translates it, then creates two different pdf's (Spanish and English) and sends it out in an email to multiple recipients. 

 

The flow works 50% of the time with the other 50% occurring at the very last step [send an email(V2)], giving me the error:

 

Parameter 'Attachment Content' cannot be null or empty.
clientRequestId: 37adc4f7-288a-4616-b4f8-cdd7cf65835b

 

 

The attachment content is not null, I have dynamic files running, there is nothing hard coded, I have even tried adding delays and switching around the flow. 

 

The only temporary fix is building the flow from scratch each time which is terribly time consuming. 

 

Any help is appreciated! TIA

1 ACCEPTED SOLUTION

Accepted Solutions
abhender
Frequent Visitor

Thanks everyone for the replies, the flow started working shortly after I posted this message. The fix was that I had to upload all of the translated versions (documents) to the SharePoint list first as an attachment. Unlike before, I just had my array pulling the generated files as soon as they became translated. Then I used the whole "get attachments" scenario to grab them all again and put them in an array to be emailed. (There are some skipped steps below but they're not pertinent to the flow working). Hope this helps.

 

abhender_1-1617030369630.png

abhender_3-1617030847842.png

 

 

View solution in original post

13 REPLIES 13
jinivthakkar
Community Champion
Community Champion

Can you please share screenshots ? and if there are multiple attachments are you iterating in a loop and then getting attachment content for each file ?

 

Please check this link : 

 

https://www.techmeet360.com/blog/how-to-send-an-email-attachment-using-microsoft-flow/

 

HEATFreight
Kudo Kingpin
Kudo Kingpin

I have an attachment which is clearly not empty, yet my flow has an email error.

 

"body":{"status":400,"message":"Parameter 'Attachment Content' cannot be null or empty.\r\nclientRequestId: 2c948bd4-b51d-4097-861f-44dfdccb8d14","error":{"message":"Parameter 'Attachment Content' cannot be null or empty."},"source":"office365-wus.azconn-wus-01.p.azurewebsites.net"}}

 


The output from the "Get file content using path" action is this

 

{ "$content-type": "application/pdf", "$content": "JVBERi0xLjQKJaqr....=" }

 


And the attachment is attached using the normal way (not as an array). Like

Name.pdf


and

@body('Get_file_content_using_path')?['body']



How can this be null? Is this a transient issue that will fix itself? I worry that I am over my OneDrive data quota, and not sure how to fix.

Ok now I have passed in the attachment as an array via a compose function:

{
  "Name": @{outputs('Get_file_metadata_using_path')?['body/DisplayName']},
  "Content": @{body('Get_file_content_using_path')?['body']}
}


And the compose:

@{variables('Array')}




Attachments (Send an email V2):

[
  {
    "Name": "Name.pdf",
    "Content": {
      "$content-type": "application/pdf",
      "$content": "JVBERi0xLjQKJaqrrK0KMSAwIG9iago8PAo...="
    }
  }
]

 
Error details:

The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/ContentBytes'.



 

gpohlod
Advocate I
Advocate I

Hi @abhender ,

 

Are you sending one email or multiple emails at the same time?

 

If multiple emails, try adding a delay of 20 seconds between emails and see if that helps. It seems to have solved my issue. 

HEATFreight
Kudo Kingpin
Kudo Kingpin

Hey @abhender, I solved my problem by figuring out the difference between "Content" and "ContentBytes".

Certain scenarios require one or the other, and I don't really understand it, but I know when to use each one for my use cases. If you are having trouble, switch to the other and see if it fixes the problem, like:

{
  "Name": @{outputs('Get_file_metadata_using_path')?['body/DisplayName']},
  "Content": @{body('Get_file_content_using_path')?['body']}
}

vs.

{
  "Name": @{outputs('Get_file_metadata_using_path')?['body/DisplayName']},
  "ContentBytes": @{body('Get_file_content_using_path')?['body']}
}
goodingip
Frequent Visitor

I am getting the same issues, sending one email with 2 attachments. Both attachments are valid, as saving them to OneDrive works consistently immediately before the send as email. I tried the suggestion from @HEATFreight; the default in my PowerApps is to use "ContentBytes": for the attachment, and it gives me an error if I change it to "Content":  I am wondering if it could be a timeout issue, as it seems more likely when the attachments are larger (around 2Mb in my task - a PDF). It also works fine sometimes, and not others, with no change to the script. 

Hey @goodingip ,

 

I found it's very inconsistent and the only way I've been able to get it working consistently was to build it as a solution that calls child flows. The parent flow passes the path info of the file to the child flow which gets it from in my case SharePoint, then attaches the email and sends and returns to the parent flow, so it can call the next email. 

 

 

abhender
Frequent Visitor

Thanks everyone for the replies, the flow started working shortly after I posted this message. The fix was that I had to upload all of the translated versions (documents) to the SharePoint list first as an attachment. Unlike before, I just had my array pulling the generated files as soon as they became translated. Then I used the whole "get attachments" scenario to grab them all again and put them in an array to be emailed. (There are some skipped steps below but they're not pertinent to the flow working). Hope this helps.

 

abhender_1-1617030369630.png

abhender_3-1617030847842.png

 

 

That's helpful advice, thanks @gpohlod. I think what is happening in our case is that the licence I'm using isn't meaty enough (PowerApps Plan 2), so we're getting arbitrarily cut off when we do something complex. I've see it randomly stop at other points in our flow, so in our case it doesn't seem to be anything per se to do with the email attachments. 

See Limits and configuration - Power Automate | Microsoft Docs for how Microsoft have chosen to limit flow functionality unless you buy a per-flow plan. I borrowed a Dynamics 365 licence and it instantly fixed the problem. As a charity, I'm trying to do stuff without fancy licencing, but in this case we're going to have to pay to get the business efficiency we are looking for. 

everstab
Frequent Visitor

Hi,

I am getting the empty content error message when trying to attach attachments from a SharePoint list to an approval, even though the attachments are NOT empty.  I believe my flow is correct and it does work up until the approval.  I even put in a 5 minute delay since I work in a non-profit and some posts said our version of Power Automate may not be as robust in performance.  I am still getting the same error.  Any help would be greatly appreciated!   

everstab_0-1624458785845.png

everstab_1-1624459030334.pngeverstab_2-1624459061527.png

Thanks,

Pat

@everstab Pat, I don't have time to inspect your flow logic, but when I have problems with this I simply change "Content" to "ContentBytes" in the 'Append to array variable' action.

Certain types of files require one format and other kinds of files require the other format. If neither of these work for the files you are working with, then I would need to spend more time researching your specific use case.

PDF files are encoded as a stream of bits. Zeros and ones. So you need the "ContentBytes" tag instead of "Content" in your array. Photos on the other hand require that same "Content" tag you're already using. You need a conditional statement to branch the logic between different filetypes, and append the file content to the array using the correct content tag for that type of file.

zeedee11
Advocate II
Advocate II

I was able to solve this issue by using the sharepoint action "get file content", then putting file content into a compose action, and then putting the outputs of the compose action as the attachment content. Seems like a silly workaround but it worked for me.

 

Untitled.png

HEATFreight
Kudo Kingpin
Kudo Kingpin

@zeedee11 yeah, I use that trick quite a bit actually... When in doubt, compose it out!

Compose is also great because when you look at the data for a flow run it lets you see the current value of the entity which you're composing at that particular point in the flow, even when you would otherwise not be able to. It lets you pull some data out in a way that's easily visible but without having to initialize and set a variable. Love the compose action! Just wish I knew how to use the Parse JSON action...

Rant:
I have some unstructured JSON from a JotForm flow trigger that I need to dynamically parse for key-value pairs. The JotForm connector for Power Automate is poorly built such that the dynamic content keys for all fields in the JotForm are appended with a number which is just their order in the form, and this dynamic content breaks if that number changes. So if you rearrange the order of the fields in the JotForm, or add or remove fields, that changes the number appended to the field name which becomes the key name for that dynamic content, and when the number changes the reference link to that dynamic content breaks. So, for instance, if you were to delete the first field on a JotForm, the entire flow and every single variable coming from JotForm would break because the numbers appended to the dynamic content would all be off by one and thus none of the variables would populate with the data. So if —instead of initializing each variable with the dynamic content supplied by the JotForm connector— we were to parse the unstructured JSON in the JotForm flow trigger response body to populate variables with the correct value regardless of the number prepended to the key name, that would completely eliminate the issue. We could change up the order of the JotForm fields any way we like and the flow would always be able to match the correct value to its corresponding flow variable. The only thing that would break it would be removing a field entirely or changing the name of a field in the JotForm. Otherwise the flow would be robust in the face of changes to the JotForm. But until I can figure out how to use the Parse JSON action or some other Power Automate trick, I am stuck with an extremely brittle connection to JotForm which is not resilient to changes in the order of fields on the form. Ok rant over.

Anyone knows how to parse unstructured JSON in Power Automate, I'm all ears!

EDIT: Nvm, but holy smokes I figured out a solution to fix JotForm's un-parsable JSON. I filtered the "## - " section that prepends the key and i figured out how to recursively addproperty() to a JSON object variable until my JotForm triggerbody was rebuilt without the asinine numbers prepending my keys, and that can now be quite robustly parsed with Parse JSON. All I gotta do is  keep the JotForm field names the same, and add new schema every time I have a new form field so that I can dynamically grab it as a Parse JSON dynamic content. I can tell you that this sort of magic basically demands extensive use of Compose. Compose is the MVP of Power Automate!

Helpful resources

Announcements

Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3, 2024 at 9:30 AM PDT and join us for an engaging and informative session!

Tuesday Tip: Unlocking Community Achievements and Earning Badges

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!     THIS WEEK'S TIP: Unlocking Achievements and Earning BadgesAcross the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. These badges each signify a different achievement--and all of those achievements are available to any Community member! If you're a seasoned pro or just getting started, you too can earn badges for the great work you do. Check out some details on Community badges below--and find out more in the detailed link at the end of the article!       A Diverse Range of Badges to Collect The badges you can earn in the Community cover a wide array of activities, including: Kudos Received: Acknowledges the number of times a user’s post has been appreciated with a “Kudo.”Kudos Given: Highlights the user’s generosity in recognizing others’ contributions.Topics Created: Tracks the number of discussions initiated by a user.Solutions Provided: Celebrates the instances where a user’s response is marked as the correct solution.Reply: Counts the number of times a user has engaged with community discussions.Blog Contributor: Honors those who contribute valuable content and are invited to write for the community blog.       A Community Evolving Together Badges are not only a great way to recognize outstanding contributions of our amazing Community members--they are also a way to continue fostering a collaborative and supportive environment. As you continue to share your knowledge and assist each other these badges serve as a visual representation of your valuable contributions.   Find out more about badges in these Community Support pages in each Community: All About Community Badges - Power Apps CommunityAll About Community Badges - Power Automate CommunityAll About Community Badges - Copilot Studio CommunityAll About Community Badges - Power Pages Community

Tuesday Tips: Powering Up Your Community Profile

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week's Tip: Power Up Your Profile!  🚀 It's where every Community member gets their start, and it's essential that you keep it updated! Your Community User Profile is how you're able to get messages, post solutions, ask questions--and as you rank up, it's where your badges will appear and how you'll be known when you start blogging in the Community Blog. Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile.     Password Puzzles? No Problem! Find out how to sync your Azure AD password with your community account, ensuring a seamless sign-in. No separate passwords to remember! Job Jumps & Email Swaps Changed jobs? Got a new email? Fear not! You'll find out how to link your shiny new email to your existing community account, keeping your contributions and connections intact. Username Uncertainties Unraveled Picking the perfect username is crucial--and sometimes the original choice you signed up with doesn't fit as well as you may have thought. There's a quick way to request an update here--but remember, your username is your community identity, so choose wisely. "Need Admin Approval" Warning Window? If you see this error message while using the community, don't worry. A simple process will help you get where you need to go. If you still need assistance, find out how to contact your Community Support team. Whatever you're looking for, when it comes to your profile, the Community Account Support Knowledge Base article is your treasure trove of tips as you navigate the nuances of your Community Profile. It’s the ultimate resource for keeping your digital identity in tip-top shape while engaging with the Power Platform Community. So, dive in and power up your profile today!  💪🚀   Community Account Support | Power Apps Community Account Support | Power AutomateCommunity Account Support | Copilot Studio  Community Account Support | Power Pages

Super User of the Month | Chris Piasecki

In our 2nd installment of this new ongoing feature in the Community, we're thrilled to announce that Chris Piasecki is our Super User of the Month for March 2024. If you've been in the Community for a while, we're sure you've seen a comment or marked one of Chris' helpful tips as a solution--he's been a Super User for SEVEN consecutive seasons!   Since authoring his first reply in April 2020 to his most recent achievement organizing the Canadian Power Platform Summit this month, Chris has helped countless Community members with his insights and expertise. In addition to being a Super User, Chris is also a User Group leader, Microsoft MVP, and a featured speaker at the Microsoft Power Platform Conference. His contributions to the new SUIT program, along with his joyous personality and willingness to jump in and help so many members has made Chris a fixture in the Power Platform Community.   When Chris isn't authoring solutions or organizing events, he's actively leading Piasecki Consulting, specializing in solution architecture, integration, DevOps, and more--helping clients discover how to strategize and implement Microsoft's technology platforms. We are grateful for Chris' insightful help in the Community and look forward to even more amazing milestones as he continues to assist so many with his great tips, solutions--always with a smile and a great sense of humor.You can find Chris in the Community and on LinkedIn. Thanks for being such a SUPER user, Chris! 💪 🌠  

Find Out What Makes Super Users So Super

We know many of you visit the Power Platform Communities to ask questions and receive answers. But do you know that many of our best answers and solutions come from Community members who are super active, helping anyone who needs a little help getting unstuck with Business Applications products? We call these dedicated Community members Super Users because they are the real heroes in the Community, willing to jump in whenever they can to help! Maybe you've encountered them yourself and they've solved some of your biggest questions. Have you ever wondered, "Why?"We interviewed several of our Super Users to understand what drives them to help in the Community--and discover the difference it has made in their lives as well! Take a look in our gallery today: What Motivates a Super User? - Power Platform Community (microsoft.com)

March User Group Update: New Groups and Upcoming Events!

  Welcome to this month’s celebration of our Community User Groups and exciting User Group events. We’re thrilled to introduce some brand-new user groups that have recently joined our vibrant community. Plus, we’ve got a lineup of engaging events you won’t want to miss. Let’s jump right in: New User Groups   Sacramento Power Platform GroupANZ Power Platform COE User GroupPower Platform MongoliaPower Platform User Group OmanPower Platform User Group Delta StateMid Michigan Power Platform Upcoming Events  DUG4MFG - Quarterly Meetup - Microsoft Demand PlanningDate: 19 Mar 2024 | 10:30 AM to 12:30 PM Central America Standard TimeDescription: Dive into the world of manufacturing with a focus on Demand Planning. Learn from industry experts and share your insights. Dynamics User Group HoustonDate: 07 Mar 2024 | 11:00 AM to 01:00 PM Central America Standard TimeDescription: Houston, get ready for an immersive session on Dynamics 365 and the Power Platform. Connect with fellow professionals and expand your knowledge. Reading Dynamics 365 & Power Platform User Group (Q1)Date: 05 Mar 2024 | 06:00 PM to 09:00 PM GMT Standard TimeDescription: Join our virtual meetup for insightful discussions, demos, and community updates. Let’s kick off Q1 with a bang! Leaders, Create Your Events!  Leaders of existing User Groups, don’t forget to create your events within the Community platform. By doing so, you’ll enable us to share them in future posts and newsletters. Let’s spread the word and make these gatherings even more impactful! Stay tuned for more updates, inspiring stories, and collaborative opportunities from and for our Community User Groups.   P.S. Have an event or success story to share? Reach out to us – we’d love to feature you!

Users online (5,059)