web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Downloading attachment...
Power Automate
Unanswered

Downloading attachments from CRM to a location such as Sharepoint

(0) ShareShare
ReportReport
Posted on by

Hi everyone

I have a field in my Dynamics CRM that has the type of File. I am uploading PDF files to this field in CRM, but I would like to create a Power BI report to show which CRM records have a file uploaded to this field. Unfortunately, Power BI does not work well with File fields, and therefore it is not showing when I try to create a report.

I've been advised to download the uploaded files to another location (e.g. Sharepoint) that would help me to work in Power BI.

I'm using Power Automate to extract the PDF files into a Sharepoint folder, but I'm having problems as it's asking for a unique GUID. The images below shows how far I've got in the process:

jonclaylondon_0-1708081271303.png

 

jonclaylondon_1-1708081298064.png

 

So, the Table Name is Contacts and the Column Name is Pen Portrait Upload. I'm trying to ask Power Automate to download any files that are currently uploaded or will be uploaded in future. However, I'm unsure what to put in the Row ID field which seems to be mandatory. Surely this will change for each Contact in the CRM?

I'm very new to Power Automate, so please forgive me if I've got this entire process wrong already!

Many thanks
Jon

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard