cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Placing folder instead of a file name name in the body of a face sheet for faxing

20190320_114719.jpg

I have modified the following template to send a email fax to a specific recipient when a file is dropped into a OneDrive folder.  I would like the name of the folder to be inserted at a specific point on the cover page of that fax. Example Dear Mr. "name of folder here" thank you for sending this client to us.......

I am having trouble finding the right method to get only the name of the folder and not the name of the individual file to be placed in that particular spot on the cover page.

I also am having trouble with the formatting of the text in the subject section of the document as well. It tends to smash all of the words together as opposed to following the wysiwyg formatting.

 

An alternative approach would be to insert a customized fax page with my watermark on it that would have the same message and insert all the necessary information on that cover page with the ability to add a date of service or date of creation from each document. Example of what is not working now.  Any thoughts?

example.jpg

 

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Placing folder instead of a file name name in the body of a face sheet for faxing

Hi @drlea12 ,

 

It is recommended to use When a file is created (properties only) as the trigger.

Then you could use the following expression to get the name of the folder.

split(triggerBody()?['Path'],'/')[sub(length(split(triggerBody()?['Path'],'/')),2)]

3.PNG

As for the adjustments you mentioned in the Subject field, I am afraid it is currently difficult to implement, and it seems that only some basic text can be filled.

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,583)