0

We have the following Collection which contain a Type and Table of Email addresses inside Power App formula, with email addresses been hard coded, as follow:

ClearCollect(
    varUserForContracts,
    {
        Type: "Admin",
        Emails: Table(
            {UEmail: "[email protected]"},
            {UEmail: "*****.org"},
            {UEmail: ".org"},
            {UEmail: "*****.org"},
           {UEmail: "[email protected]"},
            {UEmail: "*****.org"},
            {UEmail: ".org"},
            {UEmail: "*****.org"},
        )
    }
);

Now instead I created a SharePoint list which include all the above emails:

enter image description here

So how can I build the same Collection but to populate the table values from the values inside the SharePoint list?

1 Answer 1

0

Try using this formula:

ClearCollect(
    varUserForContracts,
    {
        Type: "Admin",
        Emails: ForAll(SharePointListSource, {UEmail: Title})
    }
);

Where SharePointListSource is the name of your SharePoint list data source.

Documentation: ForAll function in Power Apps

1
  • Hi @JohnJohn, did you try this solution? Is it working for you? Sep 22, 2022 at 12:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.