Context
I have a power app that collects data from user who want to gain new access, change access, or delete access to financial data within my company. The data sources are SQL Server tables, Office365Users, and Office365Outlook. After the user completes all the required data fields, they will select a Submit button. When the select button is clicked, the app writes a new record to a SQL table, sends an email to the user, the user's manager, and an internal email address (solutionscenter@euronetworldwide.com), then resets variables, the form, and returns to the first screen.
Details
This is the OnSelect property setting for the Submit button includes a deep link that directs the associate who enables, disables, or changes the user's access back to the app with the intent to update three fields within the power app, and then update the SQL record. This is the full OnSelect property setting:
Set(SubmitClicked,false);
Set(IsValid,true);
If
(
IsBlank(ManagerName_CardValue) ||
IsBlank(ManagerEmail_CardValue) ||
IsBlank(ManagerDepartment_CardValue) ||
IsEmpty(UserName_ComboBox.SelectedItems) ||
IsBlank(UserDepartment_CardValue) ||
IsBlank(UserEmail_CardValue),
Set(IsValid,false);
Notify("Please provide input for all required fields.", NotificationType.Error, 10000);
Set(varSubNotificationMSG2,"Please provide input for all required fields.");
Set(SubmitClicked, true);
);
If
(
ChangeUser_DropDown.Selected.Value="Yes" &&
IsBlank(ChangeDescription_CardValue),
Set(IsValid,false);
Notify("Please provide input for all required fields.", NotificationType.Error, 10000);
Set(varSubNotificationMSG,"Please provide input for all required fields.");
Set(SubmitClicked, true)
);
If
(
IsValid = true,
If
(
AddUser_DropDown.Selected.Value = "Yes",
Navigate(RequestedAccess_Screen,ScreenTransition.Fade),
If
(
DeleteUser_Dropdown.Selected.Value = "Yes" ||
ChangeUser_DropDown.Selected.Value = "Yes",
Set(SubmitClicked, true);
Set(varSubNotificationMSG, "Your request has been submitted. Thank you.");
Office365Outlook.SendEmailV2
(
Concatenate(UserEmail_CardValue & ";",ManagerEmail_CardValue & ";","solutionscenter@euronetworldwide.com"),// email address
Concatenate("epay Insights User Access Request" & " - " & Request_ID_Label.Text),
Concatenate(
"Date: ", DateRequested_CardValue & "<br>" & "<br>" &
"Please Assign JIRA ticket to the Global Insights Team." & "<br>" & "<br>" &
"The User and Manager will be emailed a copy of this information. A JIRA ticket will be auto-generated, and the user who completed the request will receive an email from JIRA with the JIRA ticket number." & "<br>" & "<br>" &
"<b>" & "Managers must approve access. The approval can be in email form attacked/included in the JIRA ticket, or the manager can add an approval comment directly in the JIRA ticket." & "</b>" & "<br>" & "<br>" &
"<b>" & "Request ID: " & "</b>", Request_ID_Label & "<br>" & "<br>" &
"<b>" & "USER INFORMATION" & "</b>" & "<br>" &
"Manager Name: ", ManagerName_CardValue & "<br>" &
"Manager Email: ", ManagerEmail_CardValue & "<br>" &
"Manager Department: ", ManagerDepartment_CardValue & "<br>" &
"User Name: ", UserName_ComboBox.Selected.Name & "<br>" &
"User Department: ", UserDepartment_CardValue & "<br>" &
"User Email: ", UserEmail_CardValue & "<br>" & "<br>" &
"<b>" & "ADD ACCESS INFORMATION" & "</b>" & "<br>" &
"Read Only Approval: ",ReadOnly_Approval_DropDown.Selected.Value & "<br>" &
"Add User: ", AddUser_DropDown.Selected.Value & "<br>" &
"Access Requested: ", "<br>" &
Concat(RegionMargin_ComboBox.SelectedItems,Region, "<br>") & "<br>" & "<br>" &
"<b>" & "DELETE USER INFORMATION" & "</b>" & "<br>" &
"Delete User: ", DeleteUser_Dropdown.Selected.Value & "<br>" & "<br>" &
"<b>" & "CHANGE USER INFORMATION" & "</b>" & "<br>" &
"Change User: ", ChangeUser_DropDown.Selected.Value & "<br>" &
"Change Description: ", ChangeDescription_CardValue & "<br>" & "<br>" &
"<b>" & "FOR INSIGHTS INTERNAL USE ONLY" & "</b>" & "<br>" &
"Link: " & "<a href='https://apps.powerapps.com/play/e/default-5b5ce690-c127-44b6-bfec-2df9a337fbb1/a/c941dd6a-c030-4626-9eb7-07e66be5abb6?tenantId=5b5ce690-c127-44b6-bfec-2df9a337fbb1&hint=88fbbb94-7823-44b0-b68e-d12e03e1f86a&sourcetime=1698870469210?RequestID=" & varRequestID & "'>User Access Request Record</a>"
);
);
Patch
(
epayInsights_UserAccessRequestData,
Defaults(epayInsights_UserAccessRequestData),
UserInfo_Form.Updates,
RequestedAccess_Form.Updates
);
ResetForm(UserInfo_Form);
ResetForm(RequestedAccess_Form);
Set(varSubNotificationMSG, "");
Set(SubmitClicked,false);
Navigate(Instructions_Screen)
)
)
);
As mentioned, the app will deliver three emails: an email to the user indicated in the form, the user's manager indicated in the form, and to an internal email address "solutionscenter@euronetworldwide.com". The email to "solutionscenter@euronetworldwide.com" will auto-generate a JIRA ticket that looks like this:
Once the associate who completes the ticket, they will click the hyperlink and return to a different screen within the power app. The new screen looks like this:
The app auto-populates the ProvisionedBy field with the current Office365User, and it sets the Date Provisioned to Now(). I would like to auto-populate the JIRA Ticket field with the URL from which the person who clicked on the link originated from. That URL will be similar to this: https://euronet.atlassian.net/browse/ESC-46585; however, the ESC-46585 will change for every ticket. Can what I've described be done? If so how? I've tried several things, but have been unsuccessful.
Thank you in advance for assistance.
