cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Extract first 6 characters of attachment name in document library and place in new field

Hi All,

 

I have a quick flow that gets the attachment properties and applies the a partial name only to a new Field called "Document Number".

 

example attachment names:

"123456 Finance Procedure.docx"

"987654 Human Resources.docx"

 

Example results once the flow runs

Document Number (Field):

123456 Finance Procedure

987654 Human Resources

 

I need the field to display just the first 6 characters of the file name. As example:

Document Number (Field):

123456

987654

 

I've tried the LEFT function but, could work it out.

 

If you could provide an example that would be great.

 

thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Use the substring expression, example:

substring(outputs('Document_Number'),0, 6)

 Substring.PNG

 

Please...

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

View solution in original post

2 REPLIES 2
Highlighted
Memorable Member
Memorable Member

Use the substring expression, example:

substring(outputs('Document_Number'),0, 6)

 Substring.PNG

 

Please...

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

View solution in original post

Highlighted

luke5_0-1603974452518.png

Here is the flow I used, the "Outputs" in the "Document Number" field comes from the "Compose 2".

 

Much appreciated !

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Kudoed Authors
Users online (7,777)