Hi, This is a great video, but... I can't get it working. I can't see the complete syntax you're using. I'm using the online version. Has it changed between then and now?
Also, if anyone is considering this. In case you have versioning, prepare yourself, since it will consume your space very quickly. Would love to find solution how to create that sum, but so far I did not.
And found solution. If you want to prevent loop, add condition, which checks who was last to modify that item. If it was system account (definetely need one used in flow), than terminate, if not, proceed.
What about if I am trying to create a workflow that calculates the number of seats from the available number of 50 possible? - if the calculated columns worked better I could just type in something like: (at every new item added) [seats] -1, [updated seats] =IF([updated seats]
Is there a flow that sums the date and time calculated column? I have column A (date and time time) and Column B (also date and time column) and i use the =TEXT([Time In]-[Time Out],"h:mm") to create the total hours calculated column. Now i want to sum the total for all the values in the calculated column, is there a flow for this?
I currently don't have a video demonstration that shows how to do that specific Flow, but I am sure it is possible to do. An excellent idea for another video, thank you!
What Flow subscription do you have? Just wondered because the totals were updated almost instantly. We have a free (2000 flows per month per user) and I think I have to wait up to 5 minutes for all our Flows to kick in.
Can you help me with a flow that creates list from and excel file that is on the same sharepoint site, copying metadata in the first time and then updating if the file is updated?
Hi,
This is a great video, but...
I can't get it working. I can't see the complete syntax you're using. I'm using the online version. Has it changed between then and now?
This flow creates infinite loop. So you cant create another flow on same list, which is using most common trigger "when item is created or modified".
Also, if anyone is considering this. In case you have versioning, prepare yourself, since it will consume your space very quickly. Would love to find solution how to create that sum, but so far I did not.
And found solution. If you want to prevent loop, add condition, which checks who was last to modify that item. If it was system account (definetely need one used in flow), than terminate, if not, proceed.
What about if I am trying to create a workflow that calculates the number of seats from the available number of 50 possible? - if the calculated columns worked better I could just type in something like: (at every new item added) [seats] -1, [updated seats] =IF([updated seats]
Is there a way to create flow to fill a calculated column based on the person created the list item?
In my experience calculated columns are to be avoided and this Flow is one way to do that.
How to sum more than 2 columns, using Flow?
You would have to use variables and do it in several steps.
@ Could you point us to some resources on that please? I need to sum 5 columns. I read somewhere you could use nested add() expression?
@@aljazdvorsak9762
Sorry, don't have any such videos but I appreciate the idea and the feedback.
Is there a flow that sums the date and time calculated column? I have column A (date and time time) and Column B (also date and time column) and i use the =TEXT([Time In]-[Time Out],"h:mm") to create the total hours calculated column. Now i want to sum the total for all the values in the calculated column, is there a flow for this?
I currently don't have a video demonstration that shows how to do that specific Flow, but I am sure it is possible to do. An excellent idea for another video, thank you!
Loved it
Sumifs can work on it?
Yes, you can certainly build a more complex flow that uses a conditional statement. Much more readable than a sumif function in my opinion.
What Flow subscription do you have? Just wondered because the totals were updated almost instantly. We have a free (2000 flows per month per user) and I think I have to wait up to 5 minutes for all our Flows to kick in.
I demonstrate with an E3 account. Those limits and delay tend to change a lot, though.
You Sir are GREATLY APPRECIATED! THANK YOU!!!
I take a bow :-)
Is there a way to perform flows such as you performed here for SharePoint installations that are all on prem?
Can you help me with a flow that creates list from and excel file that is on the same sharepoint site, copying metadata in the first time and then updating if the file is updated?