Solved: Filter Get items by Excel Column not working

wlyttle · ‎05-24-2022

I have an Excel sheet with a table that contains many columns but I just have the "Device Name" column populated. I want to use those device names to filter a "Get Items" on a SP list. I keep getting errors like - Column 'aa1' does not exist..

I have tried a few variations on the filter but I just can't seem to make it work.

ScottShearer · ‎05-24-2022

@wlyttle

First, you need to add single quotes around the reference to Device Name.

Here is a link to most everything that you need to know about using Filter Queries.

If you have additional questions, post here.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

ScottShearer · ‎05-24-2022

@wlyttle

First, you need to add single quotes around the reference to Device Name.

Here is a link to most everything that you need to know about using Filter Queries.

If you have additional questions, post here.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Filter Get items by Excel Column not working

Helpful resources

Join us for Microsoft Power Platform Conference

A new place to submit your Ideas for Power Automate

Register for a Free Workshop

Ask your licensing questions at the Power Automate AMA!