I would like to know whether I can build a Flow that will trigger when an item is added to a list (Production list),
Get the items from a second list (Load Numbers list), compare the content of the trigger ('Production list') Equipment
Number column to the Equipment Number column of the Get Items (Load Numbers list), and delete that number
from the Get Items (Load Number list)?
Also, update the Get Items (Load Number list) Equipment Number column by adding one new number to the list.
Example:
User activates a dropdown, populated by the Load Numbers list Equipment Numbers column, and chooses the next
available number.
The user submits the data to the Production list, which triggers the flow.
The flow Get Items retrieves the content of the Load Numbers list Equipment Number column and compares those numbers
to the new item in the Production list, specifically comparing both 'Equipment Numbers'.
If the new item in the Production list has an Equipment Number that is also in the Load Numbers list delete that Equipment
Number from the Load Numbers list.
Then, look for the last Equipment Number in the Load Numbers list and add a new Equipment Number that is one higher than
the last number - (I.e. - If the last number in the Load Number list is 2345, flow will add to the Load Number list the number 2346).
Share
Report
4,884
All responses (
Answers (
