News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Default Attachments in...

Power Apps - Building 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:

General Questions

Using Apps Using Formulas

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Re: Default Attachments in gallery

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
R Bakker 725 on at

Like (0)

Report

Re: Default Attachments in gallery

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.
v-xiaochen-msft on at

Like (0)

Report
Re: Default Attachments in gallery

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