02-10-2019 16:14 PM
This solution uses Microsoft Flow in its entirety to take a picture with or add a picture from your mobile device, then store it in your personal OneDrive. In addition, the picture information is added to Microsoft Excel using the new Add Table Row (Preview) action.
By simply using a Microsoft Flow button trigger, we can add a file input and capture a Reason for the picture. We can then use a OneDrive Create File action to transfer the content of the file, whether taken directly from your mobile device camara or uploaded from the camera storage to OneDrive. For convenience, each file is simply named with the date and timestamp in portable network graphics (PNG) format.
Prior to this, I prepared an Excel worksheet and added a table to store the picture information. The Excel file can be downloaded below. In the same workflow, we can add the 'Add a row into a table' preview action for Excel OneDrive.