PUSH IMAGE FILE FROM POWERAPPS TO EXCEL

[Vignesh_2112]

Outline : I have created an application that fetches data from multiple excel files as a source file and save data in a prescribed tabular form in a destination excel file.

Issue: I need to prompt the user for capturing images and to be stored in the excel cells. Will that be possible?

[v-yutliu-msft · Accepted solution]

Hi @Vignesh_2112 ,

Do you want to save images to Excel and notify user this action?

Yes, it is possible.

1)notify user

Please try Notify function.

set one button's OnSelect:

Notify( "Please save caputred images to Excel!", NotificationType.Warning )

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-showerror

2)save caputred images to Excel

Firstly, you need to insert a column named fieldname[image].  //for example, image1[image] or picture[image],....

Secondly, you could use "Camera1.Photo" to represent the photo caputred by the camera control.

Try this formula to update:

Patch(table,DeFaults(table),{fieldname[image]:Camera1.Photo,....})

Here's a doc about how to update images to excel and camera control for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/tutorial-working-with-images-in-excel

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-camera

Best regards,