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

Expense report action "Condition" failed.

Hi All, I'm trying the Expense Report sample power app. I've followed all the steps, and everything seems to work fine until I approve or reject a request flows sends back an error that reads  "An action failed. No dependent action succeed" this error rises from the "condition " action on my flows.

Then from the body it sends an error message that states " the phased-in field \"Cost_x0020_center\" could not be found\r\nclientRequestId... tried changing cost center from just "cost center" to "Cost center value" but still...ease kindly help.

14 REPLIES 14
Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,

 

Can you share a couple of screenshots of the setup of your actions within your flow? 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Hi @Expiscornovus  and thank you for affording me your time, now what is happening is I deleted and entered a new "Get item" action, there is no more errors but flows is running without finishing also it is not changing the status to "approved or rejected" in SharePoint list.

 

MsBooi_0-1624880078354.png

 

The flow's snipshot is as follows:

MsBooi_2-1624880963342.png

 

MsBooi_1-1624880857914.png

 

 

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,

 

What I can see from the first screenshot is that the new Get Items 2 action is retrieving 4 list items. Those 4 items are retrieved from the expenses list?

 

So, I guess you have 4 items for which you are starting an approval process, correct? And for all 4 items you have either approved/rejected the requests in the Approval Center. And that bit worked?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


@Expiscornovus yes that's sounds right.

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,

 

How have you configured your condition action, can you share a screenshot of that? 

 

And I would also be interested in the 4 items itself. It could be that there are some null values in one of the items. Maybe you can share the output of the Get Items 2 action?

 

And final question. Is this test data or already production? If it is still test, I would just cancel the current running flow instance and resubmit it from the history, if possible.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


the condition action is as the following:

MsBooi_1-1624888297307.pngMsBooi_2-1624888344651.pngMsBooi_3-1624888435013.png

So its the same as on "if no" difference is just the status update.

With regards to the SharePoint items here is the snipshot of the list, problem is with status not changing and comments is indeed null

MsBooi_4-1624888775574.png

MsBooi_5-1624889274127.png

 

Yes it is still testing data, i tried cancelling and resubmitting and the data i tried that on is still running even now.

 

 

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,


In your screenshots I see two cost center fields. Maybe that is the reason why it is failing. One looks like an older field which only allows the selection of a single value.

 

And out of interest, why are you updating the Cost Center value? I would assume the Cost Center needs to be same as right before approval.

 

I think in the update item action you can just leave those cost center fields blank (those are not mandatory). Can you test that for me?

 

leaveblank.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Thank you for your response please bear with me im a beginner, so i used  Expense Report sample and from the instructions they did not mention removing them.

 

Yes it is.

 

So i tried as your request like you can see:

MsBooi_0-1624895752234.png

i don't know why but now i am having this new error(see below), also i have noticed my flow always starts from the very first request to run every time i sent a request how do i fix that part?

MsBooi_1-1624896017021.png

 

 

 

 

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,

 

When I look at your last screenshot I see that the condition expression result is false, this means it won't execute the update item action.

 

I didn't notice before but I now see that you are using the Response field in the condition action. Can you try and use the outcome field instead?

 

outcomefield.png

 

Btw, can you also share the link to Expense Report sample instructions. This way I can also validate those.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


@Expiscornovus  i cant seem to find the outcome field, what other field can i use?

MsBooi_0-1624898161788.png

Here is the link i used: https://github.com/MicrosoftDocs/powerapps-docs/commit/494e886298e35f2770ef2207b644a30efb4e89e4

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,

 

Thanks for sharing the link. That is actually a code commit (a change to the existing documentation) in GitHub. But I think I did find the original instructions:

https://github.com/MicrosoftDocs/powerapps-docs/blob/494e886298e35f2770ef2207b644a30efb4e89e4/powera...

 

 

 

I will take a bit of time to work through the setup that same example and see if I can reproduce the issue.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


MsBooi
Frequent Visitor

@Expiscornovus great then! you the right person😀 I will wait for you then but please assist here if i cant find the "outcome" field what do i use?

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @MsBooi,

 

I think I figured it out. I also found the related YouTube video from Todd Baginski, https://youtu.be/kJXZPILfbwU?t=782

 

This is a demo from 2018 which is using the start an approval action which is a deprecated action:

https://docs.microsoft.com/en-us/connectors/approvals/#start-and-wait-for-an-approval-[deprecated]

 

Did you import that flow or did you create it from scratch? When importing an old flow I guess technically you could still import old deprecated actions.

 

When you use the Start and wait for an approval action instead you should be able to use the outcome field as well: https://docs.microsoft.com/en-us/connectors/approvals/#start-and-wait-for-an-approval

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Hi @Expiscornovus 

 

Apologies on going awol, i actually went through the shared vid it helped a lot.

 

It makes total sense when you say importing could result in importing old deprecated actions because of that I decided to start the flow from complete scratch works well running it from flows problem is I'm now experiencing issues connecting the new flow to that existing app resulting in the app itself to give me an error.

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 (750)