SOLVED

Extract URL from file upload question in Flow from Microsoft form

%3CLINGO-SUB%20id%3D%22lingo-sub-1124689%22%20slang%3D%22en-US%22%3EExtract%20URL%20from%20file%20upload%20question%20in%20Flow%20from%20Microsoft%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124689%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20MS%20flow%20approval%20workflow%20for%20a%20form%20and%20I%20am%20using%20the%20new%20file%20upload%20feature.%20I'm%20trying%20to%20get%20the%20URL%20path%20to%20files%20to%20display%20correctly%20when%20sent%20in%20the%20email%20body%20using%20flow.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20inputting%20the%20dynamic%20expression%20for%20the%20file%20upload%20returns%20something%20like%20the%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%3CSPAN%3E%5B%7B%22name%22%3A%22file_name_uploader%20name.pdf%22%2C%22link%22%3A%22%3CA%20href%3D%22https%3A%2F%2Fmssoc-my.sharepoint.com%2Fpersonal%2Fbola_labulo_mssociety_org_uk%2FDocuments%2FApps%2FMicrosoft%2520Forms%2FMSS%2520New%2520Supplier%2520Form%2FQuestion%2FI51703_131219_9_NGMCLON_Mediacom_Ann%2520McDougal.pdf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fsite-my.sharepoint.com%2Fpersonal%2Fuser_domain_org_uk%2FDocuments%2FApps%2FMicrosoft%2520Forms%2Fform%25name%2FQuestion%2Ffile_name_uploader%2520name.pdf%3C%2FA%3E%22%2C%22id%22%3A%2201SRUKHVHWF2EPTNWXGRFJG2OJLGWEP4U3%22%2C%22type%22%3Anull%2C%22size%22%3A53051%2C%22referenceId%22%3A%2201SRUKHVHVSSRUV4ZAEVC32ET433VDJFEI%22%2C%22driveId%22%3A%22b!fIPurN8Gv0KRaCyuRrHjC9jY71Bph9dEih0_Lpx16CbadVWIm1v3SYdD_VMzYe5M%22%2C%22status%22%3A1%2C%22uploadSessionUrl%22%3Anull%7D%5D%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20an%20Azure%20logic%20expression%20or%20another%20way%20to%20extract%20just%20the%20link%20to%20the%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1124689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1125975%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20URL%20from%20file%20upload%20question%20in%20Flow%20from%20Microsoft%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125975%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303283%22%20target%3D%22_blank%22%3E%40BolaMSS%3C%2FA%3E%26nbsp%3B%20the%20blog%20post%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.bythedevs.com%2Fpost%2Fworking-with-files-on-ms-forms-in-ms-power-automate%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.bythedevs.com%2Fpost%2Fworking-with-files-on-ms-forms-in-ms-power-automate%3C%2FA%3E%26nbsp%3Bshows%20you%20how%20to%20parse%20the%20JSON%20and%20get%20the%20url.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130799%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20URL%20from%20file%20upload%20question%20in%20Flow%20from%20Microsoft%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130799%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an MS flow approval workflow for a form and I am using the new file upload feature. I'm trying to get the URL path to files to display correctly when sent in the email body using flow. 

 

At the moment inputting the dynamic expression for the file upload returns something like the below

 

[{"name":"file_name_uploader name.pdf","link":"https://site-my.sharepoint.com/personal/user_domain_org_uk/Documents/Apps/Microsoft%20Forms/form%nam...","id":"01SRUKHVHWF2EPTNWXGRFJG2OJLGWEP4U3","type":null,"size":53051,"referenceId":"01SRUKHVHVSSRUV4ZAEVC32ET433VDJFEI","driveId":"b!fIPurN8Gv0KRaCyuRrHjC9jY71Bph9dEih0_Lpx16CbadVWIm1v3SYdD_VMzYe5M","status":1,"uploadSessionUrl":null}]

 

Is there an Azure logic expression or another way to extract just the link to the file?

 

Thanks

2 Replies
Best Response confirmed by BolaMSS (New Contributor)
Solution

@BolaMSS  the blog post at https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate shows you how to parse the JSON and get the url.

 

Rob
Los Gallardos

Microsoft Power Automate Community Super User