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

Notifications

Announcements

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 

    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.

  • 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 

    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

    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 

     

    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))))

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 211 Most Valuable Professional

#3
trice602 Profile Picture

trice602 198 Super User 2025 Season 2

Last 30 days Overall leaderboard