Answered

PowerApps If IsBlank() condition with SharePoint Attachment lookup

(0) Share

Report

Posted on by PowerUser39

Hello,

I am trying to lookup a SharePoint list attachment column and set a field's visibility accordingly but the below code is not working and throwing "The specific column is not accessible in this context". I tried with 'Has Attachments' too but getting different errors.

If(IsBlank(""),
With(
{
wRecord:
LookUp('SharePoint List', ID = BrowseGallery1.Selected.ID)
},

If(IsBlank(wRecord.Attachments), true, false)

)
)

All other columns work perfectly without any issues. How to get this fixed?

Please help.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

rpersad 831 on at

Like
a
(0)

Report
Copy link

Link copied!

This issue has been solved: https://powerusers.microsoft.com/t5/Building-Power-Apps/Empty-Attachments/td-p/179806
PowerUser39 73 on at

Like
a
(0)

Report
Copy link

Link copied!

@rpersad Thanks for your response but still getting same error even using IsEmpty.
Verified answer

PowerUser39 73 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it fixed by using 'Has attachment'. Initially I had A caps in the attachment when tried.

If(IsBlank(""),
With(
{
wRecord:
LookUp('SharePoint List', ID = BrowseGallery1.Selected.ID)
},
If(IsBlank(wRecord.'Has attachments'), true, false)
)
)

All good now!