PUSH IMAGE FILE FROM POWERAPPS TO EXCEL

Like (0) Share

Report

Posted on 22 Nov 2019 07:44:59 by Vignesh_2112

101

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?

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

v-yutliu-msft on 25 Nov 2019 at 02:14:35

Like (1)

Report
Re: PUSH IMAGE FILE FROM POWERAPPS TO EXCEL

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,