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

Comparing nvarchar from SQL database to text value from Excel always returns False

Hi there,

 

I'm adding data from an excel table to a database but when doing so I need to compare a dollar amount extracted from the database with a dollar amount from the excel table. The data type of the value from the database is nvarchar(10). 

My issue is that even when the values are the same, condition is equal returns false. See screenshots below:

 

Any help or suggestion on how to properly compare the values is greatly appreciated !

 

Screen Shot 2020-11-27 at 6.13.16 pm.pngScreen Shot 2020-11-27 at 6.17.06 pm.pngScreen Shot 2020-11-27 at 6.17.14 pm.png

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,602)