Create TABLE and enabling Attachments

(0) Share

Report

Posted on by HKICE

237

I am fairly new to PowerApps.

I would like to know what PowerApps does different when I check the box "Enable attachments (including notes and fields)" during creation of a new Table - This question is there because I can always create a COLUMN in that table with DATA-TYPE = FILE and then I can attach any file using that!

What am I getting different by checking off the "Enable attachments (including notes and fields)" box ?

Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (2)

Report

if you create a column with data type as File you can attach a single file to the record inside that column.

"Enable attachments" uses the attachment table so you can store multiple files connected to a single record.

Keep in mind that once you enable "Enable attachments" you can't disable the option in the future (there is a note indicating this)

hope it helps

Was this reply helpful? Yes No
HKICE 237 on at

Like (0)

Report

Interesting. Where would I find this information, since I have not been able to find this on any of the MS site documentation.

Thank you.

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (2)

Report

for the file column you can check this page https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-fields#file-columns

for the attachments you can check the annotation reference https://learn.microsoft.com/en-us/power-apps/developer/data-platform/annotation-note-entity

is not so clear but is the option enabled by the checkbox "Enable attachments" each note can have an attachment.

Was this reply helpful? Yes No
TSte 240 on at

Like (0)

Report

Hello,

could anyone tell me how the patch function looks for this if i want to patch multiple data from canvas app to Dataverse, i cant get it working..

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I use this feature currently. However, when my users drop files into the canvas app interface that I have, the are unable to submit the files and it actually erases them out of the data card input. I, however, am able to do this with no issue. Could this be because of a security role issue? I don’t see the attachments table as an option to add to the security role.

Was this reply helpful? Yes No
Domenique123 2 on at

Like (0)

Report

i encountered this issue also. Where i as developer was able to upload and see the files users did not. To solve this you have to turn on security settings for core attachments. The following post help me do it: https://powerusers.microsoft.com/t5/Building-Power-Apps/Attachments-Not-Showing-for-End-Users/m-p/349390#M100258

Was this reply helpful? Yes No
Domenique 6 on at

Like (0)

Report

I have the same problem. Do you happen to have found the solution?

Was this reply helpful? Yes No
TSte 240 on at

Like (0)

Report

Unfortunately i did not manage to upload multiple files to Dataverse attachment table..
i had two scenarios - one with always repeating attachments and fixed amount of attachments - in this case i created a attachment column for each attachment in Dataverse.
in the second scenario with no fixed amount and types of attachments, i uploaded it to SharePoint according to this tutorial:
PowerApps upload file to SharePoint document library (youtube.com)

best regards
Thomas

Was this reply helpful? Yes No
Domenique 6 on at

Like (0)

Report

Thanks for your response! Sad to hear that this has not been figured out yet.

If i happen to find the answer i will inform you!

Was this reply helpful? Yes No
Domenique 6 on at

Like (0)

Report

I have found a solution that works for me.

Additionally, to setting the core setting for notes to the correct permission, you also have to add the following table (annotations) as a data source to your application.

My users can now upload and see the attachments (all in the same datacard).

Let me know if this solved your problem and give it a thumbs up!

Was this reply helpful? Yes No