cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
amgravs2
Level: Powered On

Updating a Spreadsheet from Lists of Data based on User Selection

Hopefully someone can help:

 

We're trying to create an app that tracks finish selections for an apartment. The user will need to be able to select a specific apartment, followed by the rooms and then choose finish options (i.e. flooring/paint). However, the app needs to retain the ability to modify these selections in the future - ideally selecting finishes will be tied to unit prices that will automatically sum with quantities while working with the app.

 

Currently we're experiencing troubles utilizing the "Edit Form" function. Every time we navigate to the screen where users would begin to make their choices, the form area says "no data to display." We have gone through several tutorials and still cannot figure it out.

 

We so far have been able to make the process of selecting a floor -> unit -> room but now need help creating a process to update the finish selections based on user input. How do we set up the actions for successfuly navigating to the edit form field and from there to finish options (flooring 1, flooring 2, etc.)  that update the spreadsheet with choices once selected.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Updating a Spreadsheet from Lists of Data based on User Selection

Hi @amgravs2

 

Edit Forms, Display Forms,...are something can be created automatically and then, Unlock to modify / Edit to suit your needs.

 

This: https://powerapps.microsoft.com/en-us/tutorials/working-with-forms/

in fact, is very clear on how to:

- Create New(Form1)

- Edit EditForm1

- Submit (Form1), etc.

 

I hope you can look at this.

 

TQ & G9

hpkeong
Community Support Team
Community Support Team

Re: Updating a Spreadsheet from Lists of Data based on User Selection

Hi @amgravs2,

 

What is your current situation?

In addition to the article share by hpkeong, please also check the following article:

Edit form and Display form controls in PowerApps

If you would like to Edit the record, we need to change the form mode of EditFrom control into Edit mode.

And specify the corresponding record under the item property with the one you would like to work with.

If you need any further help on this, please feel free to post back.

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

Re: Updating a Spreadsheet from Lists of Data based on User Selection

Hi @amgravs2

 

Edit Forms, Display Forms,...are something can be created automatically and then, Unlock to modify / Edit to suit your needs.

 

This: https://powerapps.microsoft.com/en-us/tutorials/working-with-forms/

in fact, is very clear on how to:

- Create New(Form1)

- Edit EditForm1

- Submit (Form1), etc.

 

I hope you can look at this.

 

TQ & G9

hpkeong
Community Support Team
Community Support Team

Re: Updating a Spreadsheet from Lists of Data based on User Selection

Hi @amgravs2,

 

What is your current situation?

In addition to the article share by hpkeong, please also check the following article:

Edit form and Display form controls in PowerApps

If you would like to Edit the record, we need to change the form mode of EditFrom control into Edit mode.

And specify the corresponding record under the item property with the one you would like to work with.

If you need any further help on this, please feel free to post back.

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amgravs2
Level: Powered On

Re: Updating a Spreadsheet from Lists of Data based on User Selection

After reading through all of the links, we managed to get the functionality by creating the app using the "Start with Data" options rather than a blank template. Thanks for the help.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Tomorrow, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 110 members 3,745 guests
Please welcome our newest community members: