Create File doesn't contain outputs as shown in successful test

[DexPoint]

i've created a flow to read an excel table and filter the rows by two columns. then i've done a select statement to get specific data mappings in the form i want (maybe wrong? maybe i should build an array? - not sure?)

when i run the flow its looks like its working correctly, it gives me all the data  mapps the column headers, even shows the file content is correct. but when i open the file i get repeats of the select operation without the data being mapped in. just the text. see all images of flow.

Here the output looks good / accurate per the data from the file

Here the file Content also looks good 

here is what i actually get, which is not any of the data.

the data listed here is actually the 2nd row in my list, i'm not sure why its printing the second row data vs the row that i have filtered.

Here is the details of the loop - in this scenario i only have 1 record but it could be more which is why i have the loop.

the concat formula is all about formatting, in excel its a text field that is coming across as '41052' (or very close)

[Pstork1]

I think the problem is because you are doing the data select and creating the CSV table etc inside a loop.  Why are you using the Apply to each and what are you looping on?  To do what you want it should just be a filter array followed by a parse JSON, then a data Select on the output of the Parse JSON, then create the CSV and build the file.  I think you are doing the loop because you are missing the parse JSON.

[DexPoint]

my attempt was to read the rows of data.

find the rows that have data in column 25 and no data in column 26 - this is the filter array 

@And(not(empty(item()?['Column25'])), empty(item()?['Column26']))

then i want to pull specific data columns from the rows for the records that match the filter criterial (i believe it forced me to add the "Apply to each" logic when i added the next action. 

once i have the data with the mappints (The Select statement) i want it to write them out. / create a CSV file.

This was the intent of the flow.

I'll give an attempt at the Parse JSON and then select statement etc.

[Pstork1]

The problem is that after you do the filter array the output is an array of rows, but you don't have access to the individual columns as dynamic content. That's why you need the Parse JSON. Then you can do a data select on the output of that, which is the filtered array, and create the CSV. I think you are getting the apply to each because you are accessing the fields from the original list rows instead of the filtered rows.

[DexPoint]

I'll rebuild using parse JSON then continue the rest of the flow per your steps., i've never used this before and i just tried to enter the scheme and i think its failing. so i'll do some research on this. not sure exactly what to enter in but i'll bet there are a lot of questions on it.

[Pstork1]

For Parse JSON just take the output of the filter array from a previous run and paste it into the Generate sample Schema button on the parse JSON.  That will create the schema for you.

[DexPoint]

Thats what i did, but its failing. i tried changing the "Object" to "Array" and then i get different errors. So now i'm trying to figure out why.

    "message": "Invalid type. Expected Object but got Array.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "",

    "schemaId": "#",

    "errorType": "type",

    "childErrors": []

[DexPoint]

Ok, well i've reworked the flow. but for whatever reason i still get the same output.  its much easier than a loop but it isn't writing the data that it shows in the output. 

I've accepted your solution but output is wrong 😞

New Flow

Create CSV Table

Create File

Output file

[Pstork1]

Are you sure you are using the output of the filter array to generate the schema for the Parse JSON?  That should be an array, not an object.

[DexPoint]

Yes. i worked through that issue. i failed to copy the complete selection.

The flow completely works now, but i still get 3 records in the CSV file that aren't the data that was parsed / shown in the outputs of each step.

[Pstork1 · Accepted solution]

Can you show me the output of the Parse JSON and Data Select actions? The steps all look correct, but somewhere the inputs or outputs are off.

[DexPoint]

Attached flow and excel sheet, you can pull it in and see what i've made. i've removed teh data from the excel file but left the flow alone. i just changed the titles in the scheme of the JSON to match that of select statement and its same result. But they were originally "Column1" and i changed to "CloseDate" etc. but this didn't change antyhing.

Here is output from the JSON

[

  {

    "@odata.etag": "",

    "ItemInternalId": "8bc4ca65-72bd-437c-b4e8-0e0dad37f763",

    "Column1": "45106",

    "Column2": "SPE2D623F0GV9",

    "Column3": "WT4J8S",

    "Column4": "USAMMC-K USA MED MATERIAL CTR KOREA",

    "Column5": "CHUNGHUI YI 01038341886",

    "Column6": "BLDG 709",

    "Column7": "CAMP CARROL",

    "Column8": "",

    "Column9": "KYONG-PUK",

    "Column10": "01",

    "Column11": "39886",

    "Column12": "KR",

    "Column13": "1",

    "Column14": "F5402G",

    "Column15": "Rsdl",

    "Column16": "PK",

    "Column17": "1",

    "Column18": "",

    "Column19": "",

    "Column20": "SEP 12 2023",

    "Column21": "",

    "Column22": "WT4J8S 3180 0316",

    "Column23": "Name:  WT4J8S - C- K\nPhone: 01031886\nEmail: chl",

    "Column24": "Y",

    "Column25": "12546",

    "Column26": ""

  }

]

Here is output from the select statement.

 

[

  {

    "RecordTypeId": "0121N000000qsRQQAY",

    "Name": "KR-CCC-SPE2D623F0GV9-WT4J8S",

    "ACCOUNT.SAP_Customer_Number__c": "1000215",

    "StageName": "Award",

    "CloseDate": "29-06-2023 00:00",

    "FLD_SAP_Order_Number__c": "12546",

    "DODAAC_Code__c": "WT4J8S"

  }

]