Finance | Project Operations, Human Resources, ...

Format excel cell from powerautomate flow d365fo

(0) Share

Report

Posted on by Menna Allah Ahmed

163

I connected powerautomate to D365fo to create a recurrence flow (send mail by csv file to customer ), everything works well but there is something wrong on width of cell of csv file .

some rows displays well but another wrap text in enabled on it .

How can I fix it while sending this file by powerautomate ?

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

Format excel cell from powerautomate flow d365fo

Hi Menna,

Can you tell if the Excel file is created with help of X++ coding or is it created in your Power Automate flow? In case the latter, you can better use the Power Automate forum for your question.

If it is created with help of X++ coding, please share the coding so we can check how to help you.

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Format excel cell from powerautomate flow d365fo

Hi,
CSV files are typically in plain text format and do not inherently contain information about cell widths or wrapped text. Each row in the CSV file is considered a record, with each field separated by a comma or other delimiter. This can cause problems if line breaks are present in a field, as it can interfere with correct parsing of the table.
Before generating a CSV file, make sure the data does not contain extra line breaks or unnecessary characters.
Make sure that text fields in the CSV file use appropriate escape characters to handle text that contains delimiters or newlines. This is usually accomplished by adding quotes around the field.
Open the CSV file manually and make sure the data is displayed in the appropriate format. You can use a text editor (such as Notepad++) to view the file contents and make sure each field is in the appropriate position.
(BTW, in Power Automate, you can use the "Create HTML table" action to convert CSV data into an HTML table and embed it into the body of the email. This ensures that the data displays correctly as a table in the email.)
Best Regards,
Hana

Was this reply helpful? Yes No
Menna Allah Ahmed 163 on at

Like (0)

Report

Format excel cell from powerautomate flow d365fo

Hi Andre ,

no there is no code to create excel file its created from power automate flow

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

Format excel cell from powerautomate flow d365fo

Hi Menna,

Is the flow using an Excel connector and fill a predefined table in one of the sheets or are you using MSGraph to fill all details? In case you fill a table, the template can have a specific width and formatting. In case you want to change properties of cells, the MSGraph connector can be used, but is harder to understand and implement.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Format excel cell from powerautomate flow d365fo

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Format excel cell from powerautomate flow d365fo

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates