Hi everyone.. First time on here and I'm not sure if anyone will respond. But I figured I'd try.
I have a 365 account through my University and we use SharePoint as a daily go to for file sharing, references, etc. I have a task to keep track of the number of items that I have in an inventory. I have created a List to track the transactions from this stock and posted it on my SP site. However, I would like to have Power Automate keep tabs on the number of items I have left tin stock. Theoretically to automate a flow at some point that when my stock gets below a certain level, it will tickle someone to order more.
I also have additionally a need to track the number of items that are being given away, to whom they are being given and by whom they are being given. I would like it so that each time someone either takes or replaces items from a stock, it keeps track of who, how many, etc on the SharePoint site.
I have a MS Lists set up to incorporate my data points. It allows me to enter the
I have created a Power Automate flow to take in the number of items removed from the pile, but it seems like my calculations never seem to work. Currently for Withdraw, I have it as
"item/TransactionType/Value": "Withdraw",
"item/RunningTotal": "@sub(coalesce(triggerOutputs()?['body/RunningTotal'], 0)),int(triggerOutputs()?['body/triggerBody()?['#_of_Doses']'])"
It gives me the following error..
The input parameter(s) of operation 'Condition' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Condition'.
I will be the first to admit that I used ChatGPT to help me with the coding as I not a coder by any stretch of the immagination. But this seems to be something easily correced? I just dont see it.. Any help I could get would be greatly appreciated.
Chip