Unanswered

Issues downloading files stored in a Dataverse file column

(0) Share

Report

Posted on by CharlesPP

187

Hello everyone,

I have developed a Power Apps Canvas application and one of the needs is to be able to download files stored in a Dataverse file type column in bulk. I have tried several techniques, but none of them works perfectly.
In particular :
- The "Download" formula to download the file, but I am having problems with the download not working correctly in all browsers and every time. I used this URL "https://" & glbEnvURL & "/api/data/v9.1/my_table(" & ThisItem.ItemID & ")/my_file_column/$value". I also tried to retrieve the URL from Power Automate.
- To use the data card generated from a form, but this one has two problems: I can't launch several with one click (basically launch it on all the items in my gallery) and I want to perform an action in addition to the download (the file is downloaded and a status is changed).

Have you ever encountered this problem and found a solution to upload files from a file column in Dataverse into a Power Apps Canvas application easily?

I thank you in advance for your help and suggestions.

Sincerely

Categories:

Building Power Apps

I have the same question (1)

All responses (5)

Answers (0)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I faced this issue in the past and the problem was related to the browser was blocking the download, to fix that I enabled the pop-ups and redirects on, here:

on Chrome:

on Edge:

All the users must do this in order to download

I hope it helps 🙂

Was this reply helpful? Yes No
CharlesPP 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer!

Unfortunately, I had already put it as allow.

The behavior is a bit weird, the page opens, but the URL is "about:blank". If I click several times on the URL, I finally see the real URL appear, but the file downloads only after several seconds. If I do nothing, it stays in "about:blank" and downloads after several seconds. It's not a good solution for me since I have to download several files at the same time, so 30 tabs open at the same time doesn't really work, especially since sometimes it can take a long time to download.

If you have an idea, I'm very interested!

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

hm....

as you are download in a bulk and maybe there are some items that don't have an file that's explain the "about:blank", can you share the formula that you are using? and also check if there are any items that don't have a file?

Was this reply helpful? Yes No
CharlesPP 187 on at

Like
a
(1)

Report
Copy link

Link copied!
Surprisingly, there is a file every time 😕

I use this formula at multiple places, but here is the code I am using, where "cg_commandes" is the logical name of my table, "ThisItem.Commande" is the id of the record and "cg_fichierstl" is the logical name of my File type column :
Download("https://" & glbEnvURL & "/api/data/v9.1/cg_commandes(" & ThisItem.Commande & ")/cg_fichierstl/$value");

To download in bulk, I call the same formula in a ForAll loop.

Thank you in advance!

Was this reply helpful? Yes No
CharlesPP 187 on at

Like
a
(1)

Report
Copy link

Link copied!

It's suddenly working properly again, tested on different tenants with different browsers, hmm. Anyway, I'm going to use OneDrive instead with local sync, it will be more reliable and also good for the users!

Was this reply helpful? Yes No