Hello,
I am building a power app that collects orders and reports. Orders and reports are recorded in separate sharepoint lists (Report list and Order list). I am tracking the status of the order through an order ID, so if the Report list contains a record with an identical order ID as the Orders list, then I know that specific order status is Complete, otherwise it's Pending.
I am tracking the orders through a gallery, and I added an icon for each item, the icon is setup this way:
If(!IsBlank(LookUp('Report Records', 'repOrderID' = ThisItem.OrderID)), Icon.Check, Icon.Clock)
so the function will check the report list for an order ID that is identical to the one in the current item in the gallery from the order list, if it finds it then the icon displays as a check, if not, it'll display as a clock to show that it's pending.
I want to filter the gallery based on the icon, so the drop down would include "Pending" = Icon.Clock and "Complete" = Icon.Check, and I'd like to add an All option to view all records regardless of the status.
If it's not possible to filter the gallery this way, do I have to set a new column for this value? and if so, how do I populate it automatically like I did for the icon?
