Power Platform Community Forum Thread Details

Hi,

I followed this tutorial on youtube:

https://www.youtube.com/watch?v=sXdeg_6Lr3o

My flow is working although its not working as I would've hoped...so was wondering if somebody could help me figure out what I've done wrong.

I think its to do with some null objects that seem to during after the "splitByLines" step, is there an easy way I can exclude them?

This is the full flow:

Here are the expressions etc I used incase it makes it easier to spot where I've messed up:

splitByLines

split(replace(outputs('Get_file_content_2')?['body'],'"',''),decodeUriComponent('%0D%0A'))

fieldNames

split(first(outputs('splitByLines')), ',')

Select
From:

skip(outputs('splitByLines'), 1)

Map1:

outputs('fieldNames')[0]

split(item(), ',')?[0]

Map2:

outputs('fieldNames')[1]

split(item(), ',')?[1]

trailing quotation marks.png

Here is how the csv is formatted incase its useful:

"SamAccountName","msRTCSIP-Line"
"user.name1","tel:+123456789123"
"user.name2","tel:+123456789124"
"user.name3","tel:+123456789125"
"user.name4","tel:+123456789126"
"user.name5","tel:+123456789127"
"user.name6","tel:+123456789128"
"user.name7","tel:+123456789129"
"user.name8","tel:+123456789130"

Categories:

General topics