Check a table in CDS have attachment

(0) Share

Report

Posted on by Axal

945

Hi guys,

In CDS, where exactly the attachment saved ? and if I have a gallery contains my table which I've some attachment in it, how to check a records (row) has attachment or not ? In that gallery I want to put some icon for indication attachments exists.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Axal

For attachments on your table are you using notes? or the Field control File?

Was this reply helpful? Yes No
Axal 945 on at

Like (0)

Report

Hi @Mira_Ghaly

Yes, I'm using Notes.

Thanks,

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @Axal,

The Notes table has an Is Document column which is a Yes/No (boolean), which will indicate if the note has an attachment.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Axal 945 on at

Like (0)

Report
Hi @ChrisPiasecki ,

I'm sorry, may I know how to use it? I had an icon in my Gallery to identify whether my record has attachment or not and I'm trying this in its Visible property :
If( ThisItem.Notes.'Is Document' = true, true, false )
The intention is, if there is attachment, the icon will show else it is hidden. But seems wrong. It looks like the return of "ThisItem.Notes.'Is Document'" is a table.

Beside that I also want to add another label right beside the icon, for the count of the attachments.

Thanks

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @Axal,

Yes thats correct your selected item will have a collection of notes. You can use the CountIf function to determine if there are any Note records where IsAttachment is true. You can use the Count function to determine the total number of Note records for your selected item.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No