cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rich0087
Helper I
Helper I

Filter query Get files - Substringof('30531',Name) - error column name

In the advanced setting in Sharepoint Get Files (properties only) --> I'm using the filter query: Substringof('30531',Name) and I'm receiving the error:

 

Column 'Name' does not exist. It may have been deleted by another user.
clientRequestId: e2399f41-aa8e-4469-abf8-11ab6ca6681e
serviceRequestId: e2399f41-aa8e-4469-abf8-11ab6ca6681e

 

The column does exist. There are only two as shown below.  Name and modified. 

 

rich0087_0-1614963378759.png

 

any ideas why i would be getting this error?

 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Microsoft
Microsoft

Hi @rich0087 

 

Take a look at your list settings and click on the Name field.  It may be that it was called something else and you've renamed it?  The actual name will appear in the URL once you have gone in to edit the field.

 

Damien

View solution in original post

2 REPLIES 2
DamoBird365
Microsoft
Microsoft

Hi @rich0087 

 

Take a look at your list settings and click on the Name field.  It may be that it was called something else and you've renamed it?  The actual name will appear in the URL once you have gone in to edit the field.

 

Damien

rich0087
Helper I
Helper I

@DamoBird365  Thanks! Name wasn't actually there, but I created a new column and copy and pasted the values into there and the filter worked perfectly! 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,914)