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
Community Champion
Community Champion

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
Community Champion
Community Champion

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

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
March Update

Join Stephen Siciliano and the Power Automate team at MBAS

Make sure you are registered #MSBizAppsSummit #CommunityRocks

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (63,343)