Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Check a table in CDS have attachment

(0) ShareShare
ReportReport
Posted on by 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:
  • ChrisPiasecki Profile Picture
    6,389 Most Valuable Professional on at
    Re: Check a table in CDS have attachment

    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.

  • Axal Profile Picture
    945 on at
    Re: Check a table in CDS have attachment

    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

  • ChrisPiasecki Profile Picture
    6,389 Most Valuable Professional on at
    Re: Check a table in CDS have attachment

    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.

  • Axal Profile Picture
    945 on at
    Re: Check a table in CDS have attachment

    Hi @Mira_Ghaly 

     

    Yes, I'm using Notes.

     

    Thanks,

  • Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Check a table in CDS have attachment

    @Axal 

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics