cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dropdown is going to default value after selecting the answer

Hi All,

I have created a canvas by using Gallery for building the questions, I have a drop down created as Input and the dropdown items are

Items:["","1","2","3","4","5","N/A"]

Onchange:Patch(Table1,ThisItem,{'Actual Maturity':Dropdown1.SelectedText.Value})

 

After selecting the value from the dropdown the value is saving to Source/table but the value in the canvas is going back to default value again. 

But what ever the answer end user in selecting is storing the source but same answer is not showing up in canvas.

 

Regards,

Rakesh

1 ACCEPTED SOLUTION

Accepted Solutions

The reason I said the layout of a row per entry and a column for each question is you can then store other relevant information once...like who submitted it and the date/time they submitted it.

 

User         Date/Time              Question1   Question 2   Question3

Name      01/01/20 8:00 AM   Yes              No               Yes          <--- This would be an example of the row data

 

It will keep your data source from getting crazy long. I typically do SharePoint list for my data source but not getting the data too long is even more important if you are using Excel.

View solution in original post

16 REPLIES 16
rebeccas
Community Champion
Community Champion

Have you tried it in Play mode instead of Edit mode? To see it work in Edit Mode and have it show the Refreshed data you can put in a Refresh(Table1) after your Patch. 

Anonymous
Not applicable

Thanks for the reply, I have not tried in playmode.

My problem is same after few seconds of selecting the answer from drop drown again the same dropdown is going to default value.

My requirement is until the end users answers all the questions in Gallery, the selected answer should remain as the the answer selected by end user.

 

 

There are a few ways you can achieve that. I would suggest you don't patch the data source on the combo box selection.

 

You can either store the values in a collection until they have answered all the questions and then Patch to your data sources all the responses at once. 

 

The other option would be to either show all the questions or show/hide one question at a time until they have answered them all and then have a Submit button that then Patches all the values at once. 

 

Here is a video I did about a year ago that shows how to show/hide data on one screen:

https://youtu.be/CtsDTlYPLjY

 

(I'm not super good at videos, just do it for fun but you will get the concept)

Anonymous
Not applicable

Hi Rebecca, 

Thanks for your reply.

It would be great if you help me how to do this ?

"You can either store the values in a collection until they have answered all the questions and then Patch to your data sources all the responses at once. "

 

Regards,

Rakesh

Yes, I will give you some tips on this. First I have two questions:

 

1) Is your data source an Excel sheet? (thinking that from the fact that you are referring to Table1)

2) Do you have your combo box currently in a Gallery or a Form? (I saw you referred to ThisItem. with what you had on your combo box so just trying to figure out where you have it that it is referring to that)

Anonymous
Not applicable

Thanks !

1) Is your data source an Excel sheet? (thinking that from the fact that you are referring to Table1) -- Yes

 

2) Do you have your combo box currently in a Gallery or a Form? (I saw you referred to ThisItem. with what you had on your combo box so just trying to figure out where you have it that it is referring to that)- Yes I am referring to ThisItem.

 

image.png

Items: ["","1","2","3","4","5","N/A"]

OnChange : Patch(Table1,ThisItem,{'Actual Maturity':Dropdown1.SelectedText.Value});Refresh(Table1)

 

Regards,

Rakesh

 

Okay, with the last bit of info I don't even think you need to bother with the collection. 

 

If you just add in a Submit button or icon that is disabled until all questions have been responded to and then have the icon/button Patch all the items at one time. I often even put a message in red that says "You have responses that are required to submit." and make it visible until all questions have been answered and then when the message is not showing the button is enabled but disabled until then.

 

Does this make sense?

Anonymous
Not applicable

If you just add in a Submit button or icon that is disabled until all questions have been responded to and then have the icon/button Patch all the items at one time.-- Yes this what I am looking for.

I have some questions now.

1. As I am using Gallery, I have more than 50 questions, so where do you want me to add that button?

2. I have 3 sections of questions example 1.Required 2.Optional 3.Assessed, and this questions are not in serial number they are jumbled, so I want to store the answer to respective question .

"Patch(Table1,ThisItem,{'Actual Maturity':Dropdown1.SelectedText.Value});Refresh(Table1)" 

This is working fine to save the answers to that particular question.

3. Please let me know the formula for the button ?

 

Thanks !

Rakesh

 

Anonymous
Not applicable

Hey @rebeccas .

If you just add in a Submit button or icon that is disabled until all questions have been responded to and then have the icon/button Patch all the items at one time. I often even put a message in red that says "You have responses that are required to submit." and make it visible until all questions have been answered and then when the message is not showing the button is enabled but disabled until then.

 

Does this make sense? Yes.

Please help me in doing this.

 

Regards,

Rakesh

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,839)