Unanswered

Each screen's input goes to a new row

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want the information from one screen to the seventh screen (for example) to all save on the same row but still under their respective columns until I navigate back to screen 1 to start a new row for the next inspection. There's no way all my info can be done as a series of dropdowns on one screen, there's just too much. How can I fix this problem? It makes a real mess.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

cds 1,001 on at

Like (0)

Report
Copy link

Link copied!

you can set an object when you change screens..

Set(Answers, {
question1: textinput.text,
question2: checkbox.value,
...
})

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like (0)

Report
Copy link

Link copied!

You can reference controls from any screen, so don't feel limited to have them all on one.

I do not recommend the global variable approach, because you'll either need one per screen load, or will be updating the same variable each time.

Instead, I recommend you name your dropdowns, boxes, inputs, etc. with clear names. Like 'drpState' and 'txtCity' if you had a drop-down for state and a text input for city.

Then, once the user is done, add a function to a button to collect all the controls into a collection.

Collect ( colName, { inputColumn1: drpState.Selected.Text, inputColumn2: txtCity.Text } )

Then make sure to Reset all the controls, and navigate then back to the start. Each time they finish and click the button, a new row will be added.

You can then add other columns, like the User().FullName, etc. to further add context.

Good luck!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Just so I am understanding correctly, are you saying that the only way to have each input from each screen be inserted into the same row until the whole process is done is to not have the controls save to my collection each time but to have them all, from all controls on all screens, attached to one button at the last screen?

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like (0)

Report
Copy link

Link copied!

You could save as you go. I'll show an example below. However, I just want to be clear that the Collection is local to the app itself until you take that data and write it to a data source. I was under the impression you just didn't want a lot of controls on one screen, and wanted to put it all in a row together once the user was done. If you're looking to save their progress that's different. Again, however, if you're not writing the data outside the app, you'll lose it when the close the app.

To save as you go, begin by adding a row and assigning it a way to uniquely identify the row.

Set ( gblRecordId, GUID() )

Then immediately add the row, or at first screen click, and then update the row whenever you'd like.

Collect ( colName, { appId: gblRecordId } )

UpdateIf ( colName, appId = gblRecordId, { columnToUpdate: valueToUpdate } )

You can update as many columns at a time as you want. If the column doesn't exist yet, it'll add it. If it does, then you've isolated the row and the they'll be updated. You can do the update each time you Navigate for all controls on that screen for example.

Was this reply helpful? Yes No