Power Platform Community Forum Thread Details

Hi,

I'm using RemoveIf and Collect in one button, removal is happening but it is not collecting any data.

The scenario is: I've Saved filter in TempFilter table that table data is visible inside Gallery named as Vg_Saved_Filter1.

and there is another Gallery named as ReceivedGal in which data is coming from Noti Table.

So when user shared any filter it will come into Noti table (Received Gal) and if the received filter name is already exist in TempFilter table (Vg_Saved_Filter1) the it have to override the TempFilter data with new selected received filter data.

Set(globalFilter, LookUp(TempFilter, Id=User().Email && Active = "Y", FilterName));
ClearCollect(colFilter, Filter(colGalleryData,FilterName in colSelectedFiltersForAction.FilterName));
//RemoveIf(TempFilter, FilterName in colFilter.FilterName);

If(!fromNotificationPanel,
If(globalFilter in colSelectedFiltersForAction.FilterName,
Set(genericMessage, "Heads up! The following filter which is set as global filter will be overridden");
Set(boldMessage, globalFilter);
Set(headerMessage, "⚠ Your Default Filter will be Overridden!");
Set(showOverride, false);
Set(overrideDefaultFilter, true);,
ForAll(
colSelectedFiltersForAction,
// If(FilterName in colCommonFilters.Name, RemoveIf(TempFilter, Uuid = FilterId));
If(FilterName in colCommonFilters.Name, RemoveIf(TempFilter, FilterName in colFilter.FilterName));

Collect(
TempFilter,
{
Uuid: Text(Now(), "") & Left(User().Email, 8),
FilterName:FilterName ,
Id: User().Email,
CountryList: LookUp(TempFilter, Uuid=FilterId, CountryList),
SelectedDate: LookUp(TempFilter, Uuid=FilterId, SelectedDate),
BusinessAreaList: LookUp(TempFilter, Uuid=FilterId, BusinessAreaList),
SystemCatagoryList: LookUp(TempFilter, Uuid=FilterId, SystemCatagoryList),
IvkGroupList : LookUp(TempFilter, Uuid=FilterId, IvkGroupList),
SystemMaterialList: LookUp(TempFilter, Uuid=FilterId, SystemMaterialList),
Active: If(globalFilter = FilterName, "Y", "N"),
CreatedOn: Now()
}
);

);

// remove filter from the list
RemoveIf(
colSharedFilters,
Id in colSelectedFiltersForAction.Uuid
);

RemoveIf(
colSharedFilterInclRead,
Id in colSelectedFiltersForAction.Uuid
);

ForAll(
colSelectedFiltersForAction,
RemoveIf(
Notification,
Id=Uuid
)
);

Clear(colSelectedFiltersForAction);
Set(showGenericDialogue, false);
)

);

Set(showGenericDialogue, false);
Notify("Filter(s) overridden successfully.",NotificationType.Success,5000);

If there is mistake while writing removeif condition please let me know.

Categories:

Building Power Apps