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 Data from a Gal...
Power Apps
Answered

Export Data from a Gallery and a textinput (for every line of the gallery) to a sharepoint list

(0) ShareShare
ReportReport
Posted on by 25

Hello,

 

I’m trying to create an app for my company, and I encounter some difficulties regarding the exportation of my data. I'm new to power apps, so my knowledge is not yet very developed (I also didn't find similar question on internet).

 

I have a gallery that takes data from a SharePoint list (Test power apps 2). Picture 1 shows the gallery with the columns. The last column must be completed by the users. I also have a text input that asks for a name. The gallery is filtered according to a combobox.

 

Picture 1.png : picture 1

 

By clicking on a button, I would like to send, in another sharepoint list (Test power apps 2.1), the selected items of the gallery and also the name entered in the textinput control, for every completed items : Picture 2.

 

Picture 2.png : picture 2

 

Right now, I do manage to send the data completed in the gallery : code below. But I don’t know how to also send the name in the sharepoint list for every line of the gallery exported.

 

 

 

Concurrent(
 Notify("Submitting your records...";Information);
ForAll(
 Gallery1.AllItems;
 Patch(
 'Test power apps 2.1';
 Defaults('Test power apps 2.1');
 {
 Title: TextInput2.Text;
 Entreprise : TextInput3.Text;
 Département : TextInput4.Text;
 Score : Value(TextInput5.Text)
 }
 )
))
& Refresh('Test power apps 2') & Reset(Gallery1)

 

 

 

Do you have any idea how I could do this ?

Thank you in advance !

 

Best regards,

Emeric

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @EmericTms ,

     

    I assume that the control used to enter the name is named TextInputName

    Maybe you could try the following formula:

    Concurrent(
     Notify("Submitting your records...";Information);
    ForAll(
     Gallery1.AllItems;
     Patch(
     'Test power apps 2.1';
     Defaults('Test power apps 2.1');
     {
     Title: TextInput2.Text;
     Entreprise : TextInput3.Text;
     Département : TextInput4.Text;
     Score : Value(TextInput5.Text);
     Name: TextInputName.Text
     }
     )
    ))
    & Refresh('Test power apps 2') & Reset(Gallery1)

     

    Best Regards,
    Charlie Choi

  • EmericTms Profile Picture
    25 on at

    Hello,

    Thank you for your answer !

    Best regards,

    Emeric

  • v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @EmericTms ,

     

    Is your problem solved?

     

    Best Regards,
    Charlie Choi

  • EmericTms Profile Picture
    25 on at

    Hello,

     

    Yes !

     

    Sincerely,

    Emeric

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 July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 377 Most Valuable Professional

#2
11manish Profile Picture

11manish 165 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 110 Super User 2026 Season 2

Last 30 days Overall leaderboard