You’re offline. This is a read only version of the page.
Announcements
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?
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:
Share
Report
All responses (
Answers (
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,
