Lists

Working with SharePoint Lists in Power Automate.

Get items step

I used this step to import email addresses from a SharePoint List (directory).

Useful resources

• Microsoft Community Post

Filter Query

We can use the Filter Query option to import a subset of rows from a SharePoint list. For example, I wanted to import only rows that had a value of "Yes" for a column named Check-in.

We first ran the flow passing the value value returned by the Get items step to a Compose step. We did this to see how the data was named/structured.

Here is a snippet from what was returned.

"Profile#Claims": "i:0#.f|membership|michael.b.cannell@uth.tmc.edu",
"Check_x002d_in": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": 0,
    "Value": "Yes"
},
"Check_x002d_in#Id": 0,
"Active": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": 0,
    "Value": "Yes"
},

So, we want to filter for rows where the "Value" of "Check_x002d_in" is "Yes". Here's how we can do that.

Check_x002d_in eq 'Yes'. It's the column name without quotes, the operator, and then the filter value.

Here is a blog post that helped me figure out the correct syntax to use for filtering.

Here is a YouTube video that helped as well.

Synchronizing SharePoint Lists

We are keeping multiple personnel directories in sync. We want one master directory and then multiple subordinate directories for each project/team.

Helpful blog post