Answered

The specified column is not accessible in this context

(0) Share

Report

Posted on by kdavies1966

Hi all,

Bit of a strange one today. I have two dataverse tables; SupplierInvoiceHeader and SupplierInvoiceLines.

SupplierInvoiceLines has a Many-to-one relationship to SupplierInvoiceHeader and the lookup works when checking the data in dataverse directly.

However, when I start building a collect statement to build a collection for the gallery I get the error 'the specified column is not available in this context' before I start adding columns to filter (see attached screenshot).

I have tried removing and re-adding the tables, and restarting the PA editor but it keeps coming back. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @kdavies1966 ,

Could you please show the full formula? Including types of columns.

It would be better to explain what you are using this formula for.

Best regards,

Rimmon

Was this reply helpful? Yes No
Verified answer

kdavies1966 on at

Like (0)

Report
Copy link

Link copied!

Hi Rimmon,

Thanks for the quick reply!
The code was to select all of the lines for the headers that had previously been selected, and I was attempting to build the following statement;

ForAll(RenameColumns(collAppHdr, "crf5f_sihidkey", "hID"),
Collect(collApprovals, Filter(SupplierInvoiceLines, SupplierInvoiceHeader.SIHIDKey="hID))

with the intention of then adding columns to bring in some additional values from the related header record.

However, I decided to changetack and removed the ForAll around the collect and I was able to successfully use the following code;

ClearCollect(collApprovals, AddColumns(Filter(SupplierInvoiceLines, SupplierInvoiceHeader.SIHIDKey in Distinct(collAppHDR, SIHIDKey)), "INVDisplayNotes", "N",
"INVDeliveryContact", Project.PRAssignedto,
"INVSalesContact", Project.PRSalesContact,
"SIHReference", SupplierInvoiceHeader.SIHReference,
"SIHPayTech", SupplierInvoiceHeader.BKPartner.TDSearchCode,
"SIHStatus", SupplierInvoiceHeader.SIHStatus,
"SIHDescription", SupplierInvoiceHeader.SIHDescription,
"PO_IDs", PurchaseOrder.POIDKey));

Was this reply helpful? Yes No