Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 343
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... 291,280 Super User 2024 Season 2 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 343 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... 291,280 Super User 2024 Season 2 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans