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

File name extension not available

I have managed to get most of a test flow running. The intent is that whenever a new document is placed into a sharepoint library an approval request will automatically go to the individual's manager. If approved the document will be moved to another library.

 

I tried using some of the existing templates but didn't manage to find one that did it in the way I was expecting, so I built one. Everything works except that when the file is created in the second library the extension is not added. All I get is the file's name without the extension. I have used the properties only when file is created trigger and the get file content action.

 

Luigi

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
wnzn Advocate IV
Advocate IV

Re: File name extension not available

If you want to get the filename with extension, you can use Get File Metadata instead of Get File Properties. You can then use the output "Name". This works, but I find the whole experience needlessly complicated. Properties ought to be the same as Metadata, no?

View solution in original post

12 REPLIES 12
Dual Super User
Dual Super User

Re: File name extension not available

Are you using "get file properties"? If so, this thread explains how this could be done several months ago. I haven't tested it myself, so unsure if this method is still valid.

https://powerusers.microsoft.com/t5/Building-Flows/On-file-properties-modified-move-file-from-one-sh...

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



LuigiDiFilippo
Frequent Visitor

Re: File name extension not available

The solution they have identified does seem to work but is convoluted and overly complicated. There has to be a easier way to apply the file name, including the extension. If you use the trigger when file is created when file created in folder instead of p[roperties only then you get a file name with extension, but you don't get the ability to get the file creator's user info. I need the file creator's info.

Community Support
Community Support

Re: File name extension not available

Hi LuigiDiFilippo,

 

When testing with your scenario, I got the same issue with you. Using the trigger “When a file is created(properties only)”, the file created in second library doesn’t have the extension. I will help confirm this issue on my side and back to you later.


In your second post you said that you want to get the file creator’s user info. Do you have a column that will be used to save the creator in the second library?

 

Best regards,
Mabel Mao

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

Re: File name extension not available

The user info is in relation to the new file that is being placed into the sharepoint library. I then use that info to determine who the person's manager is iniorder to forward the approval correctly. If I were to use the other sharepoint trigger when a file is created, instead of the get properties only, it does not provide the creator user info. Although if I were to use the when file created trigger, the file name does include the extension.

 

I'm not sure if this is a bug or an intended feature.

Community Support
Community Support

Re: File name extension not available

Hi LuigiDiFilippo,

 

I have some updates for you.


Please add another action “SharePoint – Get file properties” before the action “Create file”. In the “Create file” action, select the dynamic content “File name” from the action “Get file properties” for the File Name field.


Please take the following screenshot for a reference.


I have tested it on my side, the file created in the second library has its extension and can be opened without issue.

3.PNG


Best regards,
Mabel Mao

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

Re: File name extension not available

Mabel,

 

Thanks for your help.

 

I did as you indicated but I don't see the FIleName dynamic atribute the only ones I have that carry any file naming info are: Identified and Name. What am I missing?

charafRef Advocate III
Advocate III

Re: File name extension not available

Community Support
Community Support

Re: File name extension not available

Hi @LuigiDiFilippo,

 

Could you show me a screenshot on it?


When configuring the action “Create file”, I can select the dynamic content “FileName” from the action “Get file properties”. Please check the following picture.

3.PNG

 

Please check it again on your side.

 

Best regards,
Mabel Mao

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

Re: File name extension not available

Here is the screen capture.

Screen Capture.png

charafRef Advocate III
Advocate III

Re: File name extension not available

Hi @v-yamao-msft , i have the same attributs without FileName like his screenshoot. I guest your filename it's our name attribut , but the issue still remains.

 

fll.JPG

 

Highlighted
wnzn Advocate IV
Advocate IV

Re: File name extension not available

If you want to get the filename with extension, you can use Get File Metadata instead of Get File Properties. You can then use the output "Name". This works, but I find the whole experience needlessly complicated. Properties ought to be the same as Metadata, no?

View solution in original post

charafRef Advocate III
Advocate III

Re: File name extension not available

On my case , the condition doesn't match together with the file metada ! 

Up ..

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,984)