Flow to Capture Image from Powerapps and update to SharePoint List

[Julien2]

Hello everyone!

I am trying to build flow for PowerApps application. So I have created a page in PowerApps for users to create a report, and 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…

My SharePoint list contain the following columns:

• ReportID, type information in this column: Lookup, require that this column contains information.
• Category, type information in this column: Choice.
• Cost, type information in this column: Number, require that this column contains information.
• Date, type information in this column: Date and time, require that this column contains information.
• Description, type information in this column: Multiple Lines Text, require that this column contains information.
• Bills Photo, type information in this column: Picture.

 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

Is it possible to do this flow ? Please can you provide example of this flow ?

I would really appreciate your help.

Thank you!

[yashag2255]

Hey @Julien2 

The Photo/ Hyperlink column in the SharePoint list expects a URL that is less than 255 characters. The images clicked in powerapps will have binary content (basically those are blobs). So you will have to first save those pictures in the Document library and then fetch the image URL's from there. 

Another way is to save these images as attachments to the list items and use the URL to the attachment in the SP column. Note that you cannot populate a Picture type column in Flow so you will have to create the column as Hyperlink and do JSON formatting to view it as an image. 

The best way I can suggest is to create these images as attachments. Here is my blog that can help you pass multiple images from PowerApps to SP via Flow. 

https://www.appliedis.com/newly-released-json-function-for-powerapps/

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Julien2]

Hi @yashag2255 

Yes,I have created a flow that will save images in the library, and i add a button in PowerApps after saving the picture, the flow will generate a link for the image in the site.

In my page the user will enter the file name of the image and select a value from the category according the bill information.

But 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 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 ?

Thank you!

[yashag2255]

Hey @Julien2 

There are two ways I can think of for this: 

1. The flow that you are using to create the image files, need to have an action to get the item (you pass the item ID from PowerApps as a variable) and after getting the item, use update item and in that action you can simply use the link to the file created from the dynamic selector and update it. 

2. You can add another flow as When a file is created and then get its metadata and in the metadata you need to store the ID of the list item that this needs to be attached to and again use the URL to and the ID to update the item accordingly. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Julien2]

Hi @yashag2255 , thanks for replying.

I am trying firstly to build your flow idea about your second step.

So as i understand in this step after getting the file id added to the library, the flow will update Image URL column to the file added in this library.

The flow fails and said that "The file /1 does not exist":

When i added an image directly the flow fails, any idea why ?

I will build the flow of your first step, but i want to understand first how can i update the URL of the image automatically to a column in a list.

Thank you!

[Julien2]

@yashag2255 

Any suggestion ?

[Julien2]

Any help on how to build the flow to pass images url of the uploaded images in library based on repord id ?

[ganeshsanap · Accepted solution]

@Julien2 

You can now Create an Image Column in SharePoint/Microsoft Lists and Add an image to SharePoint Image columns using Power Automate instead of using Hyperlink/Picture column.

---

Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍