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

Add a converted file and an array of files as Approval attachments

Hi guys,

 

I have a flow that captures file uploads from an MS Form and i wanted to attach those along with a converted file as attachments to an approval email. I did the append to array action for the file uploads, however combining the end product with the converted file to the attachment field in start an approval gives me an error. What do I do to keep both items and run the flow smoothly? Below are some screenshots to give you an idea. 

I appended the file uploads here:

3BF4A4B3-B29B-4B6F-B807-BE6922E6D267.png

 

then my converted file is processed below just before the Create an approval action:

7FB9A56C-67EE-4A0E-B389-8F8F1C13E985.png

if you see the attachment field here, i crammed the converted file(initialized as an object since i was not sure know how to process it) and the appended files. 

E451AA4E-2A0F-4E09-8804-8CE36ED36C90.png

Hope someone could answer my query. Any support is appreciated. 

thanks! 🙂

1 ACCEPTED SOLUTION

Accepted Solutions

HI @Friedmochii_92 ,

 

Could you please share the entire flow, with easy to see screenshots. I think I am missing the entire context.

 

For the Approval action, you should add a single variable as shown below: 

Snag_1d4949a.png

 

Note also the difference in format for the Approvals attachment array compared to attachments array when used in Outlook:

Snag_1d6544c.png

Ellis

View solution in original post

7 REPLIES 7
ekarim2020
Super User
Super User

Hi @Friedmochii_92 .

 

Please see the post: How to send Microsoft Forms file uploads to an Approval workflow using Power Automate

 

You should append all your files to the attachments array as mentioned in the post, including your "converted file":

 
 

snag_70a84d3.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Hi Ellis,

 

Thanks for responding. I tried your solution however I’m stuck at the moment. For more context, my flow runs whether the request is for a client or a vendor. So it starts off here, where I initialized the file attachments and then added the json of the uploaded files. 

47AB2322-85BA-4329-8063-96785F6BCE72.png


below this, i created a condition since the file attachments are not mandatory. 

42D07965-3932-4E43-8B15-6A3A3CF17E3E.jpeg


then another condition follows to split actions for either clients or vendors. 

1A9E3333-E95D-44C2-A5D1-62DF26655BD9.png


and finally, I tried to append the uploaded files and the converted file but it says i entered an invalid json. 😞 i dont know what else to do…

192A7FA3-B422-4427-8BFA-47F4B19844D3.png

Hi @Friedmochii_92 ,

 

Try performing the Append to Array action in two steps, for example:

 

ekarim2020_0-1658735822909.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

Hi Ellis,

 

I followed your suggestion and it worked a bit but I keep getting other errors along the way. Either an array is null, or the contentbytes are not found even if I added the base64 expression around the file content. See snips below. 

D931ECBD-B995-4B91-9C9E-74DEC0C1A7DB.png

4C2B1BDC-7E87-4A92-8C2D-78F809C86CA6.png


Here I got the error where contentbytes were not found. 

CA5351F0-EB26-493C-AC8A-B43958E9E062.jpeg


and another error where the files could not be read as it was “corrupted”. 

2416EE0A-2ABE-4598-A85A-7EC6F9160CA1.jpeg

 

Many thanks for your help. 

 

HI @Friedmochii_92 ,

 

Could you please share the entire flow, with easy to see screenshots. I think I am missing the entire context.

 

For the Approval action, you should add a single variable as shown below: 

Snag_1d4949a.png

 

Note also the difference in format for the Approvals attachment array compared to attachments array when used in Outlook:

Snag_1d6544c.png

Ellis

Hi Ellis,

 

I've pasted the screenshots here from the top most to the part where my approval action is. Sorry if my screenshots aren't clear as my office laptop's screenshot feature is not that great. Hope this helps. Thank you.

 

Start of the FlowStart of the Flow

 

2nd part2nd part

 

3rd part - Gathering the files uploaded to MS forms3rd part - Gathering the files uploaded to MS forms

 

4th part - Values here are added to an HTML layout4th part - Values here are added to an HTML layout

 

5th part5th part6th part6th part

 

7th part - Approval action7th part - Approval action

Hi Ellis,

 

The flow works now with trial and error. Thank you for your help! 🙂

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,599)