Topics Covered

Enable Module
Create List
Import Power Automate Flow
Available columns

Target Users
Directory administrators

Required Permissions
Administrators

What is the ATLAS Directory SharePoint API module?

The SP API creates a SharePoint list in an ADG subsite, this list syncs with ATLAS Directory contacts (all or part of them depending on your settings). By setting up a Power Automate Flow in your environment, this list will be synced with your own SP list located in your SP subsite and ready for use with your own applications (Power Apps, Web Parts, Power BI). This list also includes the picture in base64 format, the supplied PA Flow will also generate a JPG version as an attachment to the SP List item.

Enable Module

Module must be enabled by ADG Support, please submit a request for your post by emailing to adg-support@state.gov.

Source SharePoint List

The source SharePoint List is automatically created once the module enabled, please allow at list 24 hours for the list to be created and populated with values. The source list can be accessed here. The list has 2 views (All items, Deactivated Contacts), the latter is filtered on the active column to show only deactivated contacts.

Import Power Automate

To be able to sync your SharePoint List with the ADG source list, you must import and turn on the below Power Automate Flow package in your environment: 

ADG-Directory SP API-Posts Flow version With Update_v5

Please follow the instructions to setup the Flow (note also that it's scheduled to run every 24 hours).

Step 1

Download MS Flow .zip file, provided to you by ADG.

Step 2

From the browser, click the Microsoft Office Suite waffle > Power Automate.

Step 3

From the left menu bar, select My flows.

Step 4

Click Import, from the top menu bar and select Import Package (Legacy). 

Step 5

Upload the Flow file (the MS Flow .zip file from Step 1).  

Step 6

Click the Action icon, in the Choose Your Import Option section.

Step 7

From the Setup dropdown, select Create as New and then click Save. 

Step 8

Under Related Resources, select your account and click Save.

Step 9

In the new window, click Import.

Step 10

Once the import is complete, click Open Flow.

Step 11

Under Destination List URL(FIRST INPUT), type your SharePoint site address. Make sure you add the URL only, do not create your own list as the Power Automate Flow will take care of it.

Step 12

Under Source Directory Name > Value (SECOND INPUT), enter the name of your post. It must match the name in the ADG source SP List.

Step 13

Select the Turn On button and then click Run.

Your import is now complete!

Optional Flow Modification: Deleting Items Actions

If you do not wish for your destination SharePoint List to perfectly mirror the ADG source SP List—specifically regarding contact deletions—you may need to modify the imported flow before running it.

Instruction for Customization.

After completing Step 10 and clicking Open Flow, navigate to the flow's actions and delete the below action.

This prevents contacts that have been removed in the ADG source list from being deleted from your destination list when the flow runs.

Available columns

Currently the available columns are the following:

• nameLastFirst
• lastName
• firstName
• middleName
• agency
• post
• title
• positionTitle
• positionNumber
• icassCodePosition
• icassCodeEmployee
• section
• building
• floor
• room
• employmentType
• primaryEmail
• personalEmail
• primaryPhone
• workCellPhone
• workOfficePhone
• contactType
• supervisor
• supervisorEmail
• active
• picture
• arrivalDate
• departureDate

Useful links

Additional information: adg-support@state.gov

For additional help, please contact ADG Support by selecting the ‘Submit a request’ button at the top of the page or by emailing adg-support@state.gov.
Visit the Global Application Portal (GAP) for the latest news and information on all the ADG's applications.