Automatic update of sharepoint list from modified excel generated by forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1643680%22%20slang%3D%22en-US%22%3EAutomatic%20update%20of%20sharepoint%20list%20from%20modified%20excel%20generated%20by%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1643680%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community!%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20an%20automation%20for%20this%20process.%3C%2FP%3E%3COL%3E%3CLI%3EUser%20A%20fills%20in%20a%20Form%20(%22Asset%20Profile%20Form%22)%20created%20via%20MS%20Forms.%3C%2FLI%3E%3CLI%3EResponse%20is%20automatically%20added%20to%20the%20Forms-generated%20excel%20spreadsheet%20(%22Asset%20Profile%20ss%22)%20that%20I've%20saved%20on%20sharepoint.%20The%20info%20entered%20at%20this%20stage%20is%20marked%20in%20the%20Asset%20Profile%20ss%20as%20Part%201%26nbsp%3B%3C%2FLI%3E%3CLI%3EPart%201%20info%20is%20displayed%20on%20Sharepoint%20as%20an%20item%20on%20a%20List%20(%22Data%20Inventory%22).%3C%2FLI%3E%3CLI%3EThe%20List%20is%20viewed%20by%20User%20B%20to%20assess%20Part%201%20info's%20classification%26nbsp%3B%3C%2FLI%3E%3CLI%3EUser%20B%20edits%20the%20Asset%20Profile%20ss%20by%20selecting%20from%20drop%20down%20in%20Part%202%26nbsp%3B%26nbsp%3B%3C%2FLI%3E%3CLI%3EData%20Inventory%20is%20automatically%20updated%20with%20the%20Part%202%20info%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20have%20made%20a%20basic%20Forms%20-%26gt%3B%20Sharepoint%20flow%20to%20cover%201-3.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20incorporate%20an%20Excel%20-%26gt%3B%20Sharepoint%20flow%20for%205%20%26amp%3B%206%2C%20and%20generally%20for%20when%20any%20part%20of%20the%20Asset%20Profile%20ss%20is%20updated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20reading!%20Regards%2C%20suz%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1643680%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello community!

I am trying to create an automation for this process.

  1. User A fills in a Form ("Asset Profile Form") created via MS Forms.
  2. Response is automatically added to the Forms-generated excel spreadsheet ("Asset Profile ss") that I've saved on sharepoint. The info entered at this stage is marked in the Asset Profile ss as Part 1 
  3. Part 1 info is displayed on Sharepoint as an item on a List ("Data Inventory").
  4. The List is viewed by User B to assess Part 1 info's classification 
  5. User B edits the Asset Profile ss by selecting from drop down in Part 2  
  6. Data Inventory is automatically updated with the Part 2 info

I have made a basic Forms -> Sharepoint flow to cover 1-3. 

How do I incorporate an Excel -> Sharepoint flow for 5 & 6, and generally for when any part of the Asset Profile ss is updated?

 

Thanks for reading! Regards, suz

  • I
0 Replies