cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Create an item in a sharepoint list when a value of a choice field is set to approved

Hi all,

 

I am currently trying to create a two step process for a request system: 

  1. Request is sent via powerapp with details (Description & attachments) populating the first list (maintenance request)
  2. When the manager reviews the requests, they can select Approved in the choice field, at which point this creates a new item in the second list (workorders), and carries the description and attachment items

I have managed to create something that I thought would work, but while the flow is saying it is successful, it is not creating the item in the second list. Being very new to creating flows, I am sure I am misunderstanding the relationship with the values etc.

 

Any help would be appreciated - I would prefer not to use the approval process that is pre-built (I did use this and it worked) so that all of the interaction staff have, is via powerapps, rather than via the Power Automate site.

14 REPLIES 14
ScottShearer
Most Valuable Professional
Most Valuable Professional

@BrendanZ1 

Can you please post screen shots of your Flow?  The more detail the better.  This will be a big help to those trying to assist.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

@ScottShearer no worries:

 

flow.png

So at this stage this is back to front - as it is above, it has worked in that it will push the 'Created' and 'Description' from the request list to the WorkOrder list when I create an item. When I had the 'Create Item' in the Yes section, nothing would happen. 

As mentioned, what I would like is - someone submits a request via power apps, filling in the description and attachment fields. The manager then looks at his version of the app where he has more fields available, the key one being the ability to choose whether to approve the request or not. When the manager selects Approve, this would then trigger the flow above, so that only the approved items in the maintenance list are created in the WorkOrder list.....

 

The approval field in the maintenance request list is named 'Approve', with the following choices; Approved, Rejected or  Deferred.

So if the manager selects Rejected or Deferred, nothing happens, other than the change to the field value (in which case I would use the powerapp to filter requests so that those that submit them, can look back and see what hasn't been approved etc).

 

Hopefully that helps.

@BrendanZ1 

In your condition, please verify that you have selected Approval ID rather than just Approval or Approval Value.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

@ScottShearer 

I only have the option to select Approve or Approve Value from the dynamic content section....

@BrendanZ1 

It sounds like an option column rather than a lookup.

Change the condition to check to Approve Value and check for Approved.

I am assuming that the term Approved appears in the list of options.

Please let me know if this works for you.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

In Sharepoint, the Approve field is a choice column with the following options;

 

Approved

Rejected

Deferred

 

I ran the flow and while it did work, it still passes the information straight through to the second list after the item is created - so no approval process took place....

v-litu-msft
Community Support
Community Support

Hi @BrendanZ1,

 

If the "Approve" column is a choice type column, the value in it is a String, however, we could see in the right side condition you input an integer 1, the format not match, so the condition not met. Please convert the integer 1 into string "1", for example:

Annotation 2020-04-08 134946.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@BrendanZ1 

You need to take a look a completed run.  Did the condition return true?  If so, did our Create item action run without error?

Look at the values in the output of each step of your Flow.  That should provide some insight into what is happening.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Every run returned a false against the condition, though when I changed the Integer to a string, the data was pushed through to the second list. It was only when I selected anything other than Approved, it sent the request through.....

 

So I moved the Create Item over to the 'Yes' branch and no luck.

 

In my head, it should work that the flow will check the condition (is Approve Value, equal to Approved - or in this case "1"), if yes, then create item in second list, else do nothing.

 

At the moment it is saying that no selection in the Approve (choice field) is meeting the condition, therefore it is doing nothing either way....

I have just put the Create Item over to the No branch, and every item created in the request list, is being passed through the the workorder list straightaway....

 

So something isn't quite right with the condition section - not sure if there are other options for it to check if the value in the approve field equals "Approved".

mirtiza
Frequent Visitor

Hello @BrendanZ1 ,

May be your condition is not true thats is why it always run "No". Kindly check the Solution of below link

https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-Approval-Condition-not-working/m-p/4...

@mirtiza Thanks for the input, but my situation, as far as I can tell, is not the same. My approval process is based on a choice field in a list, rather than an approval process run through Power Automate. I am trying to get the flow to look for any item that has had the Approve field modified to Approved (as in the manager has selected Approved out of the choices available). If any item in the request list has Approved against it, it would generate a new item in another list, carrying over some of the information originating in the request.

Hi @BrendanZ1,

 

In fact, you can show us the details of your Flow so that we can better understand what's going on inside, you could share a screenshot as blew to show approve column's output, thank you.

Annotation 2020-04-09 103938.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for all the help, but due to time constraints and my lack of experience with flows at the moment, I am currently trying to approach this from a non-flow design now but if time permits, I will look back at this for future reference.

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!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

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  

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.    

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 (1,330)