/blog/images/avatar-icon.png

Can't display data after addcolumns() to a datasource

Problem Re: Can’t display data after addcolumns() to a dat… - Power Platform Community (microsoft.com) Here is the table: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 With( { isnotteamhead: First(colSession).CurrLevel <> "RO", isnotbanker: First(colSession).CurrLevel <> "Banker", ro: First(colSession).CurrTeam, banker: First(colSession).CurrBanker }, Search( AddColumns( GroupBy( Filter( WAM_Trade_Summarizes, FinalDate_yyyymm in ComboBoxTradeFinalDate.SelectedItems, (isnotteamhead || RO_gb=ro), (isnotbanker || GroupBanker_gb=banker) ), "crfb8_statement_prod_type_gb", "rest" ), "total_income", Sum(rest, Final_Rev_gb), "total_aum", Sum(rest, Total_amount_gb) ), SearchTypeRevenue.

PowerApps `not in`

Photo by Sigmund on Unsplash “not operator along with the custom named condition operators is not allowed” Operator <> or NOT In. In and Exactin For example in an Items of Gallery : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 With( { userlevel_isnot_banker: First(colSession).UserLevel <> "Banker", isnotteamhead: First(colSession).CurrLevel <> "RO", isnotbanker: First(colSession).CurrLevel <> "Banker", ro: First(colSession).

[PowerApps] Display Dates in a Combo Box, Distinct not Showing all Records, Filter on Date won’t Work

Display Dates in a Combo Box Getting value but not “yyyy-mm-dd” like format for dates records in a combo box? Change you items with ForAll or AddColumns: 1 2 3 4 5 6 ForAll(AvailableDates, { DateValue:ViewingDate, DateDisplay:Title & " - " & Text(ViewingDate, "dd mmm yy") } ) Then it will display correctly: But how to show a DefaultItems? X: [values] O: {column_name: value} PowerApps Distinct not Showing all Records? (2000 records limitation on each query)

5 Basic Design Patterns You Need to Know (1/2): Singleton, Factory, Observer

Brief Singleton pattern: This pattern ensures that only one instance of a class is created and provides a global point of access to that instance. Factory pattern: This pattern provides an interface for creating objects in a superclass, but allows subclasses to alter the type of objects that will be created. Observer pattern: This pattern defines a one-to-many dependency between objects, so that when one object changes state, all its dependents are notified and updated automatically.