cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BClouded
Helper IV
Helper IV

Export SharePoint to excel incl image

Dear Community

I'm struggling with following use case. I've developed a real-estate management tool for my client, it's based on 3 SharePoint lists. 
Property, Transactions, Pictures. Transactions and Pictures hold a PropID to link them to the correct Property.

Of course client wants to be able to export data to excel... 
Well I managed to do that pretty well, but now he asks me if we can add a picture in export as well. 

I've been searching the internet for a while but couldn't find anything useful. 
Maybe somebody here can give me some clues to work with? 

Thanks in advance!

This is my current flow, using a csv table.

BClouded_0-1632214588354.png

 



 

5 REPLIES 5
DamoBird365
Super User
Super User

Hi @BClouded 

 

I believe Office Scripts could achieve this for you.  There is a recording tool to get you started if you are unfamiliar with TypeScript and here is a sample script that downloads an image from a URL to a workbook. 

office-scripts-docs/add-image-to-workbook.md at master · OfficeDev/office-scripts-docs · GitHub

It will most likely be possible that you can accept an image in base64 as an input to your Excel Office Script action and save it to your document or you could simply pass a URL.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Thanks for this info DamoBird365.
I have no experience with Office Scripts, I'll have a look at it and see if I can use it somehow.

Hi @BClouded ,

 

The Microsoft Team have some good sample scripts here Introduction to Office Scripts in Excel (microsoft.com) and I have a few videos (including the opposite of what you require - returning images from Excel to PowerAutomate).  Might be worth a look (1) Office Scripts - YouTube and let me know how you get on.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Yes I'm watching your youtube channel as we speak 😉
Nice work! 

rohan2
Frequent Visitor

Hi Damo,

I tried to follw the sample scripts online but I am struggling.

I am getting an 'image' from dataverse (saved in an image type column) and when i look into what it returns it says it is already in binary.

But when i pass to the btoa() function I get an error.

any idea why?

 

crcfa_image@odata.type":"#Binary","crcfa_image":"/9j/4AAQSkZ...........

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,352)