Answered

How to tell if attachment control from SharePoint has at least 1 attachment in it outside of the form

(0) Share

Report

Posted on by Mattw112b

1,088

Hi, so I want an icon not inside of my form to change colors if at least one attachment is added in the form, before submit.

I have tried setting variables, creating collections, setting a label in the form then checking that, etc.

Nothing is working though if statements just always come back as blank even when something is added and collections dont populate.

I have tried countRows and OnAddFiles and OnRemoveFiles... if I add a label in the form I can see an accurate count of items, but can't get that data out of the form to do stuff other places?

Ideas?

Thanks,

Terry

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report
Copy link

Link copied!
Try this in a label outside of your form replacing DataCardValueX with the name of your DataCardValue in your Attachments DataCard.

CountRows(DataCardValueX.Attachments)

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

So, I did try that and doesn't give me any value??

Terry

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

That is strange. Just out of curiosity, have you tried any other type of files besides text? It doesn't make any sense that you would get a different result, but.....

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

Yes tried many. Also I didnt show it int he screen capture but I have labels inside the form and those show the correct numbers and have the same formulas...

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is this a standard canvas app with a form in it, a SharePoint intgration app or a Power Apps for Teams app?

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

This is a standard standalone Power App, not embedded in SharePoint, but does have the SharePoint backend List.

Thanks,
Terry

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

Also no containers or anything if that is where you were going.

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you add a temporary screen and add a new form with the same data source and item properties and then see if you can count the attachments outside of the form in a label?

I actually just added that capability to a totally separate app from where I tested it and it's working fine.

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

ok created blank screen, added the form exactly like other screen, and it worked!! I could see a count outside the form...

I checked out all properties etc. between them both and they are identical??

So I copied the form from the first screen and pasted on the new screen, and it still didn't work??

So then I copied the new form to the old screen and it didnt work?

Getting a bit confused.

So new form on new screen = works
Old form on old screen - doesnt work
Old form pasted on new screen = doesnt work
New form pasted on old screen = doesn't work

So kind of confused on what is going on.

Thanks,
Terry

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

I just deleted everything and added a new form to the old screen, and everything is working again?? Thanks for the help. Would be good to understand why it was acting like that, but at least I can progress now.

Was this reply helpful? Yes No