Download all attachments for a specified set of records

(0) Share

Report

Posted on by Martin_W

373

Hi,

I've got a Dataverse table containing details of items of equipment. Each record has a file attachment column which contains the certificate to say that the item has been tested.

How would I be able to allow a user to download all of their relevant file attachments in one go? Copilot suggests using a Download function inside a ForAll, but I need the Absolute URI for each attachment and I'm having a hard time with that.

thanks,

Martin

Categories:

Microsoft Dataverse with Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @Martin_W, I am assuming you are using a Canvas app as your front-end application for your end-users. You can achieve this using the ForAll and the Download function as the Copilot said 🙂

Here is the construction of your URL:

Download("EnviromentURL/api/data/v9.0/Table_LogicalName(Record_GUID)/FileColumnLogicalName/$value")

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
Martin_W 373 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks @AhmedSalih

Inside a ForAll loop, how would I get the record GUID? Is It ThisRecord I need to be using?
AhmedSalih 6,680 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Martin_W, the GUID is save in the Column with your table name. So, ThisRecord.ColumnName
Martin_W 373 on at

Like
a
(0)

Report
Copy link

Link copied!
Great, thanks again @AhmedSalih

I've tried that and the first result opens a browser tab with the url (replace EnvironmentURL with my actual Environment URL) which results in a HTTP 401 error

"EnviromentURL/api/data/v9.0/crbbc_leapsasset(784adb72-681d-ed11-b83d-000d3ab351db)/crbbc_declarationofcompliance/$value"

It comes from this code:
ForAll(Gallery1.AllItems, Download("myurl.crm4.dynamics.com/api/data/v9.0/crbbc_leapsasset(" & ThisRecord.LEAPSAsset & ")/crbbc_declarationofcompliance/$value") )
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Martin_W, your Organization URL needs : https://

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
Martin_W 373 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, I have that: