Excel Attachment in Email from Workflow not Opening Properly
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
All of a sudden this email generated from a workflow is not opening properly. I'm getting the below error message. Then, once I click "Yes" indicating I trust the source, I get the second error message below. Can someone advise how I can fix this? It was working fine until recently.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI @mattpeltcfa , I have faced this issue when I was trying to export an xml file into excel. Most of the characters are invalid in terms of excel therefore this dialog box is displayed.Could you be more specific what type of data your includes or have you tried to output csv or txt file?
For csv format you can choose utf-8 where it will read the invalid characters as well.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is a mockup of the file I am trying to attach and the end of the workflow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @mattpeltcfa
Ive had this very similar issue before with running on a server, and i managed to get it to work with the Parallel Block Until Done tool. As far as i understand, the block till done will just wait until the data is sent out of the first situation before sending out to the other, so if it is taking a while to save to your excel it could cause error.
I've attached a packaged workflow, give it a go and see if it works!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey! 2 things:
1. I have a less recent version of Alteryx, so when I was able to download the workflow, it did this to the macros.
2. Even though I have saved the parallel block until done macro, it says it is invalid.
