Unanswered

how to patch if category choice column is selected with the correct value.

(0) Share

Report

Posted on by Wei Ming Leong

313

Hi all,

Thank you for your time to read this message.
i have a expense report application which contain 3 different sharepoint list (Expenses, LineItems, Individual Claim)
Expenses List (contain ID, Title, Department, Status, Finances Status)
LineItems List (contain Category, Cost, Date, Description & ReportID (lookup to Expenses-ID)
Individual Claim List (contain lookup Expenses-ID, lookup LineItem-ID, Cost, Date, Category, User(People option)

I want to have this function when finance member click on a reimburse button, i want it to copy the data to Individual Claim List. Only if the selected LineItems category contain (Staff - Welfare), copy data of Expenses-ID, Selected-LineItems ID, Selected-lineitems Category (staff -Welfare), Selected-lineitems Cost, User (People Option)
Please kindly advise what is the best way to do this.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @WeiMingLeong,

Do you want to copy corresponding items to Individual list?

Could you please share a bit more about your scenario?

Actually, if you want to capture items based on the Category(staff -Welfare), I think the best method is the LookUp() function.

Supposed that there are some labels to display your needed info from Expense list and LineItems List, you just need to set the Text property of each Label as below:

If(CategoryDropdown.Selected.Value="Staff - Welfare",LookUp())

Note that there should be a primary key in your Individual Claim List so that you could get expense id or other info based on this primary key.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report
Copy link

Link copied!

HI @v-qiaqi-msft ,

yes i want to copy the corresponding item to individual claim list.
in the finance view item screen, the items can have multiple items.
This marked blue box is LineItems gallery. It also filter base on Filter(LineItems,ReportID.Id = SelectedReport.ID)

So when finance member click on the reimbursed button.
I would want it to check if the lineitems category contain value staff welfare - medicial / dental, i want it to copy data from both Expense List and LineItems List to Individual Claim List
Individual Claim Lists Columns-
ExpenseID : base on LookUp from Expenses list ID.
LineItemsID : base on lookup from LineItems list ID.
Category : from selected LineItems that contain value staff welfare - medicial / dental
Cost : from the selected LineItems Cost.
ClaimUser : From selected Lineitems people group.

Was this reply helpful? Yes No