cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KJC
Helper I
Helper I

PowerApps - Link SharePoint List item

Hi,

 

I created a simple Power App that is connected to a SharePoint List. When a user presses the submit button in Power Apps it creates a SharePoint List item and then an approval Flow is triggered. However, I cannot get a link to the item in the Approval, I need the approver to click a link so they can see what they approving. 

 

When I first test within Power Apps it all appears to work fine. But when testing with a live user the Flow keeps failing as it does not grab the ID of the SharePoint List item. Please see attached the error I keep getting. 

 

I'm so close to creating my first app so any help would be amazing.

 

Many thanks 

Cover image preview

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @KJC ,

 

If I was building this, I would change the flow to not be called by the app, but to have a trigger "When an item is created". From there, you can always capture the current record's ID and pass it in the approval step.

 

In the app itself, keep only the submit form.

 

Please let me know if this helps or you need further help.

View solution in original post

4 REPLIES 4
PTBBSolutions
Solution Supplier
Solution Supplier

Hello @KJC ,

 

What are you using to write data back to the SP (I would assume Patch?) How is yor flow triggered (from the Power App or from an event)?

Hi, 

 

I am not using a patch. I have added a Form in Power Apps and set default to 'New'. This is triggered by a button that 'OnSumbit' calls the Flow below. I thought I could capture the data in 'Compose' and then use the SharePoint Link to item. I have also tried hard coding List Item URL and then ID, but neither works. Do you think I would need a patch? or can you advise if there is a better way? any links to videos\help would be much appreciated. 

 

Flow.jpg

 

 

Hi @KJC ,

 

If I was building this, I would change the flow to not be called by the app, but to have a trigger "When an item is created". From there, you can always capture the current record's ID and pass it in the approval step.

 

In the app itself, keep only the submit form.

 

Please let me know if this helps or you need further help.

Hi,

 

Thank you for your advise. I had a test and that certainly seems better, and I more comfortable using that trigger. There are so many ways of achieving a specific outcome, it good to get someone else view, Thank you.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,132)