cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeNJ00
Level: Powered On

SharePoint Flow Issue

In my library, I created a column that I want to pull information from the "Name" column.  Reason being is that I want to use it for a calculated column and the Name column can't be used there.

 

So I created a flow "When file is created or modified" and then "Update file properties"

 

I have it working, but the issue is that it keeps running whether any item is modified or not.  And when it does run, it doesn't just run on the one item, but on the whole library and will create a new version for every document even though a change was only made to the one item.  Now every few minutes it's running again and creating a new version of all the files even when I haven't made any changes in 2 hours.  Not sure if I picked the wrong trigger, or there is another easier way to do this?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: SharePoint Flow Issue

@MikeNJ00 

My error - the condition should say "not equal to" rather than "equal to".

The idea is that if you have already populated the Name2 column, the Flow will end.  If it is empty, your Flow will continue and populate the Name2 column.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

8 REPLIES 8
Super User
Super User

Re: SharePoint Flow Issue

@MikeNJ00 

Please post a screen shot of your Flow with as much detail as possible.  That will make it much easier to assist.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
MikeNJ00
Level: Powered On

Re: SharePoint Flow Issue


@ScottShearer wrote:

@MikeNJ00 

Please post a screen shot of your Flow with as much detail as possible.  That will make it much easier to assist.

 


Hi Scott. Thanks , here is a screen shot

Super User
Super User

Re: SharePoint Flow Issue

@MikeNJ00 

Sorry, but I am unable to see your screen shot - please try again.  When creating you post, click on Photos in the tool bar.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
MikeNJ00
Level: Powered On

Re: SharePoint Flow Issue

Flow1.PNG

Super User
Super User

Re: SharePoint Flow Issue

@MikeNJ00 

You have created an infinite loop - every time the file properties change another Flow is triggered which starts another Flow.....

To avoid this issue, add a condition to your Flow immediately after the trigger - see my screen shot below.

Please note the null must be entered in the expression window.  Be sure to click on update after entering null as an expression.

Also, please not that the terminate action status is set to succeeded.

NullName.jpg

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
MikeNJ00
Level: Powered On

Re: SharePoint Flow Issue

Thanks Scott.  I updated as per your post and it shows that it's running succesfully, but now the "Name2" column is no longer copying the data from the Name column.  Does this look correct?Flow2.png

Super User
Super User

Re: SharePoint Flow Issue

@MikeNJ00 

My error - the condition should say "not equal to" rather than "equal to".

The idea is that if you have already populated the Name2 column, the Flow will end.  If it is empty, your Flow will continue and populate the Name2 column.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

MikeNJ00
Level: Powered On

Re: SharePoint Flow Issue

That works.  Thank you

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,232)