Good night, I'm trying to filter a spreadsheet that is on one drive and then create the csv to send by email, I tried to filter using Filter Query but it didn't work I used "PROGRAM: eq 'BBB21'" then I tried using the filter but neither it worked I used "PROGRAM: is equal to BBB21" and it also didn't work, would you know why it's not working? where am i going wrong?
Guys, I managed to use the filter changing to "starts with" but now I don't understand how I can take this body and filter the columns or create a CSV, I tried making a compose but I still can't get the values of the columns to choose which one be inside my csv, in the figure below i can see the fields in the table but not the compose, would you know why or am i doing something wrong?
Hi @Supersan123 ,
The output of Filter array is an array which you can directly use in Create CSV table to create table of your choice with required columns. Then after that you can use the output of Create CSV table in creating file.
@ManishJain thank you very much for the answer, I had a question about building the csv using the filter because it does not let me select what is in the body, is it possibility?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.