Good morning!
I am a very new Power Automate user attempting to do something (seemingly) simple:
Notify a user via Teams when an inbound email attachment (.csv) contains a specific string.
The general function of the Flow is working as-intended except for the condition that the whole thing depends on. I am able to use Get Attachment (V2) to get the appropriate attachment content via Content Bytes, and I can successfully Create File via SFTP or SharePoint. I can not, however, use the CONTAINS operator in a condition to read the contents of the CSV. Looking at the relevant output from a step shows me data that looks like this:
"contentBytes":"VQBzAGUAcgAgAEkAZAAsAFMAdABhAHQAdQBzACwAUgBlAGMAbwByAGQAIABTAHkAbgBjACAAVAB5AHAAZQAsAE8AcgBpAGcAaQBuAGEAbAAgAFMAeQBuAGMAIABEAGEAdABlACwATwByAGkAZwBpAG4AYQBsACAAUgBlAHEAdQBlAHMAdAAgAEkARAAsAE0AZQBzAHMAYQBnAGUADQAKADEAMAAwADEANgAsAFUAcABkAGEAdABlAGQALAAsACwALAANAAoAMQAwADAAMAAxACwAVQBwAGQAYQB0AGUAZAAsACwALAAsAA0ACgAxADAAMwAzADYALABVAHAAZABhAHQAZQBkACwALAAsACwADQAKADEAMAAyADYANQAsAFUAcABkAGEAdABlAGQALAAsACwALAANAAoAMQAwADIANwA5ACwAVQBwAGQAYQB0AGUAZAAsACwALAAsAA0ACgAxADAAMwA3ADQALABVAHAAZABhAHQAZQBkACwALAAsACwADQAKADEAMAA0ADUA
In case it needs to be stated, this is not what the actual content of the file looks like in CSV format. I was expecting my data to look something like this:
This leads me to believe there is some sort of conversion or transformation that needs to occur before I can read the data in a condition. If anyone is familiar with whatever format the contentBytes data seems to be in and how I can access my 'real' CSV data in a condition, I would be forever grateful.
Thank you!
