Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Troubleshooting a flow

Posted on 25 Nov 2024 22:09:18 by
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 
Date Date and Time  
Staff Choice  
# of Doses Number  
Transaction Type Choice  
Agency Lookup  
County Lookup  
Running Total Number
 
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
  • Suggested answer
    CA1105 Profile Picture
    CA1105 210 on 27 Nov 2024 at 06:16:33
    Troubleshooting a flow
    Please share the screen shot of the flow and from your expression I'm assuming it could be because of coalace function. I would say create variable and store zero in that veriable and see if that fixes your issue. If there is something else then share more details.
  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,035 on 26 Nov 2024 at 23:35:22
    Troubleshooting a flow
    Please upload a screenshot of your flow with error

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard