I'm guessing it's the latter (the approval is in Teams, but no attachment). This has been a "known issue" that Microsoft has been "working on" for nearly 2 years. See powerusers.microsoft.com/t5/Building-Flows/Approval-Attachments-not-Showing-in-Teams/td-p/826112 For now, I'd suggest adding a link to the file(s), either in the "Details" of the approval or using the "Item link" field. If the file is somewhere the approver doesn't have permissions, you can create a sharing link to it.
Hi thank you Chad! Would you mind explaining/sharing the Parse JSON to convert the response data from the file upload question into a JSON Array? For some reason, the output is not a good input for the "Get file metadata" action, it cannot find the file.
@@cvkealey Thank you so much! I get different outputs from this JSON schema, which one did you use for input for get file metadata? Body id? Body referenceId? Body driveId?
It depends on whether it's a personal or group form. See ruclips.net/video/GemNJYq2gvw/видео.html and ruclips.net/video/7KpJP8hNKvE/видео.html for details.
What if the attachment file is optional, it will produce an error if the user doesn't submit any attachments. Any workaround solution? I discovered that you need to make conditions, but then it will need two flow 😅😅
Sure, you just need to be sure to use the appropriate format for the attachments. If you want to include the attachments in both the approval and the follow-up email, I would recommend creating two array variables (example: "varApprovalAttachments" and "varEmailAttachments"), populating each with the relevant information.
@@cvkealey Hi Chad thank you we got the attachments to work. We now have another issue where our email that pulls dynamic content from an excel does not pull cells that contain formulas. The flow succeeds but the email body contains all of the values except leaves a blank for where the formulated values should be. Is this something you can help with? We are so close to having this flow work!!
Brilliant Chad, driving me nuts why approvals wouldn't attach :)
Great!!! you saved my day :)
💯 This has been driving me nuts, Thank you!!!!!
There are lots of odd little inconsistencies like this in Power Automate. It keeps life interesting (and often aggravating).
Many thanks Chad !
Excelente dica! Me ajudou no que eu estava precisando. Muito obrigado!!
This guy is legend
Funiconou, Muito obrigado!
🇧🇷
This is great. Thanks Chad. Was hung up on this step for a while!
Hmm...Well I got the attachments in the approval email, but its not showing up in the approval section in MS teams. Thoughts?
The approval isn't showing up in the Approvals app in teams? Or, the approval is there, but not the attachments?
I'm guessing it's the latter (the approval is in Teams, but no attachment). This has been a "known issue" that Microsoft has been "working on" for nearly 2 years. See powerusers.microsoft.com/t5/Building-Flows/Approval-Attachments-not-Showing-in-Teams/td-p/826112
For now, I'd suggest adding a link to the file(s), either in the "Details" of the approval or using the "Item link" field. If the file is somewhere the approver doesn't have permissions, you can create a sharing link to it.
@@cvkealey The approval is there in the MS teams app, but not the attachments.
@@cvkealey It shows up in the approval email so I'll take that as a win! Thanks again!
Excellent hint, thanks a lot for your video. 👍
Thank you so much! you saved my day!!!
Glad I could help!
Hi thank you Chad! Would you mind explaining/sharing the Parse JSON to convert the response data from the file upload question into a JSON Array? For some reason, the output is not a good input for the "Get file metadata" action, it cannot find the file.
Sure, see this video: ruclips.net/video/OaB2stc6ThM/видео.html
@@cvkealey Thank you so much! I get different outputs from this JSON schema, which one did you use for input for get file metadata? Body id? Body referenceId? Body driveId?
It depends on whether it's a personal or group form. See ruclips.net/video/GemNJYq2gvw/видео.html and ruclips.net/video/7KpJP8hNKvE/видео.html for details.
I don't have attachment option in the create approval action
It's under advanced options
Hi chad. the output is "fileName"_"NameOfFormCreator", is there a way to remove the underscore and the Name of the Creator? thanks
Yup...see ruclips.net/video/PRwUn0aZysM/видео.htmlsi=4hxyfBn-ZyRlVmOG
What if the attachment file is optional, it will produce an error if the user doesn't submit any attachments. Any workaround solution? I discovered that you need to make conditions, but then it will need two flow 😅😅
See ruclips.net/video/jBTmX0cm6NU/видео.html
Can you send an email with form attachments after an approval?
Sure, you just need to be sure to use the appropriate format for the attachments. If you want to include the attachments in both the approval and the follow-up email, I would recommend creating two array variables (example: "varApprovalAttachments" and "varEmailAttachments"), populating each with the relevant information.
@@cvkealey Hi Chad thank you we got the attachments to work. We now have another issue where our email that pulls dynamic content from an excel does not pull cells that contain formulas. The flow succeeds but the email body contains all of the values except leaves a blank for where the formulated values should be. Is this something you can help with? We are so close to having this flow work!!
Honestly, I don't work a lot with reading data from Excel in Power Automate. I would recommend posting a message in the Power Automate community.