Unanswered

User Spending Control

(0) Share

Report

Posted on by PowerApps11

521

I would like to control user spending example I have a list in SharePoint which holds all users & called UserDataBase and in the list there is a fields, Credit Limit & Credit Used,
I would like to monitor via another list which is called LoanList in SharePoint so when I try to issue a loan by entering a value Field called Amount I need to check what's the credit limit for user and how much they spend also if the limit reached or I enter greater than the available to warm me for example if they request $100 and they already spend $90 the system to check and tell me the difference and left credit limit like $10 available

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerApps11 ,

Just On Select Property of Button.

Use LookUp/Filter Record from Loan List and Add the Filter Criteria by User/Email with Collection.
Like - LookUp(UserDatabase,Lower(Email) = Lower(TextInput1.Text)).
Then userCollectionName.UsedLimit+EnterdLimit is grater then CreditLimit then Display Error Message.

Hope the Explanation help you to resolve your Issue.

Thanks,
Vijay

Was this reply helpful? Yes No
PowerApps11 521 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VijayTailor
I don’t how to do that can you help with formula
@WarrenBelz can you assist please thanks

Was this reply helpful? Yes No
WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@PowerApps11 ,

I think @VijayTailor has it under control - you just need to share the code you have written for review and possible correction.

I will add one small thing - you can use this to avoid the case sensitivity issue (StartsWith is not case sensitive and also serves the purpose of matching partial input)

LookUp( UserDatabase, StartsWith( Email, TextInput1.Text ) )

Was this reply helpful? Yes No
PowerApps11 521 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
thank you for accepting my tag , I don’t check an email I check via user Id but that I have fixed no problems. My problem how can I patch back to the list the calculations user credit limit and used credit at moment I am not near computer but I can supply the code I try when I get to computer later on can you give a example please

Was this reply helpful? Yes No