Answered

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

(0) Share

Report

Posted on by DexPoint

191

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)

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DexPoint 191 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DexPoint 191 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DexPoint 191 on at

Like (0)

Report
Copy link

Link copied!

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": []

Was this reply helpful? Yes No
DexPoint 191 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DexPoint 191 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No