Text file | Dynamic Attributes™ Update Microsoft 365 Users Properties
Rule description
This rule updates Microsoft 365 user properties based on the values defined in the data source text file. The data source text file must be in the comma or semi-colon separated values format (CSV). This rule updates cloud-only user accounts that are not synced to Active Directory.
Use cases
The rule updated Microsoft 365 user properties if the value of a predefined key attribute matches the user attribute value. For example, if the PostalCode attribute value equals 30301, assign the value Atlanta to the the City attribute. Review the following example:
Create a UTF-8 CSV file.
In the CSV file, name the first column after the predefined key attribute, e.g., PostalCode.
Set up a desired value in the second row of the first column, e.g., 30301.
Name other columns after the changed attributes, e.g., OfficeLocation, StreetAddress, City.
Specify the new values in the corresponding columns. If needed, create a new row to assign other values based on the key attribute value.
PostalCode;OfficeLocation;StreetAddress;City;State
30301;Atlanta;100 Atlantic Blvd;Atlanta;GA
1720*;Chambersburg;100 Washington St;Chambersburg;PARule settings
Query section
| Setting name | Description |
|---|---|
| Select data source |
Specify the text file to be imported. The […] (three dots) button allows the user to browse for the file and the Create/Edit button allows the creation or editing of the existing file in the built-in Data Source editor. |
| Separator used in file | Specify the separator used in the source CSV file. |
| More options | |
| Filter CSV data | Specify a condition to filter data rows from the imported text file. |
| Column name > Attribute mapping |
Map a CSV column name to a custom Entra ID attribute. Use asterisks (*) as wildcards. User commas to separate columns.List all columns to remap. For example, PostalCode>AreaCode,OfficeLocation>City. Matching columns require no formatting. For example, PostalCode>AreaCode,OfficeLocation,Street*,City,State. |
| Empty field in data source |
Specify the action to take if there is an empty field:
|
Action section
| Setting name | Description |
|---|---|
| Script filter | Set the filtering conditions to only return objects or data that must be processed by the rule. |
Output section
This section defines the output format of this rule.
To get more information about this section, please see the Rule Output section article.
Enforce/Schedule section
This section defines the schedule for how often to run the rule.
To get more information about this section, please see the Rule Enforce/Schedule section article.
Comments
0 comments
Article is closed for comments.