Power Platform Community Forum Thread Details

Hi all,

I am using 'Find records (v3)' Business Central connector in a Flow to connect to customers table. The retrieved result contains only a few fields. I am particularly after ABN field (under registration section).

Can someone please help me in getting the field value in the response in power automate?

Currenlty the data retrieved by Flow via Business Central is :
[
{
"@odata.etag": "W/\"JzQ0O1cyRU9YxxxxxxxrcFZXSDU5U0hyZEtGbm5SNUhyVWdPWldXaWpmY3JYWxxxxxxxxx\"",
"ItemInternalId": "xx-a8ba-ea11-a813-xx",
"id": "f8bcfe14-a8ba-xx-a813-xx",
"number": "xxxx",
"displayName": "xxxxx",
"type@odata.type": "#Microsoft.NAV.contactType",
"type": "Company",
"addressLine1": "36 CLARKE CRESCENT",
"addressLine2": "",
"city": "xxx",
"state": "xx",
"country": "xx",
"postalCode": "5652",
"phoneNumber": "xxxxxxx",
"email": "xxxxxxxxxx",
"website": "",
"salespersonCode": "xxxxxxxxx",
"balanceDue": 12342.95,
"creditLimit": 0,
"taxLiable": false,
"taxAreaId": "xx-xx-ea11-a813-xxx",
"taxAreaDisplayName": "",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "AUD",
"paymentTermsId": "xxxx-7bba-xx-a813-xxx",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "xxxxx-84ba-xx-a813-xx",
"blocked@odata.type": "#Microsoft.NAV.customerBlocked",
"blocked": "_x0020_",
"lastModifiedDateTime": "2022-05-05T03:00:58.027Z"
}
]