cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KotaroKo
Helper III
Helper III

Join Sharepoint Lists and office365users database

Hi, guys! I am working on a work vacation application and i'm stuck. The problem is I need to join Office365users database with 3 different vacation type tables and I need to generate a report from them. From office365users I get department, job title and ID. From vacation types tables I get what type of vacations person had and how many days. I need to join this tables and generate report in which users' department, job title,ID, vacation types and used days will be shown. I try to join them with office365users IDs. Is it possible to join them with PowerApps syntax. I am really struggling for a long time...

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @KotaroKo :

Do you want to join these tables?

You can use the functions AddColumns and LookUp to perform joins in PowerApps.

I've made a test for your reference:

My data source(SharePoint list):vacationtypes

Column (click to edit) Type

vacationtypeSingle line of text
daysSingle line of text
emailSingle line of text

1.jpg

1\add a data table control:

Items:

 

AddColumns(
    vacationtypes,
    "department",
    Office365Users.UserProfileV2(email).department,
    "job title",
    Office365Users.UserProfileV2(email).jobTitle
)

 

2.JPG

In addition,I think this link will help you a lot:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Syntax-for-joining-tables/m-p/61387

Best Regards,

Bof

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @KotaroKo :

Do you want to join these tables?

You can use the functions AddColumns and LookUp to perform joins in PowerApps.

I've made a test for your reference:

My data source(SharePoint list):vacationtypes

Column (click to edit) Type

vacationtypeSingle line of text
daysSingle line of text
emailSingle line of text

1.jpg

1\add a data table control:

Items:

 

AddColumns(
    vacationtypes,
    "department",
    Office365Users.UserProfileV2(email).department,
    "job title",
    Office365Users.UserProfileV2(email).jobTitle
)

 

2.JPG

In addition,I think this link will help you a lot:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Syntax-for-joining-tables/m-p/61387

Best Regards,

Bof

 

View solution in original post

Thank you very much @v-bofeng-msft 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,511)