How to Use “My Lists” from Microsoft Lists in Power Automate Flows

I wasn’t sure how to use lists saved in “My Lists” on Microsoft Lists with Power Automate automatic triggers or actions, so I did some research.

スポンサーリンク

Three Storage Locations for Lists Created in Microsoft Lists

Lists created in Microsoft Lists can be saved in one of the following three places.
*Note: SharePoint Online (SPO) sites and Teams teams share the same location, so effectively there are two.

  • SharePoint Site
  • Teams Team
  • My Lists (personal lists)

Where Microsoft Lists are stored

Since I didn’t know how to handle lists stored in “My Lists” from Power Automate, I looked into it.

Where Personal Lists Are Stored

When you save a list in Microsoft Lists to “My Lists,”
Personal List example in Microsoft Lists
it turns out the list is actually saved in OneDrive.
Personal Microsoft List stored in OneDrive

Because of this, these lists do not exist on SharePoint, and currently, Power Automate does not offer triggers or actions specifically for Microsoft Lists. Therefore, when you want to access these lists from Power Automate, you’ll need to use some workarounds.

Setting Up a Power Automate Trigger

Let’s try setting up a list saved in “My Lists” as a trigger in Power Automate.

Since the only way to use “My Lists” in Power Automate is to directly specify the list URL, copy the relevant list’s URL up to the “…/Lists” part.
Copy My Lists URL
Next, add a trigger for any SharePoint list in Power Automate.
Add SharePoint list trigger
Choose [Enter custom value].
Select Enter custom value
Paste the URL you just copied. Your list saved in “My Lists” will now appear under [List Name].
Paste URL to display My Lists
Now, you can work with it just like a regular SharePoint list item.
Handle My Lists like normal SharePoint list
When the trigger fires,
Trigger fires for My Lists
the flow will run successfully.
Flow runs successfully with My Lists

Setting “My Lists” as an Action

To set a “My List” as an action, simply paste the list’s URL into the “Site Address” field and select the desired list. You can then handle it just like a regular SharePoint Online (SPO) list.
Set My Lists as an action in Power Automate
Once you run the flow, it will execute successfully.
Power Automate flow runs successfully with My Lists action
Flow result with My Lists action

So, when you save a list to “My Lists” in Microsoft Lists and want to use it from Power Automate, simply specify the list’s URL directly.

Related Articles

コメント

Copied title and URL