Power Platform Community Forum Thread Details

Hi Powerapps Community!

Back at it with more questions 🙂

I am currently creating an app, where it has the ability to check in/ check out an asset.

(Think of it like a library book)

The process if as follows: Scan QR Code, Powerapps Reads code, User clicks 'Check Out', and this information is recorded in a SharePoint list.

To Check in an item, user would click on 'Check in' through powerapps, a gallery would then display the items, and the user could select which item they wish to check in.

I would like to make it a little fancier at the Check Out process, where Powerapps could match the QR code against one recorded against SharePoint, and see whether the status in the CheckedOut column is 'Yes'/'No'.

My current formular is this for 'On Select' of the Check Out button:

ClearCollect(DatabaseName,Distinct(Filter(DatabaseName, Value(ItemCode)=TextInput1 && CheckedOut="YES"))

I'm a little lost as to where to go next.

Ideally I would like a message to appear saying "This item has already been checked out by xx"

And if there is no match, the button would navigate to a window indicating success.

Would it be better if I used 'LookUp' instead of 'ClearCollect'?

Hope this isn't too confusing

Thanks in advance!

Categories:

Building Power Apps