Hi everyone,
I want to set a value in a dropdown chart which is part of a edit form.
The value should be fixed and the users should not be able to change it.
The form is connected to a sharepoint list. The mentioned dropdown reffers to a lookup column in the shareloint list.
Thanks in advance!
Solved! Go to Solution.
For your requirements, you can do this:
For more information, refer: Drop down control in Power Apps
Additional reference: How to set a pre-populated default value of a Dropdown in EditScreen
Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it 👍
Hi@MES,
Based on the issue that you mentioned, do you want to set the default value of a drop down control?
Could you please share a bit more about the drop down control, is it a Combo Box or a simple Dropdown?
Please share you formula and the error message.
1).If you generate this app directly based on the SP list, I think the drop down control is a Combo Box.
If you want the value to be fixed, you should set the DefaultSelectedItems property.
["Value"] // For a specific value you want.
If you want to lookup a specific value based on other field, please check as below:
LookUp(SPList,ID=1,LookupColumnName)
2). If you have a Dropdown, please set the Default property as below:
"Value"
If the above could not solve your problem, please do post your formula and error message.
Regards,
Qi
For your requirements, you can do this:
For more information, refer: Drop down control in Power Apps
Additional reference: How to set a pre-populated default value of a Dropdown in EditScreen
Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it 👍
I tried allready the solution that you have linked. But the "=" is shown as invalid argument.
Is it possible to use another syntax?
Hi@MES,
Based on the issue that you mentioned, do you want to set the default value of a drop down control?
Could you please share a bit more about the drop down control, is it a Combo Box or a simple Dropdown?
Please share you formula and the error message.
1).If you generate this app directly based on the SP list, I think the drop down control is a Combo Box.
If you want the value to be fixed, you should set the DefaultSelectedItems property.
["Value"] // For a specific value you want.
If you want to lookup a specific value based on other field, please check as below:
LookUp(SPList,ID=1,LookupColumnName)
2). If you have a Dropdown, please set the Default property as below:
"Value"
If the above could not solve your problem, please do post your formula and error message.
Regards,
Qi
Thank you!
Yes it is a ComboBox (I thought it is a Dropbox) and I tried it before as you stated in 2).
With 1) it works fine.
User | Count |
---|---|
164 | |
96 | |
78 | |
73 | |
59 |
User | Count |
---|---|
207 | |
167 | |
98 | |
93 | |
79 |