cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vivekmurli
Frequent Visitor

Get and Replace NULL/Blank values in SQL Server column with a string "NA" and store it in an array

Hello All,

I have developed a flow to get columns from a SQL Server using Get Rows V2 connector.  The end Goal is to replace the NULL or Blank values with a String "NA" in a column and store them in a Separate array variable to be used in Create HTML Table action.

Referred to the articles below with no luck
https://powerusers.microsoft.com/t5/General-Power-Automate/Replace-null-with-a-value/td-p/706031
https://fredrikengseth.medium.com/replace-special-characters-in-a-string-with-power-automate-fe57a26... 

Please let me know if you need more information.

Any help would be appreciated

@ClavinFernandes @RezaDorrani 

Thanks,
Vivek


0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,821)