Unanswered

Formula only shows outcome for first match

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good afternon,

Let me say first that I am new to PowerApps. I'm trying to create a app that checks if a Business Central employee has their birthday today or not. If it's someone birhtday, it should notify "HB + the name of the employee". In this example "HB Assia Lammers & Roelf Schoonen". The problem is: It only shows the notify for the first employee that has their birthday today in this case.

I used the following formula:

ForAll('employees,v2.0';

If(Month(Title2) = Month(Today()) && Day(Title2) = Day(Today()); Notify("HB " & Subtitle2); Notify("Niemand jarig ")))

Any help is appreciated, and thanks in advance.

Kind regards,

El Patrón

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,
The problem with the formula is that the Notify function is only called once for the first employee whose birthday is today.
This is because the ForAll function is used to iterate through all employees, but it does not accumulate the results of the notification function for each employee.
Do you want to display the name of the person whose birthday is today in a reminder?
Please try to display people's names together:

Notify(If(CountRows(Filter(event,Text(Starttime,"mm/dd")=Text(Today(),"mm/dd")))>0,"HB"& Concat(Filter(event,Text(Starttime,"mm/dd")=Text(Today(),"mm/dd")),Title,"And"),"Niemand jarig"),NotificationType.Information)
Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Cheng,

Thank you for your response, I appreciate it.
I've got a small additional question; in your input file, is this a selfmade list? In my case, my source is Dynamics Business Central and my "visual" in PowerApps for this is a gallery, and I am only able to select the first name and birthday, but not all of them. If I want to select multiple values, I select the whole gallery. If I try to select for example the second name and birthday, it also selects the whole gallery. It does this for every value except the first ones. (see printscreens in attached files).

Is there a way to work around this, or could this be out of my control and related to Dynamics Business Central?

Thanks again in advance and with kind regards,

Timo (username El_Patrón)

Was this reply helpful? Yes No