Few ForAll, Collect and ComboBox

(0) Share

Report

Posted on by CU09100753-0

170

Hi guys,

please help me to fix my code

I have two comboxes: CompanyName and JobTitle.

and I would like to build a table with fields: Company, Mails, JobTitles

Company: from combobox1

JobTitles: Concat(Combobox2)

Mails: All users for this Company with this JobTitles

So I cant get all users with 2 forAll.

My code:

Collect(Mailing_Collection;
ForAll(ComboBox1.SelectedItems As _item;
{CompanyName: _item.Title;
JobTitles: Concat(ComboBox2.SelectedItems;'Job Title'&"; ");
Mails: ""})));;

ForAll(Mailing_Collection As _item2;
Patch(Mailing_Collection;LookUp(Mailing_Collection;CompanyName=_item2CompanyName);
{Mails: Concat(Filter('users';CompanyName=_item2.CompanyName;extensionAttribute12 in_item2.JobTitles);Mail)}))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@shnurich

Please consider changing your Formula to the following:

ForAll(ComboBox1.SelectedItems As _item; With({_jobTitles: Concat(ComboBox2.SelectedItems;'Job Title'&"; ")}; {CompanyName: _item.Title; JobTitles: _jobTitles; Mails: Concat( Filter('users'; CompanyName=_item.Title; extensionAttribute12 in _jobTitles); Mail) } ) )

I hope this is helpful for you.

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank U, it helps

Was this reply helpful? Yes No