I added a drop down and made its item as below :
["SERVICE","MINOR-REPAIR","MAJOR-REPAIR","INSPECTION","GREASING","OTHERS","BOUGHT-OUT","SUBLET-JOB"]
Data entry and all is working fine, but one of the user typed out some thing else apart from the above dropdown selection.
Which may create problem for reporting.
I want to restrict user to select only from the dropdown selection.
Please advise.
Yes, in the update property of the card, I added EDropdown1.Selected.Value, so when the dropdown is selected, the data is considered the value for the that Textinput.
It is not possible at the same update property some more coding can be done for the requirement.
Please advise
The key is the Update property of the card. Assuming the dropdown you added is called Dropdown1, the Update property should be: Dropdown1.Selected.Value. Hide the textbox in the card. It is irrelevant. Set the default property of the dropdown to Parent.Default.
Nothing else in the card matters as PowerApps uses th Update property to enter the data.
I am sorry that I was unable to explain in detail. I will try to provide details info why it is required to do so.
I made the power app by wizard by selecting one of the list of the sharepoint, as you know it gives , 3 screens (gallery, edit and new).
That list is also connected to a Access database front end, where user post data when he is in office by PC. The Access application takes care of the wrong select - as there is a built in function for the dropdown.
To achieve the same , I took the Edit screen and inserted a dropdown control and connected it to the textinput control and hide the actual textinput control. Dropdown control is working fine while editing the form or adding new.
Below is the screen shot:
As the data study reports are based are this above shown list, if user type spelling error like Services instead of Service, The Access query search and report gets disturbed.
Therefore, I was looking for a solution where the user can be stopped from typing and should select only from the drop down.
I hope it will be clear to you about my requirement, why it is required to do so.
Kindly review my above requirement and guide me how to achieve this requirement on the edit form.
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,011
Most Valuable Professional
Share
Report
All responses (
Answers (
