FLow to look at CEILING Calc and create sharepoint if the number approaches

[shaneOZ]

Hi Guys,

This ones doing my head in and id love some help, this company has asked me to build them a maintenance system (kinda like a fleet management system) and to be alerted when an item is created in sharepoint (I can do that),

What i cant do is figure out how to make a flow that looks at a calculated column (Its a  CEILING calculation, that looks at another column where km/s are put into via powerapps) in one SharePoint List (A Register of all machinery) and creates a list item in another list called Work Orders, i.e Its due for service.

So to sum that up, my question is.

How do i make a flow that creates a list item when a calculated column using the CEILING functions number comes close to the changing 

i.e if the number is 19950 and the function is =(CEILING[Column], "10000") or whatever a new list is created because its 50 below that number

Can anyone help,

This is crucial to finishing this job off,

[RezaDorrani]

Hi @shaneOZ 

Calculated columns in SharePoint are calulcated at run time and only available in the context of the SP list/library

Flow or any other service will not be able to read that value

You would have to create a Flow that runs on a schedule, reads all items from your base list, then filters the items based on the calculation logic (calculation logic will have to be done within the Flow) and then if the criteria matches then create items in the new SP list

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[shaneOZ]

---

@RezaDorrani wrote:

Hi @shaneOZ 

Calculated columns in SharePoint are calulcated at run time and only available in the context of the SP list/library

Flow or any other service will not be able to read that value

You would have to create a Flow that runs on a schedule, reads all items from your base list, then filters the items based on the calculation logic (calculation logic will have to be done within the Flow) and then if the criteria matches then create items in the new SP list

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

---

Firstly thankyou for your reply.

My flow is a little green still, could you show me what i would need to do to successfully achieve my problem then?

Can i make flow do a Ceiling Calculation on a number column? 

[Engineershane]

(On my mobile)

Ok,

After playing around with a troublesome flow doing this job and a great explanation and a outline flow from one of the people here, i have a bit more of a clue now.


So this is my thinking on the matter. I make a if created or modified trigger and have a odata with a ceiling command in there and then add a condition with create or update if not an empty / ID match.

Its the Odata, queries and compose type issues that are currently troubling me after a year of using the system for employment. I wish there was a humongous list of examples of all the options of every function. Kinda like the wiki (which is slowly starting to make more sense) but for an out of the box experience it needs many more, various example projects with brief reasons to their problem and to why they did it this way.

What would i do? Would it be use a expression formula with a number column? Could you give me a similar expression?

And fwiw, this is 3rd hand from reading thread after thread in the last few days panicking over an issue that was crucial (This CEILING issue is for a personal project) anyway as you said you cannot use calculated columns, however ive read her by a few other saying this isnt strictly true, two examples i was reading was about using a convert with compose and string arrays? Is this just bs?