Save Images Captured from Powerapps to SharePoint List

(0) Share

Report

Posted on by EBMRay

1,712

Hello everyone!

I am trying to customize Expense Report template using flow and PowerApps.

So I have created a page in PowerApps for users to create a report, take some pictures from their phones, and when they clicks on the save button the flow will start, update the picture to SharePoint list column called “Bills Photo” and trigger the report id that they wants to add the photos on.

Suppose that also the users want to take more than one photo to a report, how can i group the photos to show them in the column close to each others for example: Photo1,Photo2,Photo3…

I followed this amaizing tutorial on Youtube video but this flow in this video don't achieve my needs:

PowerApps Flow Intro Upload an image to SharePoint using Flow

On save i want the flow to save the images URL's based on ReportID of the user.

So when the manager want to check for the bills photo's in SharePoint it will redirect him to the URL of the image that the user add it to the report.

Here is the list:

Here is the flow:

Here is the App:

So what is the actions i have to add in the flow to achieve it ? Please can you provide example of this flow ?

I would really appreciate your help.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

CU24091509-0 417 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

If you want to upload multiple images, it is always better to do them as attachments.

Please let me know if that helps.

Thanks

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Julien2 ,

You can add the ID of the item to end of the Filename, which is the textinput control in PowerApps. For example, use a formula that runs the flow like below:

FlowName.Run(Concatenate(TextInput1.Text,Gallery1.Selected.ID),...,...)

Gallery1.Selected.ID is just an example to get the ID value of the item.

Regards,

Mona

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-monli-msft ,

I have 2 different pages but each of this pages contain 2 Save buttons, i wanna merge both functions in only one function and one save button. The functions are below:
(Save & Add new line item Button) function:
SubmitForm(NewLineItemForm);SubmitForm(NewLineItemExpenseStatusForm);ResetForm(NewLineItemForm);Set(SelectedReport,LookUp(Expenses,ID=SelectedReport.ID))
(Save to SharePoint Library Button) function:
Set(FileLinkFromFlow, Powerapps.Run(TextInput2.Text & ".jpg", Dropdown1.Selected.Value, TakenPic).filelink)
So on save the flow will start and add the image to the library, at the same time a new item will be added to the LineItem list by checking the id of the report in the other list.
What will be the function for the Save button ?
Thanks in advance!

Was this reply helpful? Yes No
mmhailye 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Even though you are storing your images on SharePoint, you may get some ideas on how to adapt the methods used in this excellent video which shows how to save multiple images to Azure Blob storage. The main concept here is to use an "intermediate table" that links the Expense report in this example to multiple images. This avoids using Flow to simplify things.

https://www.youtube.com/watch?v=ZOz3HvKDWMk&t=166s

Hope this gives you another approach...

Was this reply helpful? Yes No