Share
Report
10We need to update the BC Sales Header data (Document Date, Package Tracking No.) using Power Automate.
We have created an API Page to expose the required fields from the Sales Header table, part of the source code is shown below.
In Power Automate, firstly, we leveraged the filter query in the /Find records (V3)/ connector to find the target record.
After that, we used the /Update record (V3)/ connector to update the corresponding columns (defined in the API Page) of the target record, however, the update connector failed with the error: /1 of 2 keys provided for lookup, provide keys for only DocumentType,No./
We also tried the /Get record (V3)/ connector, which resulted in the same error.
In the connectors, we are using the /Row id/ to specify the corresponding record, which was retrieved from the /Find records (V3) connector, however, the error details reveal that we need to specify the primary key (DocumentType and No.) of the Sales Header record. But there is nowhere we can enter the primary key value in the connectors.
So my question is, is the /Update Record (V3)/ connector capable of updating data in the Sales Order table?
What is the reason and how to fix the /1 of 2 keys provided for lookup, provide keys for only DocumentType,No./ problem?
Please help & Thank you!
We have created an API Page to expose the required fields from the Sales Header table, part of the source code is shown below.
In Power Automate, firstly, we leveraged the filter query in the /Find records (V3)/ connector to find the target record.
After that, we used the /Update record (V3)/ connector to update the corresponding columns (defined in the API Page) of the target record, however, the update connector failed with the error: /1 of 2 keys provided for lookup, provide keys for only DocumentType,No./
We also tried the /Get record (V3)/ connector, which resulted in the same error.
In the connectors, we are using the /Row id/ to specify the corresponding record, which was retrieved from the /Find records (V3) connector, however, the error details reveal that we need to specify the primary key (DocumentType and No.) of the Sales Header record. But there is nowhere we can enter the primary key value in the connectors.
So my question is, is the /Update Record (V3)/ connector capable of updating data in the Sales Order table?
What is the reason and how to fix the /1 of 2 keys provided for lookup, provide keys for only DocumentType,No./ problem?
Please help & Thank you!
All responses (
Answers (
