A general example how you can handle this:
Filter for empty items:
@not(or(empty(item()), equals(item(), '\r')))
Create an array of objects
Select From:
@{body('Filter_array')}
Map prop:
trim(first(split(item(), '=')))
Map val:
trim(
replace(
last(
split(item(), '=')
),
'/r',
''
)
)
Filter this array for the desired prop
From: @body('Select')
Filter: @equals(item()['prop'], 'ticket_no')
Finally, check whether the prop exists in the array and return the value if so:
if(
greater(
length(body('Filter_array_2')),
0
),
first(body('Filter_array_2'))['val'],
null
)
