Power Platform Community Forum Thread Details

Summary - I want to tag attachments on a record. Utilizing a custom page. I have watched and RezaDorrani's video, but the client did accept this solution. I wanted to create a new column in the 'notes' table, but that is not allowed. I tried to create a new N:M table to act as a tag/attachment join table, but when trying to patch to this table on the onSubmit, I ran into "x column does not exist, closest column is x" (in many different forms). I decided to utilize the 'Description' attribute within the 'notes' table as my 'Tag'. After the initial submission of a record my attachment tagging functionality worked perfect -

ForAll(
 AttachmentsToAddOrEdit,
 UpdateIf(
 Notes,
 Regarding = ExpenseFromIdParam && 
 !IsBlank(Regarding) && 
 Title = TextBox4.Value,
 {
 Description: ComboBox6.Selected.Value
 }
 )
);

Although I need this to work on initial submission as well.

I really want is to bring the default form functionality (being able to add notes directly to a transaction) into my custom page.

(goal to bring this ^ functionality to a custom page)

Any ideas would be greatly appreciated.

Thanks

Categories:

Building Power Apps

You mentioned a video by Reza and a rejected solution by the client. Are you talking about this one: https://www.youtube.com/watch?v=UYK7yruBHDM which uses a document library instead of attachments? If no, then no problem, if yes, I'm curious to know more about why the client rejected the solution. I have an app setup using a document library for attachments such that the appearance and behavior is indistinguishable from if I were using native attachment functionality.

Strengths:

"attachments" are crawled for search indexing
can add custom columns freely
metadata labels and sensitivity labels can be applied specifically to the document
Still have multi-selection lookup column referring to the document library. Can display the filename and link to the "attachment" just the same as with native attachments.

Weaknesses:

can't duplicate file names within a library or folder.
- Address by having App/Flow create either a specific folder for each item or an individual folder for each and every attachment.
A bit more permissions management
Need to customize the attachments control and add other custom code to handle the new attachments.