Power Platform Community Forum Thread Details

Apply to Each with case statement on email attachments

I'm using the "When a new email arrives (V3)" and the message I am wanting to process can have multiple attachments.

For each of the attachments, I need to do a series of steps, but those steps depend on the prefix of the attachments file name.

I have an "Apply to Each" based on the "attachments" for the connector and then a switch statement to get the first 3 characters of the attachment's name.

Everything to this point seems to be working correctly, but the problem is I'm so many layers nested the automatic options aren't triggering to help me form the correct expression for "file content" when I go to save the attachment to SharePoint using Create FIle instead I'm getting data such as...

{"@odata.type":"#microsoft.graph.fileAttachment","id":"AAMkADcwODk3OTBmLTk4Y2EtNDUxOS1iNWU0LTEyNDZmZWM2Mzc0MgBGAAAAAAD6JyfrZzSxS5vGXXDpttXxBwAc0YdqBVrfTLtJMHx5Ll7eAAAAAAEMAADf0RNVqkXSSJv2SkVpwL51AAUcKzqUAAABEgAQALy-j3E-fm9Fnl1c-IhJr_k=","lastModifiedDateTime":"2021-11-30T23:41:27+00:00","name":"Invoice-EA289D30-0030.pdf","contentType":"application/pdf","size":21212,"isInline":false,"contentId":"6F0E6AAF9.....","contentBytes":"JVBERi0xLjQKM""}

I'm sure I'm missing the correct syntax to use on File Content to pull the actual content instead of the overall blob.

Example of the flow...

Screenshot 2021-11-30 202706.png