Invoice Number Disappear from the output

Hi Community,

Currently i have build the workflow and it give me different result. However, the details of invoice had been truncated and it is different as per the original one in the workflow. Below is the screenshot from the workflow.

However, it is being truncated when we rendered in the excel file. For example , the first row of the screenshot above will show 0004686 and the last number which is 2 had been truncated.

May i know if anyone has the experience before and how we going to fix this error? I had put the format below for the invoice column.

many thanks for your help.

Common Use Cases

Accepted answers

pedrodrfaria

Hi @SH_94

Use the below WF to understand how to output to a single excel files with multiple sheets:

multiple excel sheets in one excel file from different workflows.yxmd

All comments

Emil_Kos

Hi @SH_94,

Does your invoice number contain any letters? If not maybe you can change it to double and check if this issue still occurs.

SH_94

Hi @Emil_Kos ,

Yes, there are letters under this column. I am trying to adjust the size of table before generating the output.

Secondly, may i know how can i render out the table so that it able to produce different table in multiple tab under one excel file. Below is my current workflow and would like to know how to proceed from there.

Thank you.

pedrodrfaria

Hi @SH_94

Use the below WF to understand how to output to a single excel files with multiple sheets:

multiple excel sheets in one excel file from different workflows.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167