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:

Connecting to Data

PA_error.png

All responses (2)

Answers (1)

Verified answer

kdavies1966 on at

Like (0)

Report

Re: The specified column is not accessible in this context

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));
v-mengmli-msft on at

Like (0)

Report

Re: The specified column is not accessible in this context

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