CSV connector in logicApp.

Question

CSV connector in logicApp.

Lubdha Dolas 121

I did not want the headers in the csv table. but if I remove the headers I don't get the "," in-betweens. The logic app automatically removes the blank rows. We need the output as

abc,def,123,100010,,,,,,,,,,123,,,,N

but the output is readjusted by the logic app itself to:
abc,def,123,100010,123,N

How do I achieve the desired output?

Answer accepted by question author

0 additional answers

Your answer

Answer 1

MayankBargali-MSFT 70,991 Moderator

@Lubdha Dolas Please make sure to verify the output of the action which you are using you are using as input for From parameter of Create CSV table. If you are not using the header i.e. empty value then you need to make sure that you have defined the custom header in the same way of the return value of your From parameter action.

Workflow:

Output:

Lubdha Dolas 121 Reputation points

2022-01-31T13:32:17.63+00:00

@MayankBargali-MSFT the issue is automatically flow is changed . The logicApp is automatically removing the blanks.
{
"value": "@item()['dataCells'][6]?['label']"
},
{
"value": "@item()['dataCells'][3]?['label']"
},
{
"value": ""
},
{
"value": ""
},
{
"value": ""
},

Is automatically changed to :
{
"header": "",
"value": "@item()['dataCells'][3]?['label']"
},
{
"header": "",
"value": ""
},
{
"header": "",
"value": ""
},
{
"header": "",
"value": ""
} its auto removing the values which are blank.

MayankBargali-MSFT 70,991 Moderator

@Lubdha Dolas Can you share the sample input/file and excepted output so I can test the same at my end along with your workflow screenshot. In the example that I have shared if I changed my input to below i.e. some properties are missed or empty value then still I am getting the right output and I don't see any value removing if blank. It will depend upon how you have defined the custom column value and header (if any).

Input:

[  
  {  
    "PSComputerName": "",  
    "PSShowComputerName": true,  
    "new": "test"  
  },  
  {  
    "PSComputerName": "localhost",  
    "PSShowComputerName": true,  
    "PSSourceJobInstanceId": "286eeccb-c7f6-4afd-a734-7f4e837ffdac",  
    "Success": true,  
    "VM": "MyVM1",  
    "new": "test"  
  },  
  {  
    "PSComputerName": "",  
    "PSShowComputerName": false,  
    "PSSourceJobInstanceId": "",  
    "Success": true,  
    "VM": "",  
    "new": ""  
  }  
]

Output:

,True,,,,test  
localhost,True,286eeccb-c7f6-4afd-a734-7f4e837ffdac,True,MyVM1,test  
,False,,True,,

Share via

CSV connector in logicApp.

0 additional answers

Your answer