Hello,
so i have this excel sheet that has a rows, and these rows have dropdown list from DataValidation.
What i intend to do is, create a CRUD or read from Excel with the ability to edit, however the edit of the field should be a dropdown reading from the excel values, and updating when i submit.
Hi @hassanmoukadem ,
If I understand correctly:
Power Apps does not retrieve the formatting or data validation from Excel.
As a better practice, if you would like to maintain the same validation between Power Apps and Excel, you can create a separate table in Excel that contains all the values.
When setting up Data Validation, choose to Allow "List" and set its source to the cells containing the choices you want:
In Power Apps, when adding data sources, add both the main table as well as the table(s) of options.
Then set the Items property of the drop down menu or combo box to the respective table.
Both Excel and Power Apps would reference the same choices this way.
Hello @Mr-Dang-MSFT .
thank you, that would solve the issue of value in the drop down, but that would not affect the current row, which i would like to first read its CURRENT value, and be able to update it based on the drop down.
Find attached.
Many Thanks.
Hi @hassanmoukadem ,
I'm not sure I entirely understand how you intend to design your app.
If you would like to see the currently selected value as well as what you want to change it to, the common pattern with drop down menus is that they show the current selection at the top and highlighted:
If you are not sure what you changed the value to before committing changes, I suggest using two controls in the edit form of the app. Below is an example of what this might look like.
You can complete this in these steps:
"Current: " & Parent.UATChanges
(Change UATChanges to the name of the column)
The form now shows the current value in the new label we inserted, but it will still save whatever is selected in the existing drop down menu.
User | Count |
---|---|
24 | |
21 | |
6 | |
5 | |
4 |
User | Count |
---|---|
29 | |
23 | |
10 | |
8 | |
6 |