- User clicks the Job Number combo box which pulls data from the Source_JobInfo SharePoint list.
- User select the appropriate Job Number which auto populates Job Title, Start Date, and Current Job Leader
- User selects the New Job Leader from a combo box then clicks a Submit button.
- Data from Power App is written to SharePoint list Form_ChangeRequest
- Power Automate approval workflow is triggered
- Exit() is triggered which wipes the Power App form page and navigates back to Power Apps landing page.
- Note: Power Automate updates the status field at top of the app page and on the approver rows at button of the app page.
What am I stuck on?
- Job Support Specialist wants to return to the form in order to make a correction to the Job Number. An Edit Button is clicked which navigates to the app and passes in a parameter into a variable, varReqNum.
- The fields in the form are populated from the Form_ChangeRequest list using a lookup function: Example: Lookup(Form_ChangeRequest, Request Number= varReqNum, Job Title)
- Here is what I’m stuck on: The lookup table does not work for the combo boxes. I want the users previous selection (example: JN56932) to be displayed in the combo box and, if needed, a new selection made. Click a save button will rewrite to the existing record
An important limitation is that I’m not placing any logic or dropdowns in the SharePoint list itself. The SharePoint lists are strictly text, numbers and dates.

Report
All responses (
Answers (