Answered

File wasn't available on site Power Apps

Like (2) Share

Report

Posted on 9 May 2024 12:55:36 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:

Using Apps Using Formulas

All responses (11)

Answers (2)

CU14112135-0 17 on 19 Feb 2025 at 02:04:57

Like (0)

Report

File wasn't available on site Power Apps

nvrhughes: The setting "Settings - Updates - Retired - turn legacy formula bar on . " DOES NOT EXIST AND THERE IS NOTHING SIMILAR

Rampals: There are no such sub attributes for the Atttachments Control under Items: The two attributes are set in a formula where both Name and Value are identified.

Does Power Apps change so frequently that posts from May/July 2024 could already be useless in Feb 2025?
Suggested answer

bobesponja 252 on 07 Feb 2025 at 21:04:15

Like (1)

Report
File wasn't available on site Power Apps

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) )
Suggested answer

mattb3 8 on 28 Jan 2025 at 12:11:19

Like (2)

Report

File wasn't available on site Power Apps

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.
ST-19081858-0 12 on 13 Oct 2024 at 13:50:53

Like (0)

Report

File wasn't available on site Power Apps

HI,

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

Please assist.

Thanks
Verified answer

nvrhughes 85 on 26 Jul 2024 at 18:56:43

Like (4)

Report

File wasn't available on site Power Apps

@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.
nunuNMS 88 on 10 Jul 2024 at 11:54:57

Like (1)

Report

Re: File wasn't available on site Power Apps

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
Crawq 6 on 10 Jul 2024 at 11:23:54

Like (2)

Report

Re: File wasn't available on site Power Apps

i used a separate gallery showing the attachments instead of the forms as a workaround
nunuNMS 88 on 10 Jul 2024 at 11:21:39

Like (1)

Report

Re: File wasn't available on site Power Apps

not yet, but pls if you find a solution let me know
Crawq 6 on 10 Jul 2024 at 08:33:16

Like (1)

Report

Re: File wasn't available on site Power Apps

@nunuNMS
same for me did you find a way to fix it?
nunuNMS 88 on 04 Jul 2024 at 06:40:09

Like (1)

Report

Re: File wasn't available on site Power Apps

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