cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
orbd
Level: Powered On

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
Community Support Team
Community Support Team

Re: Editing a record from a flow/powerapp?

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
Community Support Team
Community Support Team

Re: Editing a record from a flow/powerapp?

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,703)