Share
Report
14Using the following guide Power Apps Deep Links: Email Direct Link To A Specific Record I am attempting to modify my “New Starter” App to notify a line manager (via email) that a new request with details has been submitted.
HR will create a request for a new starter on the New Starter Power App form. They fill in fields they only having write access to certain fields (other fields are read only and are for the Line Manager or IT to fill in further down the process). Once HR submit the new Starter Form an email will be sent to the line manager. The email will contain a link that will direct the line manager to the original new starters PowerApps form. This form will be populated with the new starter form details entered by HR. Pulled the new starters details from a SharePoint list. Identifying the new starter by UPN (user principal name - unique field). The form will be allowing the line manager (based on who is logged in) to then enter details into their write only fields and submit the new starter form to IT to repeat the process and create the account.
The issue I am encountering is that the link in the email has the Canvas App Web Link and the unique ID “UPN” however when clicking on the link the New Starter form appears empty. Not pulling the data for the SharePoint list where the UPN in the email is = to UPN in the SharePoint list.
Below are some of the step’s details throughout the guide that I have applied to my New Starter App and New Starter Flow.
ViewForm(Form2);
Notify("Record has been submitted successfully!",NotificationType.Success, 0);
Below is the email I had received as you can see the variable are being pulled through the email correctly:
The link is the following: https://apps.powerapps.com/XXXXXXXXXX&upnsubmission=sjackson@something.com.
When you arrive at the form you can see it’s not pulling the data through. Even though there is a SharePoint entry equal to the UPN used in the email and in the url.
If anyone could assist in identifying the issue, pointing me in the correct direction or if there is a more simplified way to achieve this your help would be greatly appreciated.
HR will create a request for a new starter on the New Starter Power App form. They fill in fields they only having write access to certain fields (other fields are read only and are for the Line Manager or IT to fill in further down the process). Once HR submit the new Starter Form an email will be sent to the line manager. The email will contain a link that will direct the line manager to the original new starters PowerApps form. This form will be populated with the new starter form details entered by HR. Pulled the new starters details from a SharePoint list. Identifying the new starter by UPN (user principal name - unique field). The form will be allowing the line manager (based on who is logged in) to then enter details into their write only fields and submit the new starter form to IT to repeat the process and create the account.
The issue I am encountering is that the link in the email has the Canvas App Web Link and the unique ID “UPN” however when clicking on the link the New Starter form appears empty. Not pulling the data for the SharePoint list where the UPN in the email is = to UPN in the SharePoint list.
Below are some of the step’s details throughout the guide that I have applied to my New Starter App and New Starter Flow.
- I can see the details being pulled from the form for PowerFlow (upn, firstname, lastname etc are all in the email)
- Permissions the user I am access the form with has full permissions to view all fields and edit them. Also, the user has access to the SharePoint List
- I can also see the UPN appended to the end of the Weblink when clicking on the link and viewing the address I am being diverted to
- All the data is saved to the SharePoint list.
- I have not used the @{triggerOutputs()? command. Replaced with a variable pulled from the form and appended to the weblink url
- DefaultMode property of the app = FormMode.New
- OnSelect property of the form to submit = SubmitForm(Form2);
- OnSuccess property of the form =
ViewForm(Form2);
Notify("Record has been submitted successfully!",NotificationType.Success, 0);
- Item property of the form = VarRecordStarter
- Visible property of the submit button = Form2.Mode<>FormMode.View
- Got the Canvas Web link
- Created a automated flow
- Pulls four variables from the App (Line Manager Name, Starter Name, Line Manager email and Starter UPN).
- Then compose email with Body that contains the weblink (<a herf= “https……&upnsubmission=”StarterUPN”
- Use Send Email (V2) to submit email with body, link and variable details.
- OnStart property of the app =
Set(
VarRecordStarter,
LookUp(
'New Starter Information',
ID = Value(Param("upnsubmission"))
)
);
If(
!IsBlank(VarRecordStarter),
ViewForm(Form2)
)
The Power Flow has the following steps:
LookUp(
'New Starter Information',
ID = Value(Param("upnsubmission"))
)
);
If(
!IsBlank(VarRecordStarter),
ViewForm(Form2)
)
The Power Flow has the following steps:
Below is the email I had received as you can see the variable are being pulled through the email correctly:
The link is the following: https://apps.powerapps.com/XXXXXXXXXX&upnsubmission=sjackson@something.com.
When you arrive at the form you can see it’s not pulling the data through. Even though there is a SharePoint entry equal to the UPN used in the email and in the url.
If anyone could assist in identifying the issue, pointing me in the correct direction or if there is a more simplified way to achieve this your help would be greatly appreciated.
Categories:
All responses (
Answers (
