Pink Eye Crow

  To filter list of active inventory by 2 conditions I connected gallery to 2 controls: Text input for text and ID search and Dropdown to narrow down the warehouse. Of course if the manager doe not have access to view folder for Warehouse 2 inventory, the search will not return any value. App creates collection, OnSelect property for "Get Item from inventory" button, ClearCollect(              ColWarehouse,              {Title: "Select All"},              SortByColumns(Filter('Org Structure',ItemType.Value="Warehouse"),"Title",SortOrder.Ascending).Title)          And the result of this collection set as Item property for Dropdown1.   ColWarehouse There is a very simple coding for txtInventorySearch text input . I set Reset(Self)  OnSelect. And Gallery Items property contains the most formulae. Sort(If(Dropdown1.Selected.Title="Select All"...

I needed to create a locking screen for one of my apps, which could be unlocked by PIN. It was a separate screen, which user will be sent to if they were inactive for period of time, similar to an Online Banking App: you get 30 sec warning that screen will be locked and you need to log in again if "Confirm" button is not clicked. I will share the timer part some other day, but for now let me share PIN pad. I used gallery for buttons, I peaked this idea from one of Reza Dorrani's video where he used it for buttons to switch between tabs. In this example on success app navigates to next screen. Although if you need for app to send you back to the screen you were chucked out it is better to use variable . Set it to Home screen On Start and then set var to Back() so it takes you to most resent screen.  You cannot use Back() for other buttons on active screens, otherwise it will take you to PIN pad screen. Hope it makes sense...  Anyway, enough chit-chat.  Coding below and vid...

 Till, part of my EPOS solution. This time App on two screens. Screenshot  above is Main Screen and  Refund it button takes you to the second screen, where refund can be composed. Similar to Adding Stock template, Till consists of two lists, Header and Split. To refund you need to select original Sale Transaction and perform refund. App marks Inventory List "Sold" column with R , adds date of refund and this puts returned item back to active stock letting you to select it for the next sale. After refunding the item it lights in red, letting you know it was refunded. I used locking pad for occasions where you need to restrict editing. PIN has to be entered to unlock it. For now I hard coded 0000 , but PINs can be made dynamic, by creating another restricted list with all passwords. Also there is an option to split sale transaction for further analysis. A1, A2, A3 buttons bring up the columns where you can either check to copy full amount, or type in different amount.

  I wanted to test my SharePoint and Power App knowledge I have so far and put together a solution for Furniture Charity Shop. So far my Data Model consists of: 9 SharePoint Lists, 2 Customized in Power App Forms ( one for adding the stock, the other as a till to sell and refund)  2 Power Automate flows. Adding stock adds data mainly to 2 lists: Header( StockIn) and a Split (Inventory). To separate access for each shop I introduced folders within list, where permissions can be set individually for each shop manager / assistant and give full visibility to a general manager. Adding Stock Template has only one screen. Data comes from 5 Lists I played with different controls and learnt how to use Pen Input tool to capture the signature for Gift Aided Donations Used a lot of variables to set visibility for different parts of app and Patch() function to update weights template and add new lines, by copying  data from invoices Power Flow moves newly created item to designated fo...

  You can find a good video by  April Dunnam    SharePoint Filtered Lookup - YouTube  , where April shows how to Filter Look Up column by condition. I works great for Share Point list, however, when you transfer this column to Power Apps it gives you empty gaps as filtering does not support in Power App, The solution I managed to find is  Filter(Choices([@test].Customer),Value<>"") in Items property. It is delegable and works well . If you wish to say thank you please donate to the charity I use to work for. Donate here

 My biggest challenge I got stuck on for days was to get items saved in folders, as we all know new items, when  created from Power App or customized form do not get saved in folder, but in main list outside the folder structure, making it visible and editable by all. I dug internet for solution and today found video, which helped me a lot! Thank you  Deepak Shrivastava  for a video. Move SharePoint List Items Using Power Automate #PowerAutomate #SharePoint - YouTube The how to very well explained, so I will not repeat,  just added  typed code strings and a screenshot of my version I temPath decodeUriComponent(decodeUriComponent(decodeUriComponent(triggerOutputs()?['body/{Identifier}']))) Filter Query Title eq'@{triggerOutputs()?['body/Warehouse/Value']}' Folder Path decodeUriComponent(decodeUriComponent(decodeUriComponent(outputs('Get_items')?['body/value'][0]?['{Identifier}']))) Though I followed the video to a dot, I was not able to ge...