web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : ACYJJlpqc1lPqzxXH8q6zM
Power Automate - Building Flows
Suggested answer

Add row into a table action ignoring "dot" character

Like (1) ShareShare
ReportReport
Posted on 16 Jul 2024 21:32:22 by 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!

I have the same question (0)
  • Suggested answer
    faschimi Profile Picture
    60 on 23 Jul 2024 at 15:56:16
    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
    on 23 Jul 2024 at 07:05:15
    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
    47,320 Super User 2025 Season 2 on 23 Jul 2024 at 00:04:11
    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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started
Loading complete