Answered

Convert a formula with hard-coded values into values retrieved from SharePoint

(0) Share

Report

Posted on by johnjohn123

3,514

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

ClearCollect(
 varUserForContracts,
 {
 Type: "Admin",
 Emails: Table(
 {UEmail: "app.admin@.org"},
 {UEmail: "*****.org"},
 {UEmail: ".org"},
 {UEmail: "*****.org"},
 {UEmail: "app.admin@.org"},
 {UEmail: "*****.org"},
 {UEmail: ".org"},
 {UEmail: "*****.org"},
 )
 }
);

now instead of hard-coding the email addresses, i created a SharePoint list which include all the above emails:-

so how i can build the same Collection (with Type, email Table) but to populate the table values from the values inside the SharePoint list?

Thanks

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hello, @johnjohn123, try this:

ClearCollect(
 varUserForContracts,
 {
 Type: "Admin",
 Emails: ShowColumns(SharePointlistName,"EmailColumnName")
 }
);

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@AhmedSalih but as you can see the column name inside the SharePoint list is "Title", while i want it to be "UEmail" inside the collection , is this possible?

Verified answer

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@johnjohn123, try this:

ClearCollect(
 varUserForContracts,
 {
 Type: "Admin",
 Emails: RenameColumns(ShowColumns(SharePointlistName,"EmailColumnName"),"Title","Uemail")
 }
);

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@AhmedSalih thanks worked
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123, thank you for letting me know. I will go ahead and accept the solution then.