Referencing calculated fields in Power Automate flows

User Support
1

Hello,

I am building notification flows using power automate. As part of my flow, I have a calculated field that extracts an email from a reference field. I am trying to see if I can directly reference the calculated field in the flow, so that emails are sent dynamically depending on how the reference field was filled.

I realized however that I cannot use calculated fields in power automate, similar to how we use other fields.

It would be nice to have a discussion around this mainly to find a solution or to understand how the whole process works.

Best,

Ahmed

2

I have tried creating a text field and using a formula to set up it’s default value. The goal was to reference this text field in the power automate flow instead of the previous calculated field. I am finding however that I the default value formula is not filling the text field and it leaves it empty.

3

Hi Ahmed,

The default value only applies when adding a new record. If you add a new default value formula, it doesn’t overwrite (or write) the value for existing records.

At this time, the webhook does not send calculated fields. This is a known limitation that we are working to improve. In the meantime, it means that if you want the calculated value, you wll have to add an additional PowerAutomate step to query the record.

You can POST to the queryRows endpoint to query the results that include the calculated field. For example, your body might look like this:

{
  "rowSources": [
    {
      "rootFormId": "<form id>"
    }
  ],
  "filter": "_id == '<record id>'"
}

Sorry this is complicated, we’re working on improving the automations that so that you can choose exactly which fields (or all fields) to send as part of your webhook.