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
Answered

Export to Excel

(0) ShareShare
ReportReport
Posted on by 301

I trying to export data from power app to Excel , which is working fine.
But the choice field is where the I'm getting data as collection/table format but I just want the value ,

Choice field for single select field value is coming fine.
But this choice field is a multiselect choice field 
Any help on this?

multiselect.png
Excel.png
Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,781 Most Valuable Professional on at

    Hi @apeawakening ,

    Firstly, please post your code in Text - saves retyping this end. Try this for commas in between the values

    ForAll(
     'Admin gallery'.AllItems As _Gal,
     Collect(
     colExcelExport,
     {
     Title: _Gal.Title,
     EmployeeName: _Gal.EmployeeName.DisplayName,
     Department: _Gal.Department,
     MobileOrSIM: 
     Concat(
     _Gal.MobileOrSIM,
     Value,
     ","
     )
     }
     )
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • Ape Awakening Profile Picture
    301 on at

    Its throwing an error , invalid argument in collection

    invalid.png
  • WarrenBelz Profile Picture
    153,781 Most Valuable Professional on at

    @apeawakening ,

    Did you simply paste my code in out type it out with proper structure ? One of the issues with not posting your code in Text is that I have to OCR it at this end - see if you can spot the difference in the amended code.

  • Ape Awakening Profile Picture
    301 on at

    No , I type it out .

  • Verified answer
    WarrenBelz Profile Picture
    153,781 Most Valuable Professional on at

    @apeawakening ,

    I tested the code here on exactly the same field types and names

    WarrenBelz_0-1696972403603.png

    My gallery 'Admin gallery' contains: -

    • Title - a Single Line of Text
    • EmployeeName - a single value Person field
    • Department - a Single Line of Text
    • MobileOrSim - a Multi-value Choice field

    The code works as expected with no errors.

     

  • Ape Awakening Profile Picture
    301 on at

    Thank you so much , it worked , I really dont know how .😀

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!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard