Power Platform Community Forum Thread Details

Action 'Select_remove_blank_line' failed

Please help how to fix below issue...

The execution of template action 'Select_remove_blank_line' failed: The evaluation of 'query' action 'where' expression '@json(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(string(item()), '"##', ''),
'##":"",', ''),
'~|', ''),
'&^', ''),
'&`', ''),
'^<', ''),
'##":""}', '}'),
'null', '""'))' failed: 'The template language function 'json' parameter is not valid. The provided value '{"PK":"IC232B134","0":"K2022","1":"OKR","2":"OKP 5055","3":"Gajanan B.","4":"Siddharth S.","5":"1203737","7":"BANDU BHUJANGRAO S.","8":"AKOLA D.","9":"","10":"DRIP & MULCH","11":"44723","12":"44729","13":"780","14":"2275","15":"GG","16":"0.25","17":"113.21","18":"Good","22":"44762","24":"44767","26":"44768","27":"Good","28":"YES","29":"Good","30":"95","31":"NOT NOTICED","36":"44800","37":"44803","38":"44815","39":"3","40":"12","41":"2275","42":"12","43":"58","44":"42","45":"95","46":"Good","47":"44865","48":"NOT NOTICED","52":"RG","53":"Good","54":"87",^|~<|^~<|~<|~|<~~<~<|<^~^~<^|<^<^^^|<~<^~^<~<~<^|<~<^~~^|~^|~<<<<^^|~~^~<^||~~<^^~^|<~^|~^|^~<^^^~<|<|^<~~~<^^|^^|<^^|<~^^|~|<<~<~<~<|<~^||<<^^<~^^|~~<^^|"90":"0",~^^|<<~~"92":"RG"}' cannot be parsed: 'Invalid property identifier character: ^. Path '54', line 1, position 573.'. Please see https://aka.ms/logicexpressions#json for usage details.'.