Forum Discussion
How to get Calculated Column Microsoft List appear in Power AutomateSharepoint Dynamic Content
Hi, I need advise on current issue I'm having. I have an Inventory List in Sharepoint. 1 of the column is calculated column. When the quantity in this column is less than 10, I would like to set rules - send email reminder to top up. However, I couldnt find Dynamic Content in the Power Automate flow. Can anyone help?
If your calculated column isn’t showing up in the dynamic content list, try this:
- In your flow, use the "When an item is created" trigger.
- Click on “See more” next to the trigger in the dynamic content panel.
- You should now see the calculated column listed.
- Assign its value to a variable early in the flow. This makes it easier to reference later (e.g., in conditions or emails).
I have tested it in the new designer view.
-------------------------------------------------------------------------------------------
Give this a try, and if it works for you, please consider marking this reply as the accepted solution.
4 Replies
Add a compose action. Your calculated column will be able to be selected and will put it into an apply to each. You will then be able to use the outputs in later actions
I still do not find my calculated column (column name Quantity in stock).
Hi mhasfia ,
You are trying to find the dynamic column while setting column Id.
Please initialize and set a variable with the value, then use the variable in any subsequent action.
If your calculated column isn’t showing up in the dynamic content list, try this:
- In your flow, use the "When an item is created" trigger.
- Click on “See more” next to the trigger in the dynamic content panel.
- You should now see the calculated column listed.
- Assign its value to a variable early in the flow. This makes it easier to reference later (e.g., in conditions or emails).
I have tested it in the new designer view.
-------------------------------------------------------------------------------------------
Give this a try, and if it works for you, please consider marking this reply as the accepted solution.
