Trouble with template text when updating file properties in flow

%3CLINGO-SUB%20id%3D%22lingo-sub-790657%22%20slang%3D%22en-US%22%3ETrouble%20with%20template%20text%20when%20updating%20file%20properties%20in%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790657%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%20I%20am%20hoping%20for%20some%20help%20with%20the%20following%20flow%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125766i6D93F4DBA8A6F4EC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EMy%20flow%20tests%20good%20and%20it%20does%20do%20what%20I%20want.%20The%20problem%20is%20when%20I%20open%20the%20file%2C%20in%20the%20document%20property%20fields%20that%20have%20info%20from%20a%20document%20from%20a%20Sharepoint%20list%20filled%20in%20there%20is%20a%20bunch%20of%20code%20around%20it%20as%20well%20(see%20the%204th%20entry).%3C%2FP%3E%3CP%3EAny%20fields%20that%20are%20single-line%20text%20in%20the%20column%20properties%20are%20fine.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125768i5276D3A621B768D0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20muchly%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAlternatively%2C%20if%20there%20is%20an%20easier%20way%20to%20get%20some%20of%20the%20fields%20from%20a%20Microsoft%20form%20to%20automatically%20populate%20a%20template%2C%20I%20would%20be%20totally%20open%20to%20doing%20this%20a%20different%20way!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again!%26nbsp%3B%3C%2FP%3E%3CP%3ES.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-790657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790785%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20template%20text%20when%20updating%20file%20properties%20in%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790785%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388125%22%20target%3D%22_blank%22%3E%40Selbyq%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%26nbsp%3B%3CSTRONG%3EHtml%20to%20text%3C%2FSTRONG%3Eaction%20to%20remove%20the%20HTML%20tags.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125776iE408EA3EF9421E28%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125777i1423C5A9829A6E19%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture1.PNG%22%20title%3D%22Capture1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETurns%20to%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125778iDE00A4C5EC891632%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%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello all, I am hoping for some help with the following flow:

clipboard_image_0.png

My flow tests good and it does do what I want. The problem is when I open the file, in the document property fields that have info from a document from a Sharepoint list filled in there is a bunch of code around it as well (see the 4th entry).

Any fields that are single-line text in the column properties are fine. 

 

clipboard_image_1.png

 

Any help is muchly appreciated! 


Alternatively, if there is an easier way to get some of the fields from a Microsoft form to automatically populate a template, I would be totally open to doing this a different way! 

 

Thanks again! 

S. 

1 Reply
Highlighted

Hi @Selbyq,

 

Use the Html to text action to remove the HTML tags.

Capture.PNG

 

This:

Capture1.PNG

 

Turns to this:

Capture2.PNG

 

I hope this helps.

 

Norm