I have the following problem: I would like to upload a .XLSX file into my workspace via an ActionFlow. The .XLSX file is located on SharePoint Online. I can download the file using the "Download a File" action (Microsoft SharePoint Online) in the ActionFlow. However, I'm stuck at that point. In the output, the data is in "binary" format. How do I convert it from binary back to something I can import into a workspace? I have tried many things, but I just can't find the solution. Does anyone have any advice?
+6Hi, I would suggest creating a support ticket by providing your environment details for further investigation.
Hi Michael.
Were you able to solve the issue? If you did could you leat me know what is the solution?
BR,
Magda
+26Hi
Did you try using the Excel Component for Action Flows? It seems it has more options to obtain data from an Excel file: https://docs.celonis.com/en/microsoft-365-excel--action-flow-.html.
I hope this helps!
hi,
Try converting binary code to text format using tostring function.
please refer to this link - String functions
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.