cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
Highlighted
Dual Super User III
Dual Super User III

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!



Highlighted
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.

Highlighted
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.
Highlighted
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.

Highlighted
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.
Highlighted
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?

Highlighted
Advocate III
Advocate III

Re: File name extension not available

Highlighted
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.
Highlighted
Frequent Visitor

Re: File name extension not available

Here is the screen capture.

Screen Capture.png

Highlighted
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
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

Highlighted
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
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Users online (4,190)