ConnexionAdd, update, or delete images in SharePoint/Microsoft Lists using Power Apps
In my previous blog about image columns in SharePoint, I explained all you need to know about New Image column type in SharePoint online including how to create an image column, how to add image to a list item, where the Images will be stored, etc.
Last year Microsoft added support for displaying images from SharePoint Online/Microsoft Lists to Power Apps canvas apps. Now, Microsoft is adding support for adding, updating, and deleting images from image columns in SharePoint online/Microsoft Lists using Power Apps canvas apps.
Newly created canvas apps that have a SharePoint data connection and are connected to a list can use controls that can add, update, or delete images from the SharePoint list. To use the same functionality in existing canvas apps, you have to delete the existing SharePoint data connection and then re-add it to refresh the data schema.
Configure SharePoint Form control to add pictures/images
Follow below steps to configure SharePoint Form control in canvas app to add pictures/images to SharePoint lists:
1. Create a SharePoint online list and then create an image column in the SharePoint list.
2. Go to make.powerapps.com, create a blank canvas app and add SharePoint list data source.
3. Add Form control in app from Insert > Forms > Edit form
4. Set Data Source property of form control to SharePoint list data source and DefaultMode property to FormMode.New
5. Select form control from tree view, click on Edit fields option from Properties panel at the right side of screen.
6. Add your image column to form using + Add field option on Fields panel and select Add picture as a Control type as shown in below image. Power Apps will add Add picture control inside the data card for image column.
7. Add a button control in canvas app and set it’s OnSelect property to:
SubmitForm(Form1)8. Now when you run the canvas application, you can select an image from your computer using Add picture control and save it to SharePoint list using SubmitForm() function used in button control.
Using Patch() function to add/update image column using Power Apps
You can also use the Patch() function to add or update an image in image columns in SharePoint/Microsoft Lists using Power apps canvas apps. You can use similar code as given below on OnSelect property of button control:
Patch(
'Logo Universe',
Defaults('Logo Universe'),
{
Title: TextInputControl.Text,
Image: ImageControl.Image
}
)Delete an image from SharePoint image column using Power Apps
You can delete an image from SharePoint image column using Blank() value for image column in Power Apps Patch function:
Patch(
'Logo Universe',
Defaults('Logo Universe'),
{
Title: TextInputControl.Text,
Image: Blank()
}
)Limitations
- Images up to 30MB in size are supported while adding/updating images.
- Below image formats are supported currently while using this feature.
Supported Image formats
Below image formats are supported currently while using this feature:
- JPG and JPEG
- PNG
- GIF
- TIF and TIFF
- HEIC and HEIF
- JPE, MEF, MRW, NEF, NRW, ORF, PANO, PEF, RW2, SPM, XBM, XCF
Release Timeline
- Targeted Release: Rollout started in late September 2022 (previously early September 2022) and expected to complete by mid-October 2022 (previously mid-September 2022).
- Standard Release: Microsoft will begin rolling out this feature in mid-October 2022 (previously mid-September 2022) and expects to complete it by late October 2022 (previously late September 2022).
Learn more
- Power Apps can now display images from SharePoint Online/Microsoft Lists
- Add an image to SharePoint Image columns using Power Automate
- Add/Update image columns in SharePoint/Microsoft Lists using PnP PowerShell
I hope you liked this blog. Please give your valuable feedback & suggestions in the comments section below and share this blog with others.
