Get the email address from SharePoint lsit and build Table inside Power Apps

(0) Share

Report

Posted on by johnjohn123

3,506

We have the following Table inside Power App formula, with email addresses been hard coded:-

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 i created a SharePoint list which include all the emails:-

so how i can build the same table but populate it from the values inside the SharePoint list?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

So you just want a table to display the SharePoint List Items?

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@phipps0218 yes instead of hard-coding the Tables emails values i want to retrieve them from SharePoint

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

Add the SharePoint List as a data connection in Power Apps then:

ClearCollect(CollectionName, SharePointListName)

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
@phipps0218 but will this build exact collection to :-

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"}, ) } );

which have type=admin & the values as table of UEmails?

Was this reply helpful? Yes No