Announcements
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
Shane Young has a video about this on his youtube channel Power Apps Export data to Excel with Flow - Collections to CSV file - YouTube
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
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
Id have to do it regularly
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?
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.
@MISPowerApps ,
Is it a list of single text fields or are you dealing with a Person field and want what is inside it?
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.
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 220 Super User 2026 Season 2
WarrenBelz 194 Most Valuable Professional
Mohsin Ali 150