Set PrimaryAddressLocation when creating Employee

(0) Share

Report

Posted on by Jorge_

Hi,

I'm very new to F&O and I'm building a Power Automate Flow to create a new Employee, and add an address to that employee. There are a list of existing addresses in the system to choose from.

I have done that actions manually, and I see after assigning an address, following fields are modified on the employee record.

AddressLocationRoles": "Delivery;Payment",
PrimaryAddressLocation": 5637145328, 
AddressValidFrom": "2019-01-23T13:06:31Z",
AddressCountryRegionISOCode": "CL",
AddressLocationId": "000005902",
AddressState": "13",
AddressCity": "GANDIA - VALENCIA",
AddressNameDescription": "SpA",
AddressStreet": "Av. Real",
AddressCountryRegionId": "CHL",
AddressCounty": "1301", 
AddressValidTo": "2154-12-31T23:59:59Z",

If I do set that details when creating an employee in Power automate, the address is added correctly, I can query CustomerPostalAddresses to get address details, but I'm NOT able to get values for PrimaryAddressLocation on any table.

If I don't set PrimaryAddressLocation when creating the employee, the address is added, however is added as a new address, and not as the predefined/existing address in the system.

Do you know where can I find that column/field?

Researching I see some people mention LogisticsPostalAddress table, however I cant find that table on my F&O system using Power automate.

All responses (3)

Answers (0)

Jorge_ on at

Like (0)

Report

RE: Set PrimaryAddressLocation when creating Employee

Hi Andre Arnaud de Calavon

What I meant is from the address section, click on More Options, select other, that shows existing address in the

system. (Uploaded a screenshot)

And I would like to retrieve their PrimaryAddressLocation value.
André Arnaud de Cal... 294,099 Super User 2025 Season 1 on at

Like (1)

Report

RE: Set PrimaryAddressLocation when creating Employee

Hi Jorge,

What do you mean with "There are a list of existing addresses in the system to choose from.", "I have done that actions manually,

What exactly did you share with the list of fields with values? Where is that coming from? Power Automate history or is it something you compiled from the Dynamics 365 F&O database?

The LogisticsPostalAddress is a physical table in the database. For Power Automate, you can interact with the table using data entities like WorkerPostalAddressV2
Jorge_ on at

Like (0)

Report

RE: Set PrimaryAddressLocation when creating Employee

in the Ui addres is added with Select other option