web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps Default Attachments in...

Power Apps

Answered

Default Attachments in gallery

(0) Share

Report

Report

Posted on by R Bakker

725

Hi Everyone

So close but not quite

This works

Index(ThisItem.Attachments,1).Value

But this does not

Index(ThisItem.Attachments,ThisItem.AssetAttachIndex).Value

AssetAttachIndex number is no higher than CountRows(ThisItem.Attachments)

AssetAttachIndex is a number column in Sharepoint.

So it kinda works but I am getting a red squiggly line.

What I am trying to do is choose which is my default attachment/image in my galley rows.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Corissandageri ,

There is nothing wrong with the formula.

Sometimes, there will be bugs when dynamically referencing the sp attachment column.

Please try this workaround:

With({temp:LookUp(LIST302,ID=ThisItem.ID,AssetAttachIndex)}, Index(ThisItem.Attachments,temp).Value)

Best Regards,

Wearsky

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Hi v-xiaochen-msft
Thank you for your time.
Your formula works but but I am still getting notified that the Index function cannot be called on an empty table. I'll have another look at it later.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Corissandageri ,

Please try this:

With({temp:LookUp(LIST302,ID=ThisItem.ID,AssetAttachIndex),temp2:CountRows(LookUp(LIST302,ID=ThisItem.ID).Attachments)}, If(temp<=temp2, Index(ThisItem.Attachments,temp).Value,""))

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation