cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WeiMingLeong
Helper V
Helper V

Expense App for manager screen. Pending and Approved amount

Hi all, thank you for taking your time to see this message.

 

i am trying to do a expense app for office to use.
It will contain a employee screen and Manager Screen.

There is 2 sharepoint list, 1 expense list 1 lineitem list.


in the Manager Screen, i have done adding the filter to filter ApproverNamer on the OnVisible, set screen to Pending button to show only pending status..

and Hide Open tab so that it will not show their own ongoing claim.

Set(ExpenseStatus,"Pending");
Set(ExpenseSorting,Descending);
Filter(Expenses, User().FullName=ApproverName.DisplayName);
ClearCollect(OpenReports,Filter(Expenses,Status.Value = "Open").ID);
ClearCollect(ApprovedReports,Filter(Expenses,Status.Value = "Approved").ID);
ClearCollect(PendingReports,Filter(Expenses,Status.Value = "Pending").ID);
Refresh(Expenses);
Refresh(LineItems)

 How can i filter the Pending and Approved amount to be showing the amount the is for the manager to approve or approved.
this is what it have been set

"$" & If(Sum(Filter(LineItems,Text(ReportID) in PendingReports.ID),Cost)>0,Text(Sum(Filter(LineItems,ReportID in PendingReports.ID),Cost),"[$-en-US]#,###.00"),0)

WeiMingLeong_1-1649821488202.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

I recommend Sum on the values brought back by the galleries as you advised delegation would not be an issue. This should be a nice quick solution 🙂

 

let me know if it works



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

View solution in original post

4 REPLIES 4
WeiMingLeong
Helper V
Helper V

anyone can help?

I recommend Sum on the values brought back by the galleries as you advised delegation would not be an issue. This should be a nice quick solution 🙂

 

let me know if it works



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

Hi @AJ_Z ,

This work, Thank you for your help again.!

always happy to help



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,175)