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

How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

hello everyone am stuck for the past few hours on this  at flow, dont know how to get the ID of one of the sharepoint columns named"attachement" i created PDF file in flow and want to attach that file to sharepoint list item, but stuck with this ID

4 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

Hey @warsongg00 I have a video that shows a different way to accomplish all of this thanks to the new-ish JSON function. Based on the blog you posted I think this should help. Save PowerApps Pen Inpu to PDF, SharePoint, and More

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

Highlighted
Edwin-Abdalian
Level 10

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

If you follow Shane's video, you just need to make a few small changes. Instead of creating a file in a SharePoint Library, you would need to use SharePoint Add Attachment action in your flow.SharePointAttachement3.PNG

I'm passing both of the highlighted values in the above picture, on OnSuccess of my PowerApps form:SharePointAttachement4.PNG

 

Then I submit my Form:

SharePointAttachement6.PNG

 

Now I have my signature, attached to my record in the SharePoint list:

SharePointAttachement5.PNG

--------------------------------------------------------------------------------

Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

View solution in original post

Edwin-Abdalian
Level 10

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

Because you are not using the SubmitForm function, therefore you cannot use the form1.LastSubmit.ID. Basically you have not submitted your form, so there is nothing in LastSubmit.

1- Instead of the Patch function, simply use SumbitForm(Form1). When you have simple forms like this, always use SubmitForm instead of the Patch function.

2- The second mistake is where you are passing the PenInput1 to your flow. you Created the JSON variable, you need to pass that variable as your File Content. In my example, I named my variable as glbMyPenInputSharePointAttachement4.PNG

 

View solution in original post

Edwin-Abdalian
Level 10

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

your Flow is not correct. You create the file within the Add Attachment action. you do not need a separate action of Create File.

it should look like thisSharePointAttachement7.PNG

 

View solution in original post

14 REPLIES 14
Edwin-Abdalian
Level 10

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

You have not explained how you generate the PDF and how you trigger the flow. So I don't know the context of your flow.

1. If you trigger it from a Canvas app then in the flow you can create a variable and set the value to "Ask in PowerApps". Then in Canvas app, and when you submit a form that Edits/Creates a record  in your SharePoint list, you can pass the ID of that record to the flow.

2. If you generate the PDF by an automatic flow, then you must have your sharepoint record in the context of your flow to be able to generate a word, html, PDF file. how do you populate the PDF content?

warsongg00
Level: Powered On

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

i followed this tutorial

https://poszytek.eu/en/microsoft-en/office-365-en/flow-en/powerapps-hand-written-signature/

do i need to add more commands in submit button beside the ones he typed in the website?

Edwin-Abdalian
Level 10

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

Well, if you need the ID of the record in your flow, then you must send the ID to your flow on the Onsuccess of the form

SignDocument.Run(Form1.LastSubmit.ID)

warsongg00
Level: Powered On

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

thanks for the replies last question, what should i put in respond to powerapps?

and add attachemnt doesnt add the file to the list, can you help me with this please

https://poszytek.eu/wp-content/uploads/2018/12/image-6-556x1024.png

https://poszytek.eu/en/microsoft-en/office-365-en/flow-en/powerapps-hand-written-signature/

Super User
Super User

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

Hey @warsongg00 I have a video that shows a different way to accomplish all of this thanks to the new-ish JSON function. Based on the blog you posted I think this should help. Save PowerApps Pen Inpu to PDF, SharePoint, and More

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

warsongg00
Level: Powered On

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

thanks for the video , can you check the article https://poszytek.eu/en/microsoft-en/office-365-en/flow-en/powerapps-hand-written-signature/

and tell us how he did it step by step, i want to know what he did at the end , why add attachement failed for me

warsongg00
Level: Powered On

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

just following ur tutorial but, it didnt teach me how to show the picture in the list, i had column named attachements, but nothing showing in it, i have tried to add in flow add attachement to sharepoint but nothing is showing

warsongg00
Level: Powered On

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

if possible can you teach us how to attach the output into list column itself? so each push can save new customer data with their signature link to the image created or pdf

Highlighted
Edwin-Abdalian
Level 10

Re: How can you know this info (sharepoint id of the list item to attach the file to.)? am trying to use flow sharepoint attachement

If you follow Shane's video, you just need to make a few small changes. Instead of creating a file in a SharePoint Library, you would need to use SharePoint Add Attachment action in your flow.SharePointAttachement3.PNG

I'm passing both of the highlighted values in the above picture, on OnSuccess of my PowerApps form:SharePointAttachement4.PNG

 

Then I submit my Form:

SharePointAttachement6.PNG

 

Now I have my signature, attached to my record in the SharePoint list:

SharePointAttachement5.PNG

--------------------------------------------------------------------------------

Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

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 (8,266)