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

Compare Excel value (equal to)

Hi members,

I'm a beginner in Power Automate but experienced in Excel.

I Setup a flow to

list rows present in a table

and apply to each (Output) value

value is equal to CHECK

 

Some of my values in the list have the value CHECK, but I don't get any email message.

The flow to email message is quite easy to  realize, so I thing the failure is in the Excel part.

The Location, libary, file and table I did also correct, so I was estimating my failure is in the comparison of the values to the word CHECK.

Can anybody give me a good advice.

Thanks a lot for your time and help in advance.

 

Best Regards

Klaus

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Compare Excel value (equal to)

Hi @KlausDia 

 

Thanks for your reply. What's your Excel table column name called? Is that called 'value' as well? Most likely your issue might be here? Make sure you are using the  right column name of your excel sheet of value Check.

 

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

View solution in original post

7 REPLIES 7
Highlighted
Super User III
Super User III

Re: Compare Excel value (equal to)

Hi @KlausDia 

 

Could you please post a screenshot of your flow? 

 

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
Highlighted
New Member

Re: Compare Excel value (equal to)

Hi abm,

thanks for your offer to help 🙂

I tried to copy my screenshot, but it seems to be a little tricky at this message format.

With copy and paste it was not working and the download with the source address isn't working too.

Sorry, the next problem then ☹️

 

 

 

 

 

 

 

Highlighted
New Member

Re: Compare Excel value (equal to)

Hi abm,

I fixed it after new Login with my account, here is the screenshot:Compare Excel value for emailCompare Excel value for email

Highlighted
Super User III
Super User III

Re: Compare Excel value (equal to)

Hi @KlausDia 

 

Thanks for your reply. What's your Excel table column name called? Is that called 'value' as well? Most likely your issue might be here? Make sure you are using the  right column name of your excel sheet of value Check.

 

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

View solution in original post

Highlighted
New Member

Re: Compare Excel value (equal to)

Hi abm,

yes, that was it 😀

I did understand the assigning wrong from this field.

Big thanks for your realy fast help, Flownaut.

 

Best Regards

Highlighted
Super User III
Super User III

Re: Compare Excel value (equal to)

Hi @KlausDia 

 

Thanks for your reply.

 

If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

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
Highlighted
New Member

Re: Compare Excel value (equal to)

Hi abm,

 

of course I would like to do that and tried to do so already;

but our security settings from Java Script is blocked and so it seems, I will not be able to do so,

sorry therefor, but I can't change this on my own.

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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