Home

Creation of Forms (for Excel) in SharePoint document library generate double file extensions?!

%3CLINGO-SUB%20id%3D%22lingo-sub-485944%22%20slang%3D%22en-US%22%3ECreation%20of%20Forms%20(for%20Excel)%20in%20SharePoint%20document%20library%20generate%20double%20file%20extensions%3F!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485944%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20one%20is%20really%20getting%20on%20my%20nerves...%20When%20I%20create%20a%20new%20Forms%20for%20Excel%20object%20in%20a%20SharePoint%20document%20library%2C%20I%20am%20prompted%20for%20the%20name%20of%20the%20file%2C%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110617iDF6D14E43D1DB092%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20fine%2C%20but%20when%20I%20click%20Save%2C%20the%20actual%20filename%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20246px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110618i26867A7CEC2BADFB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture2.PNG%22%20title%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESee%20my%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20thought%20to%20myself%2C%20aha!%20I%20can%20create%20the%20form%20from%20Microsoft%20forms%20instead!%20So%20I%20tried%20this%20and%20guess%20what%3F%20My%20newly%20created%20form%20generates%20an%20excel%20file%20in%20my%20SharePoint%20document%20library%20with%20the%20name%20Untitled%20form.xslx...%20And%20if%20a%20make%20another%20form%20the%20a%20filename%20is%20Untitled%20form%201.xslx%20and%20so%20on...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20don%C2%B4t%20want%20to%20tell%20my%20customer%20that%20they%20need%20to%20rename%20each%20and%20every%20file%20generated%20when%20they%20create%20forms.%20Any%20ideas%20here%20on%20how%20to%20work%20around%20this%20issue%3F%20Can%20I%20change%20the%20name%20of%20the%20file%20with%20Flow%20somehow%3F%20Right%20now%20this%20it%20is%20not%20usable%20if%20you%20have%20a%20more%20than%20one%20form%2C%20because%20you%20cannot%20see%20which%20Excel%20file%20that%20belongs%20to%20which%20form...%20Help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2FMaggan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-485944%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486625%22%20slang%3D%22en-US%22%3ERe%3A%20Creation%20of%20Forms%20(for%20Excel)%20in%20SharePoint%20document%20library%20generate%20double%20file%20extensions%3F!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55998%22%20target%3D%22_blank%22%3E%40Maggan%20W%C3%A5hlin%3C%2FA%3E%26nbsp%3BI%20just%20tried%20to%20re-create%20this%20problem%20on%20my%20One-Drive%20using%20the%20Forms%20for%20Excel%20button%20and%20didn't%20see%20the%20doubling%20of%20the%20XLSX%20extension%20there.%20Do%20you%20get%20the%20same%20behavior%20in%20OneDrive%3F%20For%20some%20reason%20We%20don't%20appear%20to%20have%20this%20preview%20enabled%20in%20our%20SharePoint%20Online%20instance.%20I'll%20look%20around%20and%20see%20if%20I%20can%20recreate%20on%20my%20development%20tenant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20the%20issue%20is%20specific%20to%20the%20language%20that%20the%20Forms%20for%20excel%20feature%20is%20being%20used%20in%3F%20En-US%20locality%20on%20my%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdate%20-%20couldn't%20get%20the%20option%20to%20move%20up%20within%20the%20selection%20list%20on%20the%20library...%20so%20that's%20some%20additional%20weirdness%20that%20I'm%20seeing.%20I%20can't%20get%20the%20button%20to%20show%20in%20SharePoint%20Online%2C%20even%20in%20my%20dev%20tenant.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486850%22%20slang%3D%22en-US%22%3ERe%3A%20Creation%20of%20Forms%20(for%20Excel)%20in%20SharePoint%20document%20library%20generate%20double%20file%20extensions%3F!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55998%22%20target%3D%22_blank%22%3E%40Maggan%20W%C3%A5hlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20replicate%20the%20issue%20that%20you%20are%20facing%20and%20was%20able%20to%20create%20form%20for%20excel%20without%20any%20challenges....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20try%20to%20create%20the%20form%20in%20a%20different%20browser...%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490430%22%20slang%3D%22en-US%22%3ERe%3A%20Creation%20of%20Forms%20(for%20Excel)%20in%20SharePoint%20document%20library%20generate%20double%20file%20extensions%3F!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490430%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F165275%22%20target%3D%22_blank%22%3E%40Robin%20Nishad%3C%2FA%3E%26nbsp%3BYes%2C%20I%20have%20tried%20different%20browsers%20-%20does%20not%20work.%20I%20also%20tried%20the%20same%20in%20a%20site%20with%20English%20locale%2C%20but%20it%20still%20does%20not%20work.%20I%20guess%20this%20is%20a%20bug%2C%20hopefully%20Microsoft%20is%20aware.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-499066%22%20slang%3D%22en-US%22%3ERe%3A%20Creation%20of%20Forms%20(for%20Excel)%20in%20SharePoint%20document%20library%20generate%20double%20file%20extensions%3F!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-499066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55998%22%20target%3D%22_blank%22%3E%40Maggan%20W%C3%A5hlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20if%20there%20are%20any%20advisory%20or%20Incidents%20showing%20on%20your%20tenant%20in%20Service%20Health...%20if%20not%20would%20suggest%20to%20open%20a%20case%20with%20MS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Hi guys!

 

This one is really getting on my nerves... When I create a new Forms for Excel object in a SharePoint document library, I am prompted for the name of the file, like this: 

Capture.PNG

This is fine, but when I click Save, the actual filename looks like this:

Capture2.PNG

See my issue?

 

So I thought to myself, aha! I can create the form from Microsoft forms instead! So I tried this and guess what? My newly created form generates an excel file in my SharePoint document library with the name Untitled form.xslx... And if a make another form the a filename is Untitled form 1.xslx and so on...

 

I really don´t want to tell my customer that they need to rename each and every file generated when they create forms. Any ideas here on how to work around this issue? Can I change the name of the file with Flow somehow? Right now this it is not usable if you have a more than one form, because you cannot see which Excel file that belongs to which form... Help?

 

/Maggan

 

 

4 Replies

@Maggan Wåhlin I just tried to re-create this problem on my One-Drive using the Forms for Excel button and didn't see the doubling of the XLSX extension there. Do you get the same behavior in OneDrive? For some reason We don't appear to have this preview enabled in our SharePoint Online instance. I'll look around and see if I can recreate on my development tenant.

 

Maybe the issue is specific to the language that the Forms for excel feature is being used in? En-US locality on my end.

 

Update - couldn't get the option to move up within the selection list on the library... so that's some additional weirdness that I'm seeing. I can't get the button to show in SharePoint Online, even in my dev tenant.

@Maggan Wåhlin 

 

I tried to replicate the issue that you are facing and was able to create form for excel without any challenges....

 

Did you try to create the form in a different browser...?

@Robin Nishad Yes, I have tried different browsers - does not work. I also tried the same in a site with English locale, but it still does not work. I guess this is a bug, hopefully Microsoft is aware.

@Maggan Wåhlin 

 

Check if there are any advisory or Incidents showing on your tenant in Service Health... if not would suggest to open a case with MS.

 

Thanks

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies