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

Error On Compose Inputs

Hi Everyone

 

Hope you can help with this error that im having

 

Im connected to an Excel File hosted in Sharepoint.

Heres what i have so far

 

ohraytyroo-1_0-1598041919608.png

 

The compose step has this formula.

ohraytyroo-1_1-1598041987207.png

 

The First Email is a column on the excel file that I'm connected at.

it has a yes or no value that i need for the condition later down the line.

ohraytyroo-1_2-1598042125649.png

 

Im not sure why im getting this error.

 

4 REPLIES 4
Highlighted
Helper I
Helper I

Re: Error On Compose Inputs

@abm this is a continuation of the previous post that i have. can you help me out on this one ?

Highlighted
Super User III
Super User III

Re: Error On Compose Inputs

Hi @ohraytyroo-1 

 

So in your compose why you checking output is No? Generally the length returns numeric.

 

image.png



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
Highlighted
Helper I
Helper I

Re: Error On Compose Inputs

RIght any idea which function i should use? 

i just need to get all the rows from the excel that has a "NO" value in the output?

Highlighted
Super User III
Super User III

Re: Error On Compose Inputs

Hi @ohraytyroo-1 

 

If you looking to filter the rows please have a look at this blog.

 

https://mydevexperience.wordpress.com/2019/09/25/microsoft-flow-excel-list-rows-present-in-a-table/

 

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

Helpful resources

Announcements
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.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

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