cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisDMU
Frequent Visitor

Filtering a New HTML Table

Hi All,

 

I am currently building a flow that takes a list of bookings into a table and then emails a daily schedule to each Team member (Interviewer) of the interviews they have each day.

I have the html table built and it attaches to the email okay, but I want to be able to send different tables to different people.

I have tried a few ways to filter the table but none seem to work and each email just sends a full list.

Something I'm doing wrong (most likely!)?

 

See attached flow.. output I would like to be Sophie gets an email showing her bookings, Chris gets one showing his bookings.

 

ChrisDMU_0-1676996701887.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Without knowing the structior of all the data it is difficult to answer. But here you have a sample of how I would build the flow.

 

{"id":"a06bd189-468e-4e26-8f22-c4159561c014","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"Scope_Email","operationDefinition":{"type":"Scope","actions":{"Compose_People":{"type":"Compose","inputs":[{"Name":"Chris","Email":"Chris@whatever.com"},{"Name":"Sophie","Email":"Sophie@whatever.com"},{"Name":"Michael","Email":"Michael@whatever.com"}],"runAfter":{}},"Compose_Sample_Data":{"type":"Compose","inputs":[{"Interviewer":"Chris","Info":"This is a task for Chris"},{"Interviewer":"Sophie","Info":"This is a task for Sophie"},{"Interviewer":"Chris","Info":"One more for Chris"},{"Interviewer":"Sophie","Info":"And one more for Sophie"}],"runAfter":{"Compose_People":["Succeeded"]}},"Apply_to_each_Person":{"type":"Foreach","foreach":"@outputs('Compose_People')","actions":{"Filter_Tasks_for_Person":{"type":"Query","inputs":{"from":"@outputs('Compose_Sample_Data')","where":"@equals(item()['Interviewer'], items('Apply_to_each_Person')['Name'])"},"runAfter":{}},"Compose_Mail":{"type":"Compose","inputs":"Here you send a mail to @{items('Apply_to_each_Person')['Name']} (@{items('Apply_to_each_Person')['Email']})\n\nNumber of Interviews for today: @{length(body('Filter_Tasks_for_Person'))}\n\n@{join(body('Select_Info_from_Task'), '\r\n')}","runAfter":{"Select_Info_from_Task":["Succeeded"]}},"Select_Info_from_Task":{"type":"Select","inputs":{"from":"@body('Filter_Tasks_for_Person')","select":"@item()['Info']"},"runAfter":{"Filter_Tasks_for_Person":["Succeeded"]}}},"runAfter":{"Compose_Sample_Data":["Succeeded"]}}},"runAfter":{}}}

I hope this clears some things up. Just put it in a new testflow and run it.

 

Of course you have to select some other input and create formated different output but the way to go should be clearer. And you can turn on "Concurrency Control" to speed things up.

View solution in original post

10 REPLIES 10

Hello @ChrisDMU 

 

You use „Filter array“ but in the select action you use the wrong input. Try to use the output of „Filter array“ instead of the „HTML Table“.

Hi Matthy, the output of Filter Array is "Body".. I tried that but still no filtering happens.

ChrisDMU_0-1677066259748.png

 

Hello @ChrisDMU 

 

The filter array action doesn't contain an item value in the condition. So in this case it goes through all the items and check if the variable "Interviewer" contains "Chris". If it does, every item from "HTML Table" would be in the result. If it doesn't the array would be empty.

 

You have to put in some information of each item to compair to. Like "@equals(item()['Interviewer'], variables('Interviewer'))"

Matthy79_0-1677068319900.png

Change the "filter array" action and resubmit the flow. Check the output of "filter array" by using the flow history. You also don't need the "Select" action I think because you don't want to change anything, do you?

Thanks Matthy,

It seems to have worked, but not quite sure how, as I have not put "Chris" in anywhere! 😄

 

ChrisDMU_0-1677070757364.png

 

 

I think "Chris" is the value of the variable "Interviewer" 😉

I have a number of different interviewers, how would i replicate this for interviewer "Sophie"?

Can't see anything specifically pointing to Chris in any of the variables

 :S 

I don't know what your input is and I don't know what dynamic content you have available so it is not easy to help because I am just guessing.

 

I was guessing that you created categories you called "Chris", "Sophie" and so on and in the variable "Interviewer" you put in the value of this categories. Of course you could use the names in the filter conditions (like this "@equals(item()['Interviewer'], 'Chris')") but I'm not sure what your plan is with the different branches. From the description you have a list of people receiving the same mail with different filters. I would use an "apply to each" action so you won't have to write everything multiple times.

 

It would be much easier with a little more information.

 

Where are the names stored you want to send mails to, where do you get the mail addresses, how do you built the html table, maybe some sample data.

ChrisDMU
Frequent Visitor

Sorry Matthy, wasnt clear before.

The categories "Chris", "Sophie", etc come from Set Interviewer variable which is finding "Category" from a booking.

The idea is i get a few tables built and then email to each person. The email bit i was going to have just written into the Send an Email (V2) flow, and have 6 or 7 of them.

I have attached some screenshots if that's easier?

 

ChrisDMU_1-1677159978552.png

 

 

ChrisDMU_0-1677159522372.png

 

Without knowing the structior of all the data it is difficult to answer. But here you have a sample of how I would build the flow.

 

{"id":"a06bd189-468e-4e26-8f22-c4159561c014","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"Scope_Email","operationDefinition":{"type":"Scope","actions":{"Compose_People":{"type":"Compose","inputs":[{"Name":"Chris","Email":"Chris@whatever.com"},{"Name":"Sophie","Email":"Sophie@whatever.com"},{"Name":"Michael","Email":"Michael@whatever.com"}],"runAfter":{}},"Compose_Sample_Data":{"type":"Compose","inputs":[{"Interviewer":"Chris","Info":"This is a task for Chris"},{"Interviewer":"Sophie","Info":"This is a task for Sophie"},{"Interviewer":"Chris","Info":"One more for Chris"},{"Interviewer":"Sophie","Info":"And one more for Sophie"}],"runAfter":{"Compose_People":["Succeeded"]}},"Apply_to_each_Person":{"type":"Foreach","foreach":"@outputs('Compose_People')","actions":{"Filter_Tasks_for_Person":{"type":"Query","inputs":{"from":"@outputs('Compose_Sample_Data')","where":"@equals(item()['Interviewer'], items('Apply_to_each_Person')['Name'])"},"runAfter":{}},"Compose_Mail":{"type":"Compose","inputs":"Here you send a mail to @{items('Apply_to_each_Person')['Name']} (@{items('Apply_to_each_Person')['Email']})\n\nNumber of Interviews for today: @{length(body('Filter_Tasks_for_Person'))}\n\n@{join(body('Select_Info_from_Task'), '\r\n')}","runAfter":{"Select_Info_from_Task":["Succeeded"]}},"Select_Info_from_Task":{"type":"Select","inputs":{"from":"@body('Filter_Tasks_for_Person')","select":"@item()['Info']"},"runAfter":{"Filter_Tasks_for_Person":["Succeeded"]}}},"runAfter":{"Compose_Sample_Data":["Succeeded"]}}},"runAfter":{}}}

I hope this clears some things up. Just put it in a new testflow and run it.

 

Of course you have to select some other input and create formated different output but the way to go should be clearer. And you can turn on "Concurrency Control" to speed things up.

Hi. I am not able to import this flow. You can try to export it as a unmanaged solution and send it to me. I need a zip-file or json parts of the flow (like I posted it).

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (4,071)