Help with Using Flow to attach file or link image to Sharepoint List Item from Powerapps

(0) Share

Report

Posted on by SamR

Hello,

Unsure if this is more of a Powerapps question or flow question, so figured I'd start here.

I have a Powerapp that is linked to a sharepoint list. The powerapp has the following screens:
1. Gallery View, shows most recent sharepoint list items

2. Edit View, shows blank form with ability to edit and "submit form" to create new list item shown in gallery

3. Display View, shows non-editable form fields.

On the display screen, I have inserted a custom card into the "view" form with a peninput and button. On select of the button I am successfully able to save the signature to a Sharepoint document library via flow. The problem I am having is I then I want to automatically attached the created file to the list item I am viewing within the display form when I click the button.

I am struggling to implement this into my flow after the signature file is created. I think the issue is I do not know how to direct flow/Powerapps to select the item I have in the view screen when I click the button to attach to. I need to be able to direct flow to select the already existing item in the sharepoint list to add a signature to, rather than just creating a fresh new item. Is there a flow/powerapps function that would let me do this?

(also generally unsure if it's best to add the signature as an attachment, or find a way to link to the signature in the document library).

Categories:

General Questions

All responses (4)

Answers (1)

SamR 30 on at

Like (0)

Report

Re: Help with Using Flow to attach file or link image to Sharepoint List Item from Powerapps

This is great! I was able to implement into my SharePoint list with this technique. I do have one follow up question.

In the event I want to attach more than one signature, is there a way I can do this? For example a "Signer 1" and Signer 2"? Following your model I would add another peninput and collection - but I cannot add a duplicate datacard for the attachment column in order to set it's item to testcollection2. Any ideas?
Verified answer

v-xiaochen-msft on at

Like (0)

Report
Re: Help with Using Flow to attach file or link image to Sharepoint List Item from Powerapps

Hi @SamR ,

I will introduce a way to save the signature to the attachment column.
Please see the steps below:
1\ This is my test list ‘LIST92’.

2\ Add an edit form control ‘Form1’ and set its DataSource property to:
LIST92

3\ Add 2 fields ‘Title’ and ‘Attachments’ like picture:

3\ Set the Visible property of attachments card’s datacardvalue ‘DataCardValue2’ to:
False

4\ Insert a penInput control ‘PenInput1’ into Attachments_DataCard.

5\ Add an Icon and set its onselect property to:
NewForm(Form1)

6\ Add a submit Icon and set its onselect property to:
ClearCollect(TestCollection,{DisplayName:Now()&".png",Value: PenInput1.Image,Id:""});SubmitForm(Form1)

7\ Set Items property of attachments card’s datacardvalue ‘DataCardValue2’ to
TestCollection

Set other properties of attachments card’s datacardvalue ‘DataCardValue2’ like picture:

8\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
SamR 30 on at

Like (0)

Report

Re: Help with Using Flow to attach file or link image to Sharepoint List Item from Powerapps

Hi @v-xiaochen-msft, thanks for repsonding!

When I press the "submit" button on my edit form screen it creates a new record in my sharepoint list without any signature. Just normal saving of form datacards to linked sharepoint list.

What I would like, it for the user to be able to then open and review the created list item on the "display" screen, where they can sign off if everything looks good.

I would then like to attach the signature (saved as an image file using the JSON function) to the list item being reviewed on the screen. Happy to do as an attachment to the list OR as a hyperlink/picture column. Whichever is easier.

Thanks for any help in advance! Let me know if it would help for me to provide screenshots.
v-xiaochen-msft on at

Like (0)

Report

Re: Help with Using Flow to attach file or link image to Sharepoint List Item from Powerapps

Hi @SamR ,

Could you tell me:
When you press the button, did you create a record? Do you want to save the signature to this list record?
In which column do you want to save the signature?(Is it a 'hyperlink or Picture' column? or a attachment column? )

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.