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 Apps
Unanswered

Export Data

(0) ShareShare
ReportReport
Posted on by 35

Hi 

I have built a power app which is basically a phone list. I was wondering if any of you know a way to export that into an excel format? 

 

The Phone list data comes from outlook/office 365 active directory. 

 

Thanks

Vicky 

Categories:
  • RyanVH Profile Picture
    145 on at

    Shane Young has a video about this on his youtube channel Power Apps Export data to Excel with Flow - Collections to CSV file - YouTube

  • MISPowerApps Profile Picture
    35 on at

    Hi 

    Thank you, I have had a look but I am struggling to apply his power app command line to what I am doing. 

     

    Thanks 
    Vicky

  • RyanVH Profile Picture
    145 on at

    I have another way that could be very easy to implement, but it involves adding records to a dataverse table.

    Is this like a one time thing you need to do or is it something you would need to do regularly?

     

    Kind regards

    Ryan

  • MISPowerApps Profile Picture
    35 on at

    Hi 

     

    Id have to do it regularly 

     

    Thanks

    Vicky

  • WarrenBelz Profile Picture
    156,926 Most Valuable Professional on at

    HI @MISPowerApps ,

    What is it you find difficult about exporting to CSV?

    Is this actually a list (the data is in text fields) or is is simply a Person field with the person's name, getting the rest from Office365? In any case, what fields you you want to export?

  • MISPowerApps Profile Picture
    35 on at

    Hi, 

     

    Preferably I would like to export the name and phone number of the member of staff however I am not sure of the command line. 

     

     

  • WarrenBelz Profile Picture
    156,926 Most Valuable Professional on at

    @MISPowerApps ,

    Is it a list of single text fields or are you dealing with a Person field and want what is inside it?

  • MISPowerApps Profile Picture
    35 on at

    Hi 

    I have attached what the power app looks like currently and have blurred out the names and phone numbers. But basically the search a name or click a button and it shows the persons number. The name, email, number and location is the command line: "ThisItem.DisplayName" for example. 

     

    power app.png

  • WarrenBelz Profile Picture
    156,926 Most Valuable Professional on at

    @MISPowerApps ,

    Sorry, that does not help me - what are the Items of the Gallery. I cannot assist unless I know the data structure you have there.

  • MISPowerApps Profile Picture
    35 on at

    So my gallery command is the following:

    Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text}),CompanyName="MacGregor Industrial Supplies Ltd", AccountEnabled=true)

     

    And on the export button i have the following information however its saying something is wrong: 'PowerApp->Compose'.Run(JSON(Gallery3,JSONFormat.IndentFour)) 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard