Excel Sheet Issues in Gmail to FTP flow

(0) Share

Report

Posted on by jlw

Hello,

I have been having issues with getting an excel to work with the Gmail to FTP workflow. Essentially, the workflow accesses my gmail for any file ending with "xlxs" and then creates a file and sends to a directory on my server.

However, for some reason, the data in the excel sheet is being corrupted somewhere within the flow. I have had no issues with any CSV files becoming corrupted.

When I download the file from my gmail before the flow accesses it, there is nothing wrong with the file and it is in a normal, noncorrupted format. I think that the data becomes corrupted either when the gmail trigger accesses the attachment or when the attachment's data is gathered and a file is created by the FTP action and sent to my server.

Any help would be much appreciated. Attached are some pictures of my flow that I hope will be helpful.

Thanks in advance!

Create File and Send via FTPGmail TriggerCondition

All responses (1)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Re: Excel Sheet Issues in Gmail to FTP flow

Hi @jlw ,

From the screenshot, it seems that you are using dynamic content “Attachments Name” for the File field of action Update file.

According to the doc on connector FTP Server, the File field requires either a file name you select from the Browse file button or a unique Id for the file you may get from the previous FTP related triggers/actions.

https://docs.microsoft.com/en-us/connectors/ftp/

Please take a try with the following workaround.

Before the action Update file, add an action List files in folder. Then add a Condition to check if the attachment has a common name with the files in the folder. If Yes, update the file with the corresponding dynamic content Id for the File field from the action List files in folder.

Best regards,

Mabel