web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Jotform image saved to...
Power Automate
Unanswered

Jotform image saved to OneDrive - how to view in Powerapp?

(0) ShareShare
ReportReport
Posted on by 117

I upload an image through a JotForm and the Flow successfully saves this to a Sharepoint List and OneDrive Folder.  When I look at the record in Sharepoint it shows HTML like - <a href=\"https://www.jotform.com/uploads/itman/220052982523855/5248276710367839192/Photo Resizer 2021_09_09_02_01_48.jpg\" target=\"_blank\" title=\"Photo Resizer 2021_09_09_02_01_48.jpg\">Photo Resizer 2021_09_09_02_01_48.jpg</a>"'

I want my PowerApp Gallery to show the image in OneDrive.  Is this possible?

Many Thanks

 

Categories:
I have the same question (0)
  • takolota1 Profile Picture
    4,978 Moderator on at

    @jms345 

     

    Is it in a hyperlink column or something like a multi line text column with rich text?

     

    You can try using methods from this article: https://www.spguides.com/power-apps-image-control/#PowerApps_image_from_url

     

    If the 

    Image = ThisItem.'Image Column Name’

    doesn’t immediately work because of the extra text, you can try

    image = Last(FirstN(Split(ThisItem.'Image Column Name’, ‘“‘), 2)))


    Formula explanation: https://sharepains.com/2020/03/31/get-1-item-in-an-array-in-power-apps/amp/

     

    However, it also looks like your example may have a space in the url. If that is the case, then you may need to include an encodeurl to the formula

    https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-encode-decode

    So

    EncodeURL(Last(FirstN(Split(ThisItem.'Image Column Name’, ‘“‘), 2))))

  • jms345 Profile Picture
    117 on at

    Many thanks for your advice.  Unfortunately it's more complicated; the URL in the form points to JOTFORMS, but I have already used Integration to upload the file to a OneDrive Folder.  I have created a button on the form that opens the correct folder in OneDrive, so I know the location of the folder.  However, I would like the specific attachment in that folder (i.e. either jpg or pdf) to be linked to the form data field.  Incidentally when I copy the jotforms URL and paste into a browser, pdf's automatically download but jpg's are NOT FOUND.  All are available in ONE DRIVE.  Thanks again. 

  • takolota1 Profile Picture
    4,978 Moderator on at

    @jms345 

    Are these single or possibly multiple attachments?

    If the jpgs are not downloading in your browser, then how are you getting them to OneDrive, which should be relying on the same url to upload the image in the flow?
    (If you are pulling from the automated JotForm confirmation email, and you do not need the pictures until maybe 20-40 minutes after submission, then I definitely suggest working with the OneDrive url upload instead. JotForm just often has a delay in loading their documents to those urls, so you have to adjust the retry settings on the OneDrive URL action to include more retries & longer intervals.)
    Incidentally, if you want a simpler set-up, you should be able to...
    -Upload the image by the OneDrive url action,

    -Use a OneDrive Get contents action to get the image file,

    -Delete the OneDrive file that was uploaded,
    -Then use the image file contents from the OneDrive Get contents action in a SharePoint Add attachment action or SharePoint Create file action to add the image to SharePoint (If you Add attachment then it can be immediately associated with your SharePoint item in a gallery, if you Create file in a separate folder, then you'll need to use naming conventions in the flow to create a pattern in the URL that you can recreate using the associated SharePoint record's values)

  • jms345 Profile Picture
    117 on at
    Wow, that is very helpful information.  I will investigate how my jotform integration is uploading to OneDrive, but the actual uploads in the form are linking to a jotform url.  When I use Powerautomate the uploads show jotform url's.
    Thanks for sharing your expertise.
  • takolota1 Profile Picture
    4,978 Moderator on at

    @jms345 

    Thanks, I spent so many weeks building application systems & case management JotForms at my last job & connecting them to SharePoint or Excel with Power Automate.
    When I saw your post I thought I'm probably the best fit for this question on the entire forum lol.

    For the JotForm URLs in the Power Automate OneDrive action, you should be able to figure out the pattern of the document URLs, then use the Form Id & Submission Id to generate a URL in the flow that dynamically matches the desired document URL for each submission.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard