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
Solved! Go to Solution.
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
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.
I'm passing both of the highlighted values in the above picture, on OnSuccess of my PowerApps form:
Then I submit my Form:
Now I have my signature, attached to my record in the SharePoint list:
--------------------------------------------------------------------------------
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!
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 glbMyPenInput
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 this
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?
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?
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)
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/
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
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
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
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
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.
I'm passing both of the highlighted values in the above picture, on OnSuccess of my PowerApps form:
Then I submit my Form:
Now I have my signature, attached to my record in the SharePoint list:
--------------------------------------------------------------------------------
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!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
37 |
User | Count |
---|---|
294 | |
248 | |
123 | |
74 | |
55 |