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 @Anonymous
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 @Anonymous
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?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
22 | |
21 | |
9 | |
8 | |
7 |
User | Count |
---|---|
33 | |
31 | |
24 | |
21 | |
11 |