cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KazzerPBI
New Member

The Expression s6h2 eq <first value of excel-sheet> is not a valid expression

Hi Power Automate community

 

I am trying to set it up, so that once a day a power automate flow checks the table in an excel spreadsheet, and then updates / adds items to a SharePoint list. 

 

I follow this tutorial

Add & Update Excel Data to SharePoint List using Power Automate - YouTube

 

KazzerPBI_0-1626947056102.png

This is the setup. I link the Excel and get the items. This works. Then I try to get the list items from the SharePoint-list, but it returns the error 

The Expression s6h2 (system name of my "Name" column in the SharePoint list) eq "name of first item in excel sheet in Name column" is not a valid expression.

 

Any ideas how to fix this? Replacing the system name of the column in the SharePoint list with the display name didn't help at all.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @KazzerPBI ,

 

You need to escape it by adding another '

 

Have a look at this blog here.

 

Thanks

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

View solution in original post

5 REPLIES 5
eric-cheng
Solution Supplier
Solution Supplier

Hi @KazzerPBI ,

 

Are there special characters in your Excel spreadsheet which maybe breaking the syntax e.g O'Neil

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hi Eric

 

In the spreadsheet there are "-" and "()" in different places. There is also " ' " as you specified actually! Would this break the syntax? and how do I fix it?

Hi @KazzerPBI ,

 

I ran a few tests and it didnt seem to.

 

Can you add a Compose action before the Get Items and show me the output/value of name?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hi Eric

 

I edited my reply, because I realized later on it actually did have apostrophes in the names in some places. How do I get around this? The list will have around 250 values at some point, possibly including special characters

Hi @KazzerPBI ,

 

You need to escape it by adding another '

 

Have a look at this blog here.

 

Thanks

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,251)