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 Apps / Upload image to Sharep...
Power Apps
Answered

Upload image to Sharepoint List from Powerapps

(0) ShareShare
ReportReport
Posted on by

There is SharePoint List with Item Id (Data type-Text), cost(Data type-Number) , Image (Data type-Picture )and status(Data type- Text) columns.  I have saved the images in cloud and entered the image's URL in the list manually. From PowerApps ,I'm able to display the records in Gallery and Forms along with their images.

 

The requirement is I should be able to add new records to the list from PowerApps. And users will not capture images with camera , they will upload images from their device.

I. What column type should images be,if i want to insert new records from PowerApps?

II. What would be the formula & functions to save images as URL in each record and display it in the app in view screen

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,079 Most Valuable Professional on at

    Hi @Janani_M ,

    I did a fairly comprehensive blog on image storing and viewing - please have a read and I am happy to elaborate further when you work out the direction that suits you.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

     

     

     

  • WarrenBelz Profile Picture
    153,079 Most Valuable Professional on at

    Hi @Janani_M ,

    Just checking if you got the result you were looking for on this thread. Happy to help further if not.

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @Anonymous:

    Do you want to patch the SharePoint list with the images?

    Firstly ,I want to explain why you can not patch the image to the SharePoint list.

    Since the data source is SharePoint, It is not feasible to update the Picture field with an image file in canvas app.

    In addition, you can update Hyperlink field with URI.

    Column type

    Support

    Default cards

    Hyperlink

    Yes

    View URL
    View text

    Picture

    Yes (read-only)

    View image
    View text

    I think this link will help you a lot :

    SharePoint/Known issues

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

    Finally, I have an idea here for your reference:

    My Date Source: List A

    Title

    Single line of text

    column1

    Hyperlink or Picture

    column2

    Hyperlink or Picture

    column3

    Hyperlink or Picture

    Target:Save the three pictures in the collection to three files in a record of List A

    1\Add a Add picture control(For testing purposes, I use picture control instead of Camera control)

    2\Add a button.

    OnSelect:

    Collect(
     MyPics, /*create a collection to save the pic*/
     {
     DisplayName: Concatenate(
     "image",
     Text(
     Now(),
     "[$-en-US]yyyy-mm-dd-hh-mm-ss"
     ),
     ".jpg"
     ),
     Value: UploadedImage1.Image,
     AbsoluteUri: "",
     Id: "00000000-0000-0000-0000-000000000000"
     }
    )

    3\Add a Gallery

    Items: MyPics

    4\Add a Form(Form1)

    DefaultMode: FormMode.Edit

    DataSource :'List A'

    Item: LookUp('List A',ID=1) /* Specify records to update */

    set the attachments control’s Items property to: MyPics(Important!Refer to the picture attachment for detailed settings)

    1.png

    Visible: false /* Make the entire form invisible (beautiful consideration)*/

    4\Add a button

    OnSelect:

    SubmitForm(Form1);
    Patch(
     'List A',
     LookUp( /* Specify records to update */
     'List A',
     ID = 1
     ),
     {
     column1: First(
     LookUp( /* Specify records to update */
     'List A',
     ID = 1 
     ).Attachments
     ).AbsoluteUri/*patch the column1 field with the first pic's URI*/,
     column2: Last(
     FirstN(
     LookUp( /* Specify records to update */
     'List A',
     ID = 1
     ).Attachments,
     2
     )
     ).AbsoluteUri/*patch the column2 field with the second pic's URI*/,
     column3: Last(
     FirstN(
     LookUp( /* Specify records to update */
     'List A',
     ID = 1
     ).Attachments,
     3
     )
     ).AbsoluteUri/*patch the column3 field with the third pic's URI*/
     }
    )

    2.JPG

    In addition,there are many ways to save pictures to sharepoint list.For example:

    • Using flow-I think the scheme of @WarrenBelz  is a good example
    • Store the picture in a binary format in a Text type field:please refer to this Link

    Best Regards,

    Bof

     

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 Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard