Forum Discussion
Collis2135
Mar 29, 2021Copper Contributor
Updating a master excel doc on sharepoint from emailed sheets
Hi All, I have a master spreadsheet with columns A-V all manually populated. However there are issues with populating the data to go into columns W,X,Y currently, therefore I want to automat...
RobElliott
Mar 29, 2021Silver Contributor
Collis2135 Rather than an email template you might be better using a form in Microsoft Forms for the users to submit their data. The flow can pick up the submitted details easily.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Collis2135Mar 29, 2021Copper ContributorThanks Rob, I did wonder about forms initially, but had concerns about the accuracy of data entry and the ability to create a unique identifier.... not necessarily an issue, but I would need to brush up on my forms knowledge too!