I've been working on something to go online with my maintenance forms, Right now I'm using paper, but that feels a bit outdated, and I usually just scan in those documents and mail them anyway. But I'd like to automate that.
This should go as follows:
1. My Sharepoint list gets updated with a new row / a row gets updated ( I have made an app for this, picture posted below)
2A. A Mail with information from said list gets emailed (Preferably attached as a file, named after todays date and Customer, I do have columns for that)
2B This information updates a premade excel file, where only single cells get updated (not through a table, ruins the layout of the file)
3B The Excel file then gets attached to an email, that gets send to a customer mail, that is filled in the form.
I'm not sure where to start? I think that the best way to get rid of duplicates and such, is to bind the "accept" button on the "new form page" to a flow of some sort.
Any suggestions are greatly appreciated.
Edit viewCreating a new row in the sharepoint tableExcel file (In Swedish but you get the idea of the layout)