Greetings all -
I've modified the the Asset Checkout template to reserve quantities of items based on user input from a Text Input field. What I'd like is to display a warning if if they request an amount greater than what is currently on stock.
The data is coming from a datafield called "Quantity" in my Excel sheet. I'm brand new to this, so if someone is feeling extra helpful and breakdown the formula for a dunce like me, I'd be very grateful.
You could create a Label and have the text to show "**WARNING MESSAGE**". Then on the "Visible" function of the label you could do something like:
#Reference where the quantity is being typed in:
If the statement is true the label will be visible else it will be invisible. Not entriely sure how you have the template setup. If you have it in a collection it may be faster.
Let me know if this helped, provide some more information or screenshot of the varibles.
Thanks for that explanation - I'm getting an "expecting a number value" error. Here's what (I think) I know:
1) The form is setting a global variable of Set(ItemSelected, ThisItem). It's getting passed from a browse screen to a reserve screen, where I'd like the warning to display.
2) I've renamed the quantity field to "productquantityfield". So my visible formula for the error is:
Where Checkedout is my table name, and "Quantity" is the name of my table column.
Is it as simple as your comma mistake above? Shouldn't it actually be:
Appreciate the quick help, @jhall - no dice. Now I'm getting
"Unexpected characters. The formula contains 'Ident' where 'Quantity' is expected.
"Expected operator. We expect an operator such as +, *, or & at this point in formula."
After looking closer at your function, I'm not sure what you're really trying to do here.
The bolded section has me scratching my head.
This is just to see if we're trying to order more than what is available of a particular product, correct? Is that what the LookUp() is supposed to be doing (getting the current amount available)?
Correct, @jhall - I'm trying to prevent a user from checking an item if the quantity they request is more than what is in stock. Beg your pardon for the ignorance on the structure of the formula; this was what was suggested to me earlier.
Well, to start w/ the basics, I'm assuming you got your Excel form by importing it into the application. Via View | Data Sources | Add data source | import Excel. So if you do the above series of clicks then you see something similar to:
From there, if you can do a quick test of linking this to a Data Table in PowerApps then that will help us in verifying field names and I can be specific. Add a new Data Table via Insert | Data table. Change the Items property to be the name of your Excel item from above (e.g. Table1). Click the Fields property and select any/all fields associated with what we're doing here.
You should now see a Data Table that shows rows/columns that contains data from your Excel document. If you give me a screen shot of that (mainly column headers is what I care about) then I can be specific.
Also, keep in mind that this data is NOT live (I seem to be typing this a lot today). Excel imports with PowerApps are only done when you (the developer) refreshes this info. So it is not "real time" for users.
The primary way to make Excel Tables and PowerApps display data that is in real-time is via linking both to a SharePoint List (or something similar). PowerApps cannot link directly to Excel for real-time data.