Tuesday, July 13, 2021

Power Automate (Flow): Limit Columns by View

How to use the "Limit Columns by View"

App: Power Automate 

You may have tried to use the "Limit Columns by View" field and received something similar to: 

Error code: '400', Message: 'List View Not Found clientRequestId: 422C5F17-1C1B-46CD-AE5E-E3E2865D89D5 serviceRequestId: 422c5f17-1c1b-46cd-ae5e-e3e2865d89d5'. Client request id: '422C5F17-1C1B-46CD-AE5E-E3E2865D89D5'

Solution: You can't use the view name. You need to get the view ID (GUID).

  1. Browse to your list.
  2. Go to the view.
  3. Click on the view name.
  4. Click on "Edit current view".
  5. In the address bar you'll see something similar to: sharepoint.com/sites/dev/_layouts/15/ViewEdit.aspx?View=%7B8676E46D-E1C7-4A70-N2N2-BC7289A06F75%7D&List=%7BF413A77B-2EAF-4560-AAEE-EA904070318C%7D
  6. I've highlighted the part that you need to find in your URL. It's between the "View=%7B" and "%7D&List". This is the ID of the View. This is what you need for the "Limit Columns by View" field.