Hello everyone!
Right now I'm working on a tool that basically connects a Excel file in one drive with a Power Apps tool.
The Excel file looks like the following:
The app to be created looks like the following:
The idea is to have 3 dropdowns in the power app as shown in the previous picture.
Each dropdown has 3 options: "Yes", "No" and an empty option " ".
Each dropdown in the power apps should be linked to the values in cells "B2", "B4" and "B6" of the Excel file.
My goal is to change the value in the dropdowns from the Power Apps tool, so that it automatically changes the values in cells "B2", "B4" and "B6".
For example:
If I set the values in the dropdows as follows:
Then the values of "B2", "B4" and "B6" should display the following:
Something important: the dropdowns are named as follows:
Dropdown 1: DP1_1
Dropdown 2: DP1_2
Dropdown 3: DP1_3
I think it is an easy, however I'm not experienced at using power apps at all, so I'll really appreciate your help.
Thanks all! 🙂
