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:
However, I will recieve this:
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).
(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.
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.
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.
Details of Apply to each:
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications