Hi,
I am trying to create a flow in power automate web. I have a table in SQL Server which holds varbinary(16) type values which represented as hexadecimal (e.g. 0x000D3A4400AA1EDD97CC4C5E2FFCE0DC). I read them with SQL Server - Get Rows(V2) action and as i checked they are saved as Base64 format in Power Automate(e.g. AA06RACqHt2XzExeL/zg3A==). So when i try to reach another table (which has same varbinary(16) field) with Get Rows(V2) and apply filter query, it compares my first varbinary value which is Base64 format now and hexadecimal value in another table. Therefore i cant get a match. My question is: is there a way to convert Base64 value to Hexadecimal?
(OBJNR is in hexadecimal format = 0x000D3A4400AA1EDD97CC4C5E2FFCE0DC)
