web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 9w6UOu5YNPf+A0wZLq+cUz
Power Automate - Using Flows
Unanswered

Action 'Select_remove_blank_line' failed

Like (0) ShareShare
ReportReport
Posted on 6 Feb 2023 12:28:45 by 43

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.'.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow