Hi everyone! Currently creating a Power App in which a user can Nominate another user. I'm using a Combo Box to pick and select user and a SharePoint in which user can later be saved. Let's say a user wants to nominatee someone that has previously been nominated by somebody else, then a notification message should appear and let the user know that person X has been nominated in X category. Problem is, the code i have that does such function seems to work once app is published but after couple of hours its starts to show errors. Such as: even if a person did not be nominated in the sharepoint, once this same person is selected on Power Apps, the notification message appears even after closing the app. I changed the code so often and it seems to work at the beginning but after hours it shows errors, someone to give me some tips on how i can fix this?
ClearCollect(
ExistingNominations,
Filter(SharePoitList, Title = ComboBox1.Selected.Id && !IsBlank(NominationType))
);
//notification message based on the nominated categories
If(
CountRows(ExistingNominations) > 0,
Set(
NotificationMessage,
"This person has already been nominated " &
If(
CountRows(ExistingNominations) = 1,
"in the " & First(ExistingNominations).NominationType & " category.",
CountRows(ExistingNominations) = 2,
"in the following categories: " & Concat(ExistingNominations, NominationType & " ", " and ") & ".",
"in the following categories: " & Concat(ExistingNominations, NominationType & " ", ", ") & "and ."
) &
" Instead, you can emphasize [BLANK]."
)
);
Notify(
NotificationMessage,
NotificationType.Warning,
60000
);
