I have two cases in one PowerApps application where I need to use a Dropdown control.However, I may be trying to force a dropdown to do something that it was not designed for.
I need help on the following on how to accomplish this. This is my first PowerApps. I am normally designing C# or VB.Net applications.
I have my PowerApps application connected to a SharePoint List. Currently the list consists of only a few fields and 3 records used for Task Management.
Fields: Work Order, Person Assigned, and Priority Level. All are single line text datatypes.
Case 1)
My Browse page loads all the records. Then if I want to edit an existing record/row or add a new record/row, I use an Edit form with DataCards for each field as a textbox. However, I would like to swap out my Priority Level textbox to a dropdown control, so a user does not have to type in the new priority level. My goal is to be able to edit the current rows Priority Level using a dropdown. The dropdown needs to have a choice of [1-10] that the user can select from. Therefore, if the current row being edited is Work Order] [200] , Person Assigned [J Smith], Priority Level [3]. I want the user to be able to select a different Priority Level from the dropdown and choose a value from 1 to 10 from a static predefined collection. For example, if value 1 is selected from the dropdown it needs to change the current rows value being displayed from 3 to 1. This would mean that one dropdown control needs to; have the current row connected to the SharePoint List and be able to provide the dropdown choices from 1 to 10. Can a dropdown do this? Or do you have to use a textbox to display the current rows field value and a dropdown with static values from 1 to 10 as choices that will update the textbox? I prefer that the dropdown can do both. And even better is to have One SharePoint list contain the rows, and another SharePoint list that contains the Priority Level values 1 to 10. And connect to both lists from one PowerApps simultaneously.
I have supplied a screenshot of my failed attempt at the end of these questions.
Case 2)
Same scenario as the first case. But have the dropdown control retrieve the entire list of possible persons that names exist in a group from Microsoft Teams and provide that list as dropdown choices when the current displayed record is modified, or a new record is to be entered.