Filter data from SharePoint list based on condition ( I/p: Account Number )

[rswain44]

I want to show the data in PowerApps gallery control based on Account Number .

Filter :

List of debited transaction and list of credited transaction based on Date.

Note: We can consider all from account Number , the transaction are debited and all To account number transaction are credited. 

The account number which is in red mark, few times  I have debited and some time also credited in the account. So i want to show a report to user, list of debited and credited transactions. 

It should appear like this format. LAST 10 Debited and credited transaction  based on date, 

[rswain44]

Please i need anybody help on this. 

[mdevaney]

@rswain44 
If I understand correctly you would like the newest 10 transactions with the account number in either From Account or To Account.

Please try this code in the Items property.  I assume you have a variable called vAccountNumber which matches a value in the FromAccount/ToAccount fields.

FirstN(Sort(Filter('Money Transfer History', FromAccount=vAccountNo Or ToAccount=vAccountNo), Created, Descending),10)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[rswain44]

Thanks for the reply. You code is correct but I want to show the transaction status. You can see in last column . Currently I just hard coded the value but it should come like Dr or Cr. 

If that account number is came from FromAccount then it the status label will be Dr else it's credit (Cr). 

The real scenario is like  --

I have a account number :1234567879

So i have to check this account number in two place ( FromAccount and ToAccount)

If my account number is exist in FromAccount then status would be Debit. 

If my account number is exist in ToAccount then status would be Credit.

That status i want to show in Red and green based on Dr and Cr.

Hope you understand my problem.

[mdevaney · Accepted solution]

@rswain44 
OK, that is definitely possible to do.  Please use this code in the Text property of the label to display Dr or Cr.

If(vAccount=FromAccount, "Dr", vAccount=ToAccount, "Cr")

Then use this code in the Color property of the label.

If(vAccount=FromAccount, Red, vAccount=ToAccount, Green)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."