cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bolin-stratus
Level: Powered On

Simple Question: Filter Query Where Excel Column Name Has a Space

I can get the following filter query to work (shown with space removed) UNLESS I have a space in the Excel column name (e.g., Remediation Responsibility). I have tried both single and double quotes and neither works. Adding "_x0020_" as the space also doesn't wk. Can't Flow accommodate a space in the Excel column name?

// Wks
RemediationResponsibility eq 'Customer'

// Doesn't Wk
'Remediation Responsibility' eq 'Customer'
// Doesn't Wk
"Remediation Responsibility" eq 'Customer'
// Doesn't Wk
Remediation_x0020_Responsibility eq 'Customer'


Flow Filter query with spaces.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Simple Question: Filter Query Where Excel Column Name Has a Space

 

Hi @bolin-stratus ,

 

Unfortunately, the Filter Query in List rows present in a table action does not support the use of fields with spaces in the field name as filter parameters.

This is a known limitation. If you want similar functionality to be supported by MS Flow, please consider voting for a similar idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Have-Consistency-in-on-Filter-Query-and-Order-By-on-E...

 

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Simple Question: Filter Query Where Excel Column Name Has a Space

 

Hi @bolin-stratus ,

 

Unfortunately, the Filter Query in List rows present in a table action does not support the use of fields with spaces in the field name as filter parameters.

This is a known limitation. If you want similar functionality to be supported by MS Flow, please consider voting for a similar idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Have-Consistency-in-on-Filter-Query-and-Order-By-on-E...

 

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,554)