Answered

Help with Hiding a Button based on # of attachments

(0) Share

Report

Posted on by SamR

Hello,

I have an app that acts as a way to complete a form with various screens that attach a signature to a sharepoint list item via an attachment.

I would like to somehow make the "sign/save form" button not visible if the item already has two attachments (basically two signatures).

Is there any sort of "If" statement I can implement on a visibility control that will make a button not visible if the item being viewed on the form has 2 or more attachments?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@SamR

You will need to reference the attachments table of the record you are working on.

With that you can set the Visible property of the button to:

CountRows(yourRecord.Attachments) < 2

I hope this is helpful for you.

Was this reply helpful? Yes No
SamR 30 on at

Like (0)

Report
Copy link

Link copied!

Awesome @RandyHayes . That does seem to work. I have one follow up question I wonder if you may be able to help me with.

In another part of my form I have a section that I would like to display specific attachments. I have found and am using the "first(thisitem.attachments).value" to display the first attachment/signature.

Is there a way to specifically display the second?

I tried "second(thisitem.attachments).value" but it seems to affect a function to do with time rather than the second item in my attachment list.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@SamR

There is no Second function. You can get the second record with this:

Last(FirstN(thisitem.attachments, 2)).value

Was this reply helpful? Yes No
SamR 30 on at

Like (1)

Report
Copy link

Link copied!

Understood - looks like I can use that to select any specific item in the list with a little tweaking. Very appreciated. 😁

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@SamR

Yes, as you can see the number 2 in that formula "essentially" determines which record you are going to get.

Was this reply helpful? Yes No