Answered

Add Pictures to SharePoint list from Kaizala

(0) Share

Report

Posted on by mgeorge46

I have created a Kaizala Card that has images I would like to have them saved to a SharePoint list together with some other text collected but when I add Picture/Hyperlink the image doesn't come into the SharePoint list, I have tried using multiple text but still it fails with error below

{

"status": 400,

"message": "Object must implement IConvertible.\r\nclientRequestId: xxxxxxxxxxxxxxxxxxxxx\r\nserviceRequestId: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

}

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mgeorge46 ,
To get the image into a text format, you need
JSON(<YourImageName>.Image,JSONFormat.IncludeBinaryData)
mgeorge46 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz ,

Am a newbie about PowerApps and flows, How do I use that function does it go under column formatting at List level or function level at the time of building the flow.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mgeorge46 ,
I tend to use a Variable
UpdateContext({vPhoto:JSON(<YourImageName>.Image,JSONFormat.IncludeBinaryData)})
then send the variable vPhoto to Flow as the content of the picture. I actually convert it back to a picture in the Flow to SharePoint Library.
I am wondering why you are using a Flow when if you are only writing text to SharePoint, you could Patch it.
mgeorge46 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz ,

The reason am using flows is that am using Kaizala to send information to a SharePoint list, but the text is fine, though from the JSON function you have shared when I add it as an expression I get alot of other unnecessary text

UpdateContext({vPhoto:JSON([{"mediaUrl":"https://cdn.xxx.kms.osi.office.net/att/xxxxxxxxxx.jpg?sv=2015-12-1xxxxxx.jpg"}].Image,JSONFormat.IncludeBinaryData)})

The above turns-up in the field yet I would like to have only the image.

Thanks for your help am seeing my self getting somewhere.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @mgeorge46 ,
Yes, that is the PowerApps (strange) dataUri format, however for a JPG to convert to Base64 (the image), you need to remove the first 23 and last 1 character I believe (that is what mine have to do)
So :-
UpdateContext({vPhoto:JSON(<YourImageName>.Image,JSONFormat.IncludeBinaryData)});
UpdateContext({vPhoto:Mid(vPhoto,24,Len(vPhoto) - 24)})
If the numbers are different for yours, just change the above to suit.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mgeorge46

Can you try to refer to my blog post for this: https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Automate-Business-Actions-with-Microsoft-Flow-PowerApps-and/ba-p/341937

Here, I am adding an image as delivery proof. You can follow flow2 for getting the url, and then creating an HTTP request to get the content and store it in a variable and finally referrencing that variable in the SP list action.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
mgeorge46 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz I can seen what your point at but my question is how do I add it in flows as my screen shot below design so that the list can save the image from Kaizala
Verified answer

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mgeorge46 ,
You need to do the JSON in PowerApps and send the variable to Flow.
mgeorge46 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz I have re-opened this since the solution you gave me has not worked as I expected, thing is that Kaizala is the first trigger or action and I have failed to find a away to connect Kaizala to Power-apps then to SharePoint List.

Data is collected from the Field that has Images using Kaizala and therefore it will be the first option as an action or trigger when building the flow to save data to the SharePoint List

Team I need to save Images from Kaizala to a SharePoint List, using Flows

@yashag2255 I have tried your option but at the point of initializing the variable it renders the error below when you run the flow.

BadRequest. The variable 'CustomerImage' of type 'String' cannot be initialized or updated with value '[ { "mediaUrl": "https://cdn.inc-000.kms.osi.office.net/xxxxx", "mediaFileName": "IMG_20-02-25_090126977_1.jpg" } ]' of type 'Array'. The variable 'CustomerImage' only supports values of types 'String'.

Guys I need your help I need to save Images from Kaizala to the SharePoint list using flows
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mgeorge46 ,
My suggested solution was in relation to a SharePoint Library.
I have no working knowledge of Kazalia.
I will tag @yashag2255 who also made a suggestion on this to see if he can expand on it