Is what I am trying to do in Sharepoint even feasibile to do with flows?

[quandahood]

Hello-  I am new to Sharepoint 365 but have used Sharepoint in the past.  Getting used to Flows and I have a few items that I want to flow but have spent the last few days trying, searching for solutions when honestly, not even sure the things I want to do are feasible.  Could some one more knowledgable than me give me an idea if the things I want to do are possible?  At least that will tell me if I should even continue working on them.

1.  When a document is added to a document libary, have an new item created in an existing list with the name of the document?

2.  When an item in a list has a filed that can toggle yes/no - and is toggled to yes, it can create a copy of a set of folders to a specific location based on other fields in the list.  For example if the item is in group A - the folders need to be copied into document library A, if the item is in group B - the folders need to be copied into document library B, etc.

2a.  I need the copied set of folders created to have the same title name as in the list.

3.  Is it possible to take a field from an excel spreadsheet that is submitted to a document libary and update a list field with that information where the title and folder name are the same?

Any insight is appreciated.

[edgonzales]

@quandahood 

Hi there!  Welcome...Let's get started:

1. Yes, use the Sharepoint connector and look for the trigger, "When a file is created in a folder".  The action will probably be something like "Add an item to a list" or something.  Check the documentation on the link.
2. This one is a bit tricky (I think) - You can use the trigger "When an item is created or modified", but you'll probably want to also use a parameter to limit the columns (if that's possible).  It probably also wouldn't be a bad idea to add a column to indicate if the files have already been copied, to keep the files from re-copying every time the field is modified.  There are actions to copy files and folders, I don't know if it can have the same name, but I'm sure that's covered.
3. I think this one depends on things like, "Will it always be the same spreadsheet?", "Same fields?"...and so on.  Give us a little more detail, but the short version is 'probably'. 😉

The theme, though, is "Yes, absolutely keep working on them."  That's how we learn, right?  "Try. Fail. Learn. Repeat."

We can get more detailed if you want...but poke around first.  My bet is that you'll sort it out pretty quick.

Keep us posted.

[v-zhos-msft · Accepted solution]

Hi @quandahood ,

1. For your first scenario:

2. For your second scenario:

I setted a Yes/no column named 'Test' in the list, the 'Title' column is the based column.

However you can only copy one folder each time.

You also can't rename the folder name.

3. For your last scenario:

You can use the 'Get a row' action to get the data from a specific row in excel table.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.