web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Default Attachments in...

Power Apps

Unanswered

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
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

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
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