Power Platform Community Forum Thread Details

Dear Power Platform Champs,

I have a editform form1 connected to SharePoint list. It is a audit form which requires pictures to be taken at customer location and attach them to the form. The pictures have got metadata to link, so am not using list attachments. I am capturing pictures using picture control and saving them to SharePoint document library along with certain metadata like list FormID, State etc. I am using a collection and flow to save the pictures and metadata to SharePoint library. Here is my collection

Collect(
 colAuditPictures,
 {
 Title: AddMediaButton1.FileName,
 DataStream: UploadedImage1.Image
 }
)

At OnSuccess property of the form I am running the flow with below formula to save pictures and metadata back to SharePoint library. The flow is working fine and saving the pictures and metadata.

If(
 CountRows(colAuditPictures) > 0,
 SavePicturestoLibrary.Run(
 JSON(
 colAuditPictures,
 JSONFormat.IncludeBinaryData
 ),
 drpState.Selected.Value,
 Form1.LastSubmit.ID
 )
);

The problem is during the retrieval of the pictures from my gallery connected to already submitted forms. I am using below formula to populate the same collection but the image is in a column called {Thumbnail} which is a table and having a conflict with collection schema that I created earlier.

Collect(
 colAuditPictures,
 RenameColumns(
 ShowColumns(
 Filter(
 'Safety Audit Without Manifold Pictures',
 'Form ID' = varSelectedRecord.ID
 ),
 "{FilenameWithExtension}",
 "{Thumbnail}"
 ),
 "{FilenameWithExtension}",
 "Title",
 "{Thumbnail}",
 "ImgFromLib"
 )
 )

Now my collection got another column "ImgFromLib" as I cannot use rename column {Thumbnail} to "DataStream" because they are of different types. And my flow is depending on my collection schema I would like to use one column for my image in my collection while attaching picture during New Form submission and Edit Form Submission. How can I do that?

Categories:

Building Power Apps

Hi @RameshMukka ,

Please use 'Link to item' column of the library instead of 'Thumbnail' column in the collection:

Collect(
 colAuditPictures,
 RenameColumns(
 ShowColumns(
 Filter(
 'Safety Audit Without Manifold Pictures',
 'Form ID' = varSelectedRecord.ID
 ),
 "{FilenameWithExtension}",
 "{Link}"
 ),
 "{FilenameWithExtension}",
 "Title",
 "{Link}",
 "DataStream"
 )
 )

Link to item column is the URL for a file that stored in the library, you may use the link for other places although the link is steal with a different type from the stream.

If you want to retrieve the binary data of the image, you need to use a flow: