Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Format excel cell from...
Finance | Project Operations, Human Resources, ...
Suggested answer

Format excel cell from powerautomate flow d365fo

(0) ShareShare
ReportReport
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 ?
//
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,892 Super User 2025 Season 1 on at
    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. 
  • Menna Allah Ahmed Profile Picture
    Menna Allah Ahmed 163 on at
    Format excel cell from powerautomate flow d365fo
    Hi Andre , 
    no there is no code to create excel file its created from power automate flow
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,892 Super User 2025 Season 1 on at
    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,892 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,772 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans