SOLVED

Script to change column in Excel from Custom to General

%3CLINGO-SUB%20id%3D%22lingo-sub-1620842%22%20slang%3D%22en-US%22%3EScript%20to%20change%20column%20in%20Excel%20from%20Custom%20to%20General%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620842%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20scenario%20is%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20document%20that%20automatically%20goes%20from%20a%20shared%20mailbox%20to%20into%20a%20SharePoint%20site.%20Once%20it%20hits%20the%20sharepoint%20site%2C%20I%20need%20to%20run%20a%20script%20(flow%2Fpowerautomate)%20that%20changes%20just%20one%20COLUMN%20in%20the%20spreadsheet%20from%20Custom%20to%20General%20before%20it%20continues%20through%20the%20flow.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20an%20action%20that%20I%20can%20use%20called%20%22Excel%20Online%20Business%22%20%22Run%20Script%22.%20This%20is%20the%20action%20that%20i%20would%20like%20to%20trigger%20the%20script.%20But%2C%20I%20can't%20find%20anything%20online%20to%20help%20me%20do%20that.%20Can%20anyone%20assist%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJamie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1620842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620883%22%20slang%3D%22en-US%22%3ERe%3A%20Script%20to%20change%20column%20in%20Excel%20from%20Custom%20to%20General%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F182549%22%20target%3D%22_blank%22%3E%40Jamie%20Johnson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Jamie%2C%3C%2FP%3E%0A%3CP%3EFirst%20you%20have%20to%20generate%20and%20record%20Office%20Script%20in%20Excel%20Online.%20Open%20Excel%20Online%2C%20not%20necessary%20to%20code%2C%20in%20Automate%20you%20may%20record%20the%20script%20and%20save%20it.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20soon%20as%20script%20is%20saved%20you%20may%20use%20it%20in%20Flow%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215379iB6F1057BB22B334A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620896%22%20slang%3D%22en-US%22%3ERe%3A%20Script%20to%20change%20column%20in%20Excel%20from%20Custom%20to%20General%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620896%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%20thank%20you%20for%20the%20quick%20response.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk.%20I%20will%20give%20this%20a%20try.%20I%20think%20this%20will%20work!%20Thanks%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620898%22%20slang%3D%22en-US%22%3ERe%3A%20Script%20to%20change%20column%20in%20Excel%20from%20Custom%20to%20General%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F182549%22%20target%3D%22_blank%22%3E%40Jamie%20Johnson%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good afternoon,

 

My scenario is this:

 

I have a document that automatically goes from a shared mailbox to into a SharePoint site. Once it hits the sharepoint site, I need to run a script (flow/powerautomate) that changes just one COLUMN in the spreadsheet from Custom to General before it continues through the flow. Is this possible?

 

There is an action that I can use called "Excel Online Business" "Run Script". This is the action that i would like to trigger the script. But, I can't find anything online to help me do that. Can anyone assist?

 

Jamie

3 Replies
best response confirmed by Jamie Johnson (New Contributor)
Solution

@Jamie Johnson 

Hi Jamie,

First you have to generate and record Office Script in Excel Online. Open Excel Online, not necessary to code, in Automate you may record the script and save it. 

 

As soon as script is saved you may use it in Flow

image.png

 

@Sergei Baklan, thank you for the quick response. 

 

Ok. I will give this a try. I think this will work! Thanks again.