Hi All:
I have an approval flow set up. However, I noticed it is NOT pulling the email address from the main list despite the fact it is in the list from the lookup table.
I tried a couple tricks from posts here but not the same scenarios as this one.
Please assist.
Thank you!
Holly
Accepted Solutions
I made an example that has a lot of photos about the SharePoint lists and columns. The actual flow example is only showing about selecting the dynamic content and the outputs. So the flow part is relatively short.
I want to focus on the SharePoint columns and settings because I think that would be where the problem could be created.
So basically go down and look at the simple flow and see if that helps. If it does not, then look through my SharePoint list columns and details and see if you can recognize the difference between yours and mine. That should help narrow down what could cause the problem.
Example:
In my example I have a Patient Referral sharepoint list that I will add a new patient/create new item whenever I get a phone call. When a new patient is added, I have to select what clinic I referred them to. I use the "AssignedToClinic" lookup column to select the clinic that is in the source ClinicList. This will get all of the details of the clinic and pull it into my patient referral list. My flow is triggered whenever a new item is created in the Patient Referral list.
Source of Lookup Column - Clinic List
I created a SharePoint list called ClinicList. This basically shows clinics and the managing people. This list will be the source used by the lookup column in the second list.
Main List Used for Flow - Patient Referral
The second list will be the one used by people to trigger flows and everything.
The Patient Referral list appears to have 7 Lookup type columns. But really I only added 1 Lookup column "AssignedToClinic" to the list. This is the primary lookup column where I will select the clinic. The secondary lookup columns are automatically applied because I checked the Show Additional Fields in the column settings.
So when I create a new item in the Patient Referral list, I have to select the AssignedToClinic in the dropdown for the lookup. None of the other columns are edited when a new item is created.
But when I create the new item, all of the secondary linked lookup columns are filled in automatically.
My basic flow is triggered when a new item is created in the Patient Referral list. This will show the separate value types that can be returned from the lookup column. My example only shows the AssignedToClinic dynamic content, but the results will be the same if I used any of the other lookup columns.
Dynamic Content Options:
AssignedToClinic Id - will be the ClinicList Item Id of the lookup value selected in the Patient Referral list
AssignedToClinic Value - will be the text string output of the lookup value
AssignedToClinic - will be the full object of the lookup value
So please look this over and see if it helps you get the correct output. You want to select the dynamic content that ends with "Value" in order to get the single text output.
If you are getting different results than my example please let me know where you see the differences in column types or what is in your flow.
From the Main list - there are 3 CM_address values from the Dynamics.
"{\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference\"
,\"Id\":39,\"Value\":\"holly.cathcart@XXXXXXXXX.com\"}
\nholly.cathcart@XXXXXXXX.com\n39"
From the look up List...
Hence why I need to somehow add the lookup list into the flow and pull from there for the CM address.
Actually, you are close but the data in the main list is already filled by the SQL Server flow. Lookup list already has the CM and RD email addresses in there. There is no data input in the main nor lookup lists from anyone.
The CM email address (and other email addresses fields) is a single line of text, actually.
Pretty cut and dry.
So, in the approval action, I have it customed to add 3 options for the staff and/or CM to select. The lookup list is not in the flow and I need to add it in there so that Teams can send the CM the customed approval to select one of the three options. But it is not sending it to CM. Only to the User Email address from the main list as the main list is in the flow.
Hope this clarifies for you 🙏
This is where I am at so far and I am stuck at the Parse JSON...It's throwing an error doesn't make sense....
Ok thank you, I'm working on an example.
Do you have a reason for the Main List lookup columns to all be separate? Or did you use a single lookup column and renamed the additional columns so they didn't have that leading name?
Like in my example here, my SP List really only has 1 lookup column "AssignedToClinic" which will have an option selected using the Title from the lookup list. The rest of the columns are part of that single look up column.
Just want to double check that I'm looking at your list correctly.
I made an example that has a lot of photos about the SharePoint lists and columns. The actual flow example is only showing about selecting the dynamic content and the outputs. So the flow part is relatively short.
I want to focus on the SharePoint columns and settings because I think that would be where the problem could be created.
So basically go down and look at the simple flow and see if that helps. If it does not, then look through my SharePoint list columns and details and see if you can recognize the difference between yours and mine. That should help narrow down what could cause the problem.
Example:
In my example I have a Patient Referral sharepoint list that I will add a new patient/create new item whenever I get a phone call. When a new patient is added, I have to select what clinic I referred them to. I use the "AssignedToClinic" lookup column to select the clinic that is in the source ClinicList. This will get all of the details of the clinic and pull it into my patient referral list. My flow is triggered whenever a new item is created in the Patient Referral list.
Source of Lookup Column - Clinic List
I created a SharePoint list called ClinicList. This basically shows clinics and the managing people. This list will be the source used by the lookup column in the second list.
Main List Used for Flow - Patient Referral
The second list will be the one used by people to trigger flows and everything.
The Patient Referral list appears to have 7 Lookup type columns. But really I only added 1 Lookup column "AssignedToClinic" to the list. This is the primary lookup column where I will select the clinic. The secondary lookup columns are automatically applied because I checked the Show Additional Fields in the column settings.
So when I create a new item in the Patient Referral list, I have to select the AssignedToClinic in the dropdown for the lookup. None of the other columns are edited when a new item is created.
But when I create the new item, all of the secondary linked lookup columns are filled in automatically.
My basic flow is triggered when a new item is created in the Patient Referral list. This will show the separate value types that can be returned from the lookup column. My example only shows the AssignedToClinic dynamic content, but the results will be the same if I used any of the other lookup columns.
Dynamic Content Options:
AssignedToClinic Id - will be the ClinicList Item Id of the lookup value selected in the Patient Referral list
AssignedToClinic Value - will be the text string output of the lookup value
AssignedToClinic - will be the full object of the lookup value
So please look this over and see if it helps you get the correct output. You want to select the dynamic content that ends with "Value" in order to get the single text output.
If you are getting different results than my example please let me know where you see the differences in column types or what is in your flow.
Thank you wskinnermctc! I did a separate lists/flow/test and it gave me the same results as yours.
I just saved yours for future references along with your other instructions from previous posts.
From the flow that was giving me grief, my CTO, director, and myself managed to get it moving due to time constraints. We also ran into a silly Teams issue whereas we ended up having to split the teams into two or three (depending on which email status) and send it to EACH required person 😤 Outlook and Approval were fine with multiple people in one.
Helpful resources
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!
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 Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2 Anil_g2 SharonS2
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.
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
