Answered

File wasn't available on site Power Apps

(2) Share

Report

Posted on by RampalsT

I have an attachments control that has set in its item property a collection which is a Lookup to my Sharepoint site of a certain item and gets its attachments.
The problem is that i have the same method implanted in another attachments control but this is set inside a gallery that holds list items and i have a button that makes a lookup to that list and gets its items.
Until this part the functionality works, but when i click on one of the items, instead of downloading the item the next message is shown:

I checked all the information(the collection gets the items and stores: Value,Name,AbsoluteUri and id for each item) and it is stored properly in it.

This is an app image:

The Lookup works every time that i click on the attachments icon and displays its according files.
In the app the functionality to show each files for each item, as well as save and delete them ,works fine.

PD: If i create a submit form in another page and i display the information of the item, the attachemnts card that is created works and allows me to download the item.

Any help will be appreciated.
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Verified answer

RampalsT 75 on at

Like (3)

Report
Copy link

Link copied!

I find the solution, simply go to your attachments control and change the value property ,that was set to ID, to Value, and the function works.

Was this reply helpful? Yes No
nunuNMS 88 on at

Like (1)

Report
Copy link

Link copied!

why dont i have this option, if you could help me here:

Was this reply helpful? Yes No
Crawq 6 on at

Like (1)

Report
Copy link

Link copied!

@nunuNMS
same for me did you find a way to fix it?

Was this reply helpful? Yes No
nunuNMS 88 on at

Like (1)

Report
Copy link

Link copied!

not yet, but pls if you find a solution let me know

Was this reply helpful? Yes No
Crawq 6 on at

Like (2)

Report
Copy link

Link copied!

i used a separate gallery showing the attachments instead of the forms as a workaround

Was this reply helpful? Yes No
nunuNMS 88 on at

Like (1)

Report
Copy link

Link copied!

if possible i would really appreciate it if you could show me how you did it in that way, I have been struggling with this for the past couple of days and you will help me alot, thanks again

Was this reply helpful? Yes No
Verified answer

nvrhughes 129 on at

Like (4)

Report
Copy link

Link copied!

@nunuNMS You need to turn on the legacy formula bar.

Settings - Updates - Retired - turn legacy formula bar on .

Save then ctrl+f5 to do a hard refresh. The value field will now display.

Was this reply helpful? Yes No
ST-19081858-0 20 on at

Like (0)

Report
Copy link

Link copied!

HI,

I am also getting this error. I have turned on the legacy formula but am not seeing the value field.

Please assist.

Thanks

Was this reply helpful? Yes No
Suggested answer

mattb3 12 on at

Like (3)

Report
Copy link

Link copied!

For any one looking at this post removal of legacy formula bar option, you can change the items value in your attachment control to something like this depending on your dataverse table:

[{Value: ThisItem.filecol.Value&Last(Split(ThisItem.filecol.FileName, ".")).Value, DisplayName: ThisItem.filecol.FileName }]

this allows you to click on the file in the control to download it fine.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

bobesponja 258 on at

Like (2)

Report
Copy link

Link copied!
The answers given didn't work for me, but some helped me get to the answer. PowerApps is trying to download files based on the Id parameter rather than Value (and it's trying to do so with some encoding that breaks things). Here's the code to put in the Items section to fix it:

ForAll( ThisItem.Attachments, { Id: PlainText(ThisRecord.Value), Value: ThisRecord.Value, AbsoluteUri: ThisRecord.AbsoluteUri, DisplayName: ThisRecord.DisplayName } )

On a slightly related note, if your Attachments section is showing items from an Image column in your datasource that you don't want to see in Attachments, you can filter those out like this:
// Don't display COLUMNNAME in Attachments control Filter( ThisItem.Attachments, Not(Substitute(EncodeUrl(DisplayName), "%", "%2525") in ThisItem.COLUMNNAME.Full) ) // You can filter out multiple columns by stringing them together with "&" Filter( ThisItem.Attachments, Not(Substitute(EncodeUrl(DisplayName), "%", "%2525") in ThisItem.COLUMNNAME.Full&ThisItem.ANOTHERCOLUMN.Full&ThisItem.ONEMORECOLUMN.Full) )

1 people found this reply helpful.

Was this reply helpful? Yes No