Power Automate flow - substring Expression with condition

Question

i have big trouble with simple expression with substring.

My goal is merge two sharepoint list to one excel table. And problem is when value is empty that flow crash.

is possible create expression with If statemant, when value is empty, do nothing ?

String

1980034 - John Wick

expression result:

1980034

{
  "id":@{substring(item()?['listItem1'],0,indexOf(item()?['listItem1'],'-'))}
}

Expression works, but when value missing flow crash

In which action you are using this expression? What should be the default value for id if expression returns empty result? — Ganesh Sanap - MVP
– Ganesh Sanap - MVP, Commented Dec 7, 2022 at 12:01
when listItem is NULL i need if statement to do nothing, when is not null do substring — Novice
– Novice, Commented Dec 7, 2022 at 12:06
Can you try using either of these expression? if(empty(item()?['listItem1']), '', substring(item()?['listItem1'],0,indexOf(item()?['listItem1'],'-'))) — Ganesh Sanap - MVP
– Ganesh Sanap - MVP, Commented Dec 7, 2022 at 12:13
if(empty(item()?['listItem1']), null, substring(item()?['listItem1'],0,indexOf(item()?['listItem1'],'-'))). Let me know if this works for you. — Ganesh Sanap - MVP
– Ganesh Sanap - MVP, Commented Dec 7, 2022 at 12:14

Ganesh Sanap - MVP · Accepted Answer · 2022-12-07 12:35:36Z

1

Try using either of these expressions:

if(empty(item()?['listItem1']), '', substring(item()?['listItem1'],0,indexOf(item()?['listItem1'],'-')))

OR:

if(empty(item()?['listItem1']), null, substring(item()?['listItem1'],0,indexOf(item()?['listItem1'],'-')))

answered Dec 7, 2022 at 12:35

47.3k22 gold badges32 silver badges64 bronze badges

1 Answer 1