cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
orbd
Frequent Visitor

Editing a record from a flow/powerapp?

Hi everyone,

 

I've built an app that submits a record to a SharePoint list. This app assigns certain tasks to users (which is selected within app) and then emails them with the task. I'd like to create a second app that lets the assigned user edit and complete that task, which reflects in the SharePoint list. I'd like this second app to be linked in the email that is created from the flow.

 

Any hints on how this could be accomplished?

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @orbd ,

Could you please share a bit more about your scenario?

Do you want the link to your second app to be included within the body of the email which sent from a flow?

Further, do you want the user to click the link in the body of the received email to open the second app to complete their own task?

 

Based on the needs that you mentioned, I think PowerApps could achieve your needs. I assume that you send the email using a flow (MS flow), is it true?

 

I have made a test on my side, please take a try with the following workaround:

Flow's configuration:1.JPG

The Param1 and Param2 represents the parameter values you want to pass from the link to your second app. The AssignedTo column is a Person column in my SP list, which used to store the user the task assigned to.

More details about getting the Web link of your second canvas app, please check the following blog:

https://powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/

In addition, please also check and see if the my response within the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Email-Notifications/m-p/183482#M60412

 

 

Within your second app, set the OnStart property of the App control to follownig:

Set(TaskID, Param("ID"));
Set(AssignedUser, Param("AssignedUser")) /* <-- Using Param() function to receive parameter values passed from the link within the body of email sent from above flow */

Then within your app, you could find the corresponding task record from your SP list for the specific user using following formula:

LookUp(
            'YourTaskList',
             ID = TaskID && AssignedTo.DisplayName = AssignedUser
)

 

More details about setting a parameter value within the URL link to your app, please check my response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/Email-Notifications/m-p/183482#M60412

More details about displaying the record within the Edit form based on the parameter value in the URL link, please check the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/how-to-Link-directly-to-the-item-on-the-Detai...

 

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-xida-msft
Community Support
Community Support

Hi @orbd ,

Could you please share a bit more about your scenario?

Do you want the link to your second app to be included within the body of the email which sent from a flow?

Further, do you want the user to click the link in the body of the received email to open the second app to complete their own task?

 

Based on the needs that you mentioned, I think PowerApps could achieve your needs. I assume that you send the email using a flow (MS flow), is it true?

 

I have made a test on my side, please take a try with the following workaround:

Flow's configuration:1.JPG

The Param1 and Param2 represents the parameter values you want to pass from the link to your second app. The AssignedTo column is a Person column in my SP list, which used to store the user the task assigned to.

More details about getting the Web link of your second canvas app, please check the following blog:

https://powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/

In addition, please also check and see if the my response within the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Email-Notifications/m-p/183482#M60412

 

 

Within your second app, set the OnStart property of the App control to follownig:

Set(TaskID, Param("ID"));
Set(AssignedUser, Param("AssignedUser")) /* <-- Using Param() function to receive parameter values passed from the link within the body of email sent from above flow */

Then within your app, you could find the corresponding task record from your SP list for the specific user using following formula:

LookUp(
            'YourTaskList',
             ID = TaskID && AssignedTo.DisplayName = AssignedUser
)

 

More details about setting a parameter value within the URL link to your app, please check my response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/Email-Notifications/m-p/183482#M60412

More details about displaying the record within the Edit form based on the parameter value in the URL link, please check the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/how-to-Link-directly-to-the-item-on-the-Detai...

 

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,318)