Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Add row into a table a...
Power Automate - Building Flows
Suggested answer

Add row into a table action ignoring "dot" character

(1) ShareShare
ReportReport
Posted on by faschimi 60

I've built a flow that reads the properties of a Sharepoint document library and exports all the data to an excel file.

 

There is a title field in this library which may contain a dot (.) in the string in some records. The string is correctly read through the "Get files (properties only)" action, but when the row is created in the excel file, the field content is truncated at the position of the dot.

Example of records with a dot in the title in the document library:

faschimi_1-1721164753999.png


How the information is being recorded in excel:

faschimi_2-1721164837563.png

 

I'm using the raw data from the previous step (in this case, Get files (properties only) action), is it necessary to use some function to treat the data and prevent truncation at the dot position?

faschimi_3-1721165248064.png

Thanks!

  • Suggested answer
    faschimi Profile Picture
    faschimi 60 on at
    Add row into a table action ignoring "dot" character
    I managed to solve this by changing to the {Title} property instead of {Name}. I don't remember exactly why I selected {Name} on the first try, but with {Title} the entire string is written correctly in Excel. Thanks @SheelanB and @FLMike for the insights.
  • SheelanB Profile Picture
    SheelanB on at
    Add row into a table action ignoring "dot" character
    You could use the property {FilenameWithExtension} instead of {Name}, unless that was something you wanted to avoid. I am assuming it is being truncated beacuse it is assuming the rest of the File name is part of the extension. But this could be an alternative option
  • Michael E. Gernaey Profile Picture
    Michael E. Gernaey 43,442 Super User 2025 Season 1 on at
    Add row into a table action ignoring "dot" character
    Silly question,
     
    If you click on the row in Excel, is that really all the data that is in it, or is there data below it (that you just can't see as if its carriage returned???)
     
    No. I am not aware of a reason why it would remove the rest of the string.
     
    If you (just for checking), did a replace on any  . and make it an _ does it write it correctly now?
     

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans