cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Expression is invalid when doing Get Item

I have a flow that is called from a PowerApp.  It passes the record ID.

I take this record id and use Get Item to retrieve data from a Sharepoint List.

I then want to go to another Sharepoint List and get the record where CompanyName is equal the Shipped From from the first list.

image.png

 

I have another flow that works perfectly.  Does pretty much the same thing, except I am going to a different file for the second get.  Only differenct is that the filter query is CompanyID eq Shipped From.

 

Any ideas??? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Expression is invalid when doing Get Item

Hi,

 

Add a single quotes between Shipped From mapping field.

 

'Shipped From'

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Expression is invalid when doing Get Item

Hi,

 

Add a single quotes between Shipped From mapping field.

 

'Shipped From'

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Highlighted
Helper I
Helper I

Re: Expression is invalid when doing Get Item

That worked.  Thank you so much!  I'm pretty new to Flow and PowerApps.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

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

Top Solution Authors
Top Kudoed Authors
Users online (3,572)