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,
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.
@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?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
14 | |
14 | |
10 | |
7 | |
6 |
User | Count |
---|---|
20 | |
16 | |
10 | |
9 | |
8 |