web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapp office365 dat...
Power Apps
Answered

Powerapp office365 datasource not working

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, I'm trying to connect to an office365 datasource but it desnt seem to be seleactable once i have added it. I go through the short wizard, authenticate and then it gets added as a datasource - i can even update the authentication and that all works fine. However when i try and associate this datasource with an object (gallery for example) i click on the link i get a list of datasources - but my office365 one isn;t there - i click into a wizard from there to add one - this gets added as o365users_2 - but again this is not selectable from the initial screen so i cant use it to build an app from. Any idea why this wouldnt be available? Thanks, Richard

 

Now maanged to add pic - so in the screen below i can;t click on either of the office365 datasources - though they seem to be valid....

 

Capture.PNG

Categories:
I have the same question (0)
  • Verified answer
    Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    The Office365Users data source doesn't return a table, so it can't be used as the data source of the Gallery. There are calls in the data source that will return a table of records and you can use that in the Items property of the Gallery.

     

    Try this to get started. Go to the Items property of your Gallery and in the formula bar add:

    Office365Users.SearchUser()
  • MB-02102022-0 Profile Picture
    Microsoft Employee on at

    For further help with how to use the Office 365 connector, check out the documentation we have for it here: https://docs.microsoft.com/en-us/powerapps/connections/connection-office365-users

     

    The documentation lists out all of the valid functions you can use on the connector to help you get started.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks Jeff - that got it. Got slightly confused that the items property does not appear on the right in the properties section but in a drop down near the top left 🙂

     

    ANyway it's working now and managed to get data back - thanks for the reply

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for the pointer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard