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 / Export gallery to csv ...
Power Apps
Unanswered

Export gallery to csv and importing it back to powerapps

(0) ShareShare
ReportReport
Posted on by 179
Hello,
 
I am in front of an issue I am unable to solve by myself. I read and watched many tutorials with no success so I will try to describe whatI need to do as clearly as possible.


My user will have a Power App that will generate a gallery based on the multiple filters available to him. That list is generated from a Sharepoint List.


So far so good. The filters work fine. My user will have to call in ascending order each individual. When the call is done, he needs to press a button to record his action (that blue "+4h" button).

This is were things get complicated. This action switch the button from edit mode to read mode to make sure it won't be pressed again as it adds hours to a sum of hours in a column.

I need to record that value somewhere as a boolean somewhere for each item. The reason is if the user needs to export the data to a csv file, we need to keep a record of the actions done. I tried the AddColumn feature but I cannot edit it individually when a button is pressed on a row. Actually, I see that I cannot edit the gallery's values at all. I can edit the Sharepoint List if I do a Patch but that is not what I need.

I can't figure out if being unable to edit any cell in a gallery (or collection as I tried that as well) is an intended feature.

What is the right way to achieve what I need to do? Please help me! Thank you!
 
Categories:
I have the same question (0)
  • Volt26 Profile Picture
    179 on at
    Well, I kind of found a workaround but I bet it isn't the proper way to achieve what I'm looking for. So if anyone ends up at the same spot as I am, here is how I did the first part : 

    I had to add a column in my Sharepoint List. That way, I have a variable I can play with within Power Apps.
    A button copies the Sharepoint List into a collection. As soon as it is copied, I change the value of the whole column "AppelFait" to false. 


    When the "called" button is pressed, the collection value of AppelFait is updated to true
     
    Now I have data that can be exported to a CSV. I'm on my way there. I'll post again when I'm done.

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

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 325 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 88 Super User 2026 Season 1

Last 30 days Overall leaderboard