Solved: Dropdown is going to default value after selecting...

Anonymous · ‎08-11-2020

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

rebeccas · ‎08-17-2020

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

rebeccas · ‎08-11-2020

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 · ‎08-11-2020

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.

rebeccas · ‎08-11-2020

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 · ‎08-11-2020

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

rebeccas · ‎08-11-2020

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 · ‎08-11-2020

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.

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

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

Regards,

Rakesh

rebeccas · ‎08-11-2020

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 · ‎08-11-2020

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 · ‎08-11-2020

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