Power Apps question:
Input: Our SharePoint list:
There could be few records in the table related to 'InvoiceNumber'.
1st of all, what I already did, so you could see the whole picture.
On startup screen I use function:
Then, there is a arrow button with:
Set(VariableTeam, ThisItem.Result); Navigate(Screen1)
On 'Screen1' a gallery:
Filter(Table1, Team = VariableTeam)
Result is (if we make transition from Microsoft):
How to combine Distinct function with my filter to see "InvoiceNumber" as unique entry in App?