Update Image Type Column in SharePoint from Power Automate/Flow

Подписаться 2,2 тыс.

Просмотров 10 тыс.

50% 1

________________________________________________________________________________________
How to upload image or signature from Power Apps to SharePoint: • PowerApps Basics -3: M...
________________________________________________________________________________________
To Update Picture or Hyperlink Column in SharePoint from PowerApps please check this video: • How to do in Power App...
________________________________________________________________________________________
Image Type Column in SharePoint is a readonly column in Power Apps. Here is a workaround how you can update Image Column through Flow/Power Automate using "Send an HTTP request to SharePoint" Action.
Few help code used in the video:
REST API: _api/web/lists/getbytitle('Contractor Details')/items(@{triggerOutputs()?['body/ID']})/ValidateUpdateListItem
ServerRelativeURL: decodeUriComponent(decodeUriComponent(items('Apply_to_each')?['Id']))
Body JSON:
{
"formValues":[
{
'FieldName':'NewImageColumn',
'FieldValue':''
}
]
}

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@abdulazeem656 Год назад

Nice explanation, but there is small note: The GUID at the last compose action (before HTTP action) for "id": metadata should be the ETag of the file we are uploading/referring (not any general GUID() which you showed here). Then only it will show the image at the canvas app Gallery control. Otherwise, even though it shows at Sharepoint list, it will not show at canvas app. Etag can be availed by ''Get File Metadata'' action, if not available from previous step.

@alexiscordova59 4 месяца назад

Hello, i am having that problem. I am not able to fully solve the issue. Please help. In my Power Automate i'm uploading the image to OneDrive library using 'Create file' action. I need then to upload that image to the sharepoint list image column. This list is connected to a Power App, i have the problem that it does not display the image in my Powerr App for some reason.

@hashtechexpert 2 года назад

Thank you for sharing this information, I am wondering to know if i want to save the image file from Jotform to SharePoint Library, how can I do that?? using Power Automate

@RT-yi6te Год назад

Thanks Aniruddha. Did you find a way to save the image directly from power apps without using the API call from power automate/flow ? I would like to have a collection of images and then use patch to save them into SharePoint.

@AniruddhaBiswasChannel Год назад

Hi, you can add a single image in Image column in SharePoint. If you have a collection of image then please use attachment control. I created this video long back but very recently you don't need any Power Automate to update the Image column, inside the Form you will get image upload control.

@ttsoares2501 2 года назад

Congratulations for the channel, I have learned a lot from your teachings! There is another way to put the images in the column without using the attachment column, because in the attachment column I use to attach other files of formats other than the image, I want to put it directly in the column in sharepoint in the image format.

@AniruddhaBiswasChannel 2 года назад

Hi Thiago, Thanks for your kind words. So basically, in SharePoint Image Type column, when you upload any file it goes to Site Assets Library with GUID folder name for that list. You can keep your image there too instead of keeping in Attachments. Also you can give a unique name for the image like "ProfileImage_1" etc. to distinguish the image in the attachments.

@faymoshope 8 месяцев назад

Please after following your tutorial, Im getting this errror An unexpected 'StartObject' node was found when reading from the JSON reader. A 'PrimitiveValue' node was expected.

@UXessability 2 года назад

Thank you so much for teaching this! It looks like I can follow along with most of this up until I get to the point where I extract the column code and beautify the JSON. I have a lot more parameters than you do. I was able to shorten it by trial and error within the Flow to this: { "type": "thumbnail", "fileName": "@{items('Apply_to_each')?['DisplayName']}", "nativeFile": {}, "fieldName": "Photo", "serverUrl": "DELETED", "serverRelativeUrl": "@{items('Apply_to_each')?['Id']}", "id": "@{guid()}", "fieldId": "24812ead-a887-4a07-a60b-660a54764d67" } So, everything looks the same as yours, except for at the bottom whenever I delete the "fieldId" I get an error message for my flow that says "Enter a valid JSON" Do you have any idea why my Sharepoint List is giving me a more complicated JSON than yours? And what about this fieldID? I know this is a lot to ask! Thank you anyways for this detailed video and for all your time.

@AniruddhaBiswasChannel 2 года назад

Hi Keslie, This kind of error usually comes when the end comma (,) of any line wrongly given. Please check correctly. I belive you have given one extra comma at the end

@IbrahimSaeed-Plus 2 года назад

Hello there, thank you very much for this. But how can I modify this to update the image column if a form was used to upload the image? I've managed to use another flow that updates the 'hyperlink or image' format column. I still need the uploaded image in the image column since images in URL column do not show up in the grid view

@braddavis4743 2 года назад

did you ever figure this out?

@billwiggins3789 2 года назад

Awesome video and solution. It really saved my bacon until the update SP image column from PowerApps functionality becomes native from MS. Hopefully soon! ;) The process works great to get the image into my list from a mobile PowerApp. That being said, for some reason, unknown to me, the uploaded image does not display in gallery views in PowerApps. The images that I manually attach within SP’s web interface do with no issues. The uploads do not. Checked everything I know to check. Compared the JSON, location, etc. I can see them in the SP web interface and click on them and view the image just fine. They just do not appear in the gallery view. Do you have any suggestions? Thanks again. Great work.

@capitanzenn Год назад

Aniruddha Biswas Great work and thanks for the good explanation. We have the same problems. The upload is working fine but in the List View the links to the Images show as broken. And if we try to open it direkt from the list view this error opens in a new Window {"error":{"code":"invalidRequest","message":"Invalid request"}}.

@michaelbrewerton4163 2 года назад

Thank you very much for your willingness to teach and help others. It is very much appreciated. Do you know if I could use a similar flow to update an existing SharePoint list item image field, with a ms form submission as the trigger? I believe that I would need to query the list using an identifier value submitted by the user, then I want to save the image uploaded by the user to the image field in the same item? How would I go about doing this? I have found related videos but nothing with exact or similar results.

@AniruddhaBiswasChannel 2 года назад

Hi Michael, Thanks for your kind words. It is possible to upload a file from MS Form to SharePoint Image Column. So when you create a MS Form and keep a Attachment control in it then in your one drive (Form creator's one drive) there is a folder get created with the same name of the Form. Next time whenever user upload an attachment (You can filter only photo they can upload in Form), In the Power Automate you can get it and copy that image and place in the SharePoint List item attachment. Rest of the Flow will be similar as shown in video. Please let me know if you need any help on that. Please email me aniruddhab@outlook.com

@ResponsibleXI 3 года назад

Thank you so much for this sir. I think this is 1st on internet. So many on other forums are looking for this. Can you brief why deleting image deleted the attachment as well?

@carlw 3 года назад

I think because one is a function of the other. They're not really two distinct entities. That's my take in it anyway.

@AniruddhaBiswasChannel 3 года назад

Hi Ramesh, Before search Why it is like that I like to understand what is our requirement. By Design it is right (Image column behaviour), Image column uploading one file from user's machine and keeping somewhere else and while deleting it is removing from that place. If it is not get deleted then there will be garbage in the List/Library. Please understand There are two types of columns in SharePoint one is Image and One is Picture with different purpose. You need to use Picture column when your image already in another Library and you just need to refer. Whereas Image column should use when your image is not already in the List/Library and user supposed to upload. All the column type coming up keeping on eye with SharePoint not keeping on eye of Power Apps. Gradually I am hoping everything will sync up (Means easy to upload Image file to Image column or Picture column)

@charithaamaraneni2628 3 года назад

Thanks for Detailed Explanation. This is helpful. Can you help me understand how to read an Image from Sharepoint list using Power Automate and populate in Word Document.

@AniruddhaBiswasChannel 3 года назад

You can create a Word Template with a Image placeholder. Keep that Template ina SharePoint Library. Then run the Power Auomate and take that template and update with your desired image.

@ankushkhosla 3 года назад

Thanks this is really helpful. I am wondering how do we the other way i.e. upload an image in list item and then show it in powerapps form. Also, I am not able to find the rest api code for my sharepoint. Please help

@AniruddhaBiswasChannel 3 года назад

Check the description if you are looking for this video: To Update Picture or Hyperlink Column in SharePoint from PowerApps please check this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HJXYUebWSjY.html

@rashantha Год назад

Thank you this was explained very well.

@carlw 3 года назад

Wow. That's impressive thanks for doing the video Aniruddha. You deleted the image which removed the attachment, but the image is a link to the attachment? So you have to retain both or just the attachment? Did you test if the image file is now visible in PowerApps? Probably not I'd hazard a guess at. Along these same lines, was it one of your videos doing something similar in that, for the hyperlink field that you can set as hyperlink or picture, you or someone showed adding the hyperlink AND the friendly display name box in PowerApps (which like so many limited MSFT things is not available, intuitively ootb). If it wasn't you ill search through my history and send that to you for your information. Tx CW

@AniruddhaBiswasChannel 3 года назад

Hi Carl, Not sure if you are looking for this Video which is already in the description: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HJXYUebWSjY.html

@edersonti 3 года назад

Hello Aniruddha Biswas, I save images to libraries. I need to save the image link in a table on my SQLServer. Which parameter should I use on powerautomate for this information? Can you help me ? tks

@AniruddhaBiswasChannel 3 года назад

You will get "Document ID" parameter in the Power Automate. This is permanent Link of any document. Means if you move the file from one library to another Library, the link will be same.

@edersonti 3 года назад

@@AniruddhaBiswasChannel It's Worded ! tks

@revatichaudhari1694 3 года назад

Can we send attached image in email( send an email body section)???

@chrisvetek2602 3 года назад

Thank you very much. This worked and seems amazing. I am going to try to edit it to meet my requirements of using a power apps signature item and upload to a sharepoint list.

@AniruddhaBiswasChannel 3 года назад

Nice to know that it helped you. Here is another video where you can find out to upload any image in SharePoint from Power Apps (Signature etc.)

@rendraramahusada4171 3 года назад

Thanks Aniruddha, just got this important thing for me. However i got error when run the flow : Value cannot be null. Parameter name: formValues clientRequestId: d0083ab5-be4d-4ef8-94b6-a106807c0abc serviceRequestId: 9433b39f-5058-b000-fda3-858a437fa92c Is there any miss step for that error ?

@rendraramahusada4171 3 года назад

Please Ignore it. Already workfine.. Something missing in header part