Collecting text input fields from a gallery

(0) Share

Report

Posted on by ccqn

205

Hi everyone,

I would like to save all the data that is entered in the text fields in a gallery into a collection on the click of a button which I am trying to achieve through this formula.

Collect(
 DataToPatch,
 ForAll(
 Gallery5.AllItems,
 {
 rowNum: Label20.Text,
 repNum: Label24_1.Text,
 department: Dropdown8.Selected.Dept,
 hod: Label37.Text,
 level: Radio5_1.Selected.Value
 // Add more fields as needed
 }
 )
);

However I am running into a problem whereby I am only saving the data of the current item in the gallery. I am not sure if it matters but all the text labels and dropdown boxes etc. are placed in a container within the gallery. Your help would be very much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Hi @ccqn,

You could use the OnChange property of the Text Input and Drop down control.
Patch(Collection Name, ThisItem, {'Column Name': Self.Text}) Patch(Collection Name, ThisItem, {'Column Name': Self.Selected.Value})

And for your button OnSelect property:
Patch(Table Name, Collection Name);

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report

Hi @AARON_C ,

Thank you that worked like a charm to patch to the collection. However now I have a problem where the value in my dropdown box disappears after I select it.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Hi @ccqn,

Do you have the Default property of the Drop down set to:
ThisItem.'Column Name'

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report

Hi @AARON_C ,

Just changed it and it works now! But unfortunately I have ran into another problem..... I am currently using a vertical container with scrolling and upon choosing a field, the container keeps scrolling to the top by itself. Any ideas on how to deal with that...

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report

Hi @ccqn,

Can you provide some more detail or screen shots of your app? Does this gallery control need to be in a container?

I am trying to replicate your issue, but I am getting it to work fine on my end I think. I have just placed a gallery control inside of a container.

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report

Hi @AARON_C ,

This is how my gallery is structured.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report

Hi @ccqn,

Sorry, I am not too sure about the issue you are getting. My side seems to work fine, it does not move when I click on any of the input controls. I will keep looking into this to try and replicate it.

Hopefully someone else knows the answer to this.

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report

Hi @AARON_C ,

Thank you so much for your help thus far. The autoscrolling only happens when I change the value of the input control, not when I am clicking on it.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report

Hi @ccqn,

It could just be power apps being power apps. I have created the same structure gallery as you have and I am not having any issues.

Maybe try saving the app and opening it back up?

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No