Power Platform Community Forum Thread Details

Hi,

I have 2 entities: Groups > 1:N > Requests. You have Groups that can have many Requests.

These Requests entity has a File field in the Common Data Service entity where users attach a file through a standard Form control.

The user can have many Requests per Group and thus may have many Request File Attachments to send from the previously selected Group. I want to be able to send those files as an attachment in a separate "send email" control.

When I use a Filter:

Filter('Requests Entity', 'Group Requests Relationship'.ID = galleryGroups.Selected.ID)

This filters the Request columns for the selected gallery item from Groups. If I try to collect that:

Collect(collectionRequestFiles, Filter('Requests', 'Group Requests Relationship'.ID = galleryGroups.Selected.ID).'Request File Attachment'))

The collection is a table returned of the collected Request File Attachments - however, I'm not able to access the columns I need except if I click into it under settings I see: "FileName" & "Value".

Question: How do I achieve separating out the specific columns where "FileName" = Name, "Value" = ContentBytes, "@odata.type" = "", so that I can send these files as attachments in a sendemail function?