cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

The expression ... is not valid

 

I am tryin to use "Copy data between two SharePoint lists " flow and followed the steps at

https://flow.microsoft.com/en-us/blog/copying-using-filtering/  but I ran into "The expression ... is not valid" error.

 

I am using SHarePoint online. I have two lists:

Source List fields:

Field 1 | Field 2 | Field 3| ...

Bw Tools Number | Calibrated Date | Out of Service (Yes/No)| ...

 

Target List fields:

Field 1 | Field 2 | Field 3 | ...

BW Tools Number | Notes | When updated | ...

 What I am trying to achieve is if any item is added or modified in source list and Out of Service field is YES,

add that item in the destination list matching field "BW Tools Number".

 

Here is the error message:

"message""The expression \"'A02.MTW.008'  equal 'BW Tools Number'\" is not valid.\r\nclientRequestId: 5e3444ae-"

 

What am I doing wrong? Any help is appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: The expression ... is not valid

Hi @ yugpatel,

 

Could you please share a screenshot of the configuration of your flow?

 

Which action run failed in your flow with the error that you mentioned?

The error told that the BW Tools Number with value "A02.MTW.008" is not valid.

Please check if every BW Tools Number in the Source List have a BW Tools Number with the same value in the Target List.

 

I would offer you a workaround to update the item in the Target List when the BW Tools Number is exist in the Target List, and if the BW Tools Number is not exist in the Target List , create a new item in the Target List.

 

The screenshot of the flow as below:

1.png2.png3.png

 

When an Item is created or modified in the Source List, if the BW Tools Number is exist in the Target List, the flow would update the item in the Target List as screenshot below:

4.png

 

When an Item is created or modified in the Source List, if the BW Tools Number is not exist in the Target List, the flow would create the item in the Target List as screenshot below:

5.png

 

 

  

Regards,
Alice Zhang

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: The expression ... is not valid

Hi @ yugpatel,

 

Could you please share a screenshot of the configuration of your flow?

 

Which action run failed in your flow with the error that you mentioned?

The error told that the BW Tools Number with value "A02.MTW.008" is not valid.

Please check if every BW Tools Number in the Source List have a BW Tools Number with the same value in the Target List.

 

I would offer you a workaround to update the item in the Target List when the BW Tools Number is exist in the Target List, and if the BW Tools Number is not exist in the Target List , create a new item in the Target List.

 

The screenshot of the flow as below:

1.png2.png3.png

 

When an Item is created or modified in the Source List, if the BW Tools Number is exist in the Target List, the flow would update the item in the Target List as screenshot below:

4.png

 

When an Item is created or modified in the Source List, if the BW Tools Number is not exist in the Target List, the flow would create the item in the Target List as screenshot below:

5.png

 

 

  

Regards,
Alice Zhang

View solution in original post

Anonymous
Not applicable

Re: The expression ... is not valid

Thanks Alice,

I will try to work on your suggestion. I am trying figure out how to upload screen shots. I normally use photobucket but it did not work.

Anonymous
Not applicable

Re: The expression ... is not valid

Your solution worked but I had to change my BW Tools Number field in source list from lookup type to single line text.

With look up field type, I kept getting "Bad Gateway" error and a serch for "Bad Gateway" revealed in one of the post that lookup field type is not supported by SharePoint Flow YET.

Lessons learned.

Thanks for your solution.

Chewitt-1877
Level: Powered On

Re: The expression ... is not valid

Hi,

 

Im trying to do something similar but I am using a sharepoint list as the source and a document library as the target.

 

the flow only has to run the one time to add metadate from the list to the document library.

 

1. When a file is created or modified in sharepoint it triggers the flow

2. the filename is passed to get items from list

3. The true output of condition modified or created filename = sharepoint list file name is to update the file properties with column data from the list

 

each filename is unique and is contained in the sharepoint list, a column contains the full name and extension i.e. "100-010.xls" another column contains the name with out extension i.e. "100-010", the columns in the sharepoint list are  single line of text.

 

when the flow runs in test, I can see the filename i.e. 100-010.xls is passed to the get items from the trigger.

 

the output from the get items, returns a 400 bad request, the expression \"100-010.xls\" is not valid.

 

I've tried different data filters from the trigger in get items but still the same bad request

 

The filename defintely exists in the sharepoint list, I can't see why it won't find it.

 

where am i going wrong?

Chewitt-1877
Level: Powered On

Re: The expression ... is not valid

FlowScreenShot.jpg

Chewitt-1877
Level: Powered On

Re: The expression ... is not valid

showing input / output of get items 

 

 

FlowScreenShot2.jpg

 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,354)