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 / Gallery questions and ...
Power Apps
Answered

Gallery questions and answers save excel

(0) ShareShare
ReportReport
Posted on by 109

Hi i have to table questiondata and Answe_data

 

i need save the answer from the gallery1

 

dursunzeeee_0-1618964261183.png

 

Categories:
  • dursunzeeee Profile Picture
    109 on at

    i used this formul but record just one what is the wrong

    dursunzeeee_0-1618965457615.png

     

     

    Patch(Answer_Data;Defaults(Answer_Data);{Answer:TextInput1.Text;Q_Id:Label6.Text;Answer_Dates:DatePicker1.SelectedDate;User_Name:TextInput2.Text})

     

  • KrishnaV Profile Picture
    5,023 on at

    Hi @dursunzeeee ,

     

    Where do you want to save the data? what is the data source you are using could you please elaborate more on this?

  • dursunzeeee Profile Picture
    109 on at

    i want to save answer excel 

  • dursunzeeee Profile Picture
    109 on at

    i used this formul but record just one what is the wrong

    dursunzeeee_0-1618965735459.png

     

     

     

  • KrishnaV Profile Picture
    5,023 on at

    Hi @dursunzeeee ,

     

    Where is your excel? is it in the app or in a sharepoint / ondrive? could you please elaborate more on how you are managing the data in the app?

  • dursunzeeee Profile Picture
    109 on at

    in one drive

     

    dursunzeeee_0-1618965897509.png

     

  • KrishnaV Profile Picture
    5,023 on at

    Do this,

    ForAll(Gallery1.AllItems,Patch(Answer_Data,Defaults(Answer_Data),{Answer:ThisRecord.TextInput1.Text}))
  • dursunzeeee Profile Picture
    109 on at

    Hi Thank you but record just gallery answer i want to record like first colum

    dursunzeeee_0-1618966825988.png

     

  • Verified answer
    KrishnaV Profile Picture
    5,023 on at

    here is the complete code block, now this will add all the columns. 

    ForAll(Gallery1.AllItems,Patch(Answer_Data,Defaults(Answer_Data),
    {Answer:ThisRecord.TextInput1.Text;Q_Id:ThisRecord.Label6.Text;Answer_Dates:ThisRecord.DatePicker1.SelectedDate;User_Name:ThisRecord.TextInput2.Text}))

     

  • KrishnaV Profile Picture
    5,023 on at

    @dursunzeeee ,

     

    did this work for you???

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 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard