Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Expense Report Approval Flow Issues

(0) ShareShare
ReportReport
Posted on by 4

I would like to include the total expense cost in my autogenerated email for the expense report power app but cannot seem to find a way to do that. 

 

Once I click the link in the autogenerated email, I would also like to see the total cost, the individual line item summaries and be able to click into them to see the receipts & comments. 

 

Is this possible? I would like to continue to use the 'flow' system I already have in place. I followed the step by step Microsoft Expense Report Power Apps online document. 

 

 

Email.pngPowerApp.pngworkflow.png

  • TalComoSoy88 Profile Picture
    4 on at
    Re: Expense Report Approval Flow Issues

    Can you be more specific? 

    I have the same question, but I can't seem to get it to work.

    In the template, there are two lists, one for header information (the total, the approver, etc) and a separate list for the line items. 

    The Flow uses the header list as its source. I understand that it has to or the approver would get one email per detail line and each line would have to be approved separately. However, I can't figure out how to link to the list of the line items list to show only the line items related to the expense report that the approval email is about. 

    I'd like for the email to show that detail, but if it can't, a link to those items would be sufficient. 

    Has anyone done this? 

  • rimatos Profile Picture
    on at
    Re: Expense Report Approval Flow Issues

    Hi @MML88,

     

    From my understanding you want to include in your approval the value of the total cost and a link to the individual line items.

     

    Since the expense report Power App is a template, you will need to perform some changes to the Flow that starts the Approval to include the required values as dynamic content. You have here an explanation on how to Modify the Flow for the Expense app.

     

    You will need to insert the total cost as dynamic content in the Approval action, as well as performing changes in the SharePoint list to include the Link to the line items, so you can update them accordingly.

     

    Do take into account that these changes will need to be performed first in the Power App, since you will need to guarantee that you pass these values from the Power App into the Flow so you can use them as dynamic content.

     

     

    Hope this helps!

     

    Regards,

    Ricardo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,601 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,946 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow