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.
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?
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
WarrenBelz
146,601
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional