CSV multiple rows

(0) Share

Report

Posted on by TBuente

112

Hi all,

I have two questions.

1) Can you create a CSV table that only takes values from one Sharepoint list item?

Currently, this is what I have:

Now sure, this works great, until you have more than one item in a Sharepoint list. If I have more than one item, I will receive an email with the CSV file, but it will contain information for both of these items.

Is there a way to filter which item information is taken from?

2) How can I make multiple values (from different columns in the Sharepoint list) display in the same Excel column, but seperate rows?

This is an example of what I need:

I want values like "Testing" and "Test" to be populated by different Sharepoint list column values.

I have tried this in flows:

csv not want.png

However, I will recieve this:

not want.png

For this example, I typed "123" into Labor Rate 1, "123" into Labor Rate 2, and "123" into Labor Rate 3, but they have been combined together, rather than on seperate rows.

Is there a way I can make these values go to their own seperate rows (NOT COLUMNS, ROWS).

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @TBuente

(1) You can filter Get Items using Filter Query so that it will return only the relevant result you want.
(2) Not sure I understood this correctly. For the Bill Rate you have mapped all the values so by design thats the default behaviour. Why not add more headers Labor Rate1, Rate2 separately? Is that not going to work?

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
TBuente 112 on at

Like (0)

Report

Hi,

When mapping the Labor Rate 1, Labor Rate 2, Labor Rate 3, etc, together, they are on their own seperate columns and rows, like this:

For my situation, I cannot have this. I need them to under a "Labor Rate" Column, and have "123", "123", and "123" on rows 2, 3 and 4.

The reason I need this formatting, is because I am creating an app that allows for users to import a csv into our billing software. There is a strict template to follow in order for importing to work on that software.

Thanks!

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi
Thanks for your reply.
Try to add a compose action. Format that as a string combining all values and output that parameter to csv. Let's see whether that's going to work or not.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report
Hi @TBuente ,

For your first question, you need to use Filter Query to filter the specified item. You could use the ID as a filter.

Like: ID eq 1

For your second question, please try to use the following methods to achieve the requirements.

Initialize an array variable to store the value of each column in a single item. You may not be able to reference Dynamic content when configuring Value.

You can refer to the configuration in the screenshot, first place the specified Dynamic content in Compose, then copy and paste the Dynamic content into the Value, separated by commas.

Then iterate through the array variables and add the column values from the item to the Excel table.

Image reference:

Details of Apply to each:

Best Regards,

Was this reply helpful? Yes No