Hello again,
Hopefully one of the power automate experts on here can help me figure out what is going on....
I have a currency roll-up column in a Dataverse table that I need to save to a variable in an automated flow.
I have a variable initialized with the type Integer, that I am attempting to save this rollup value to so that I can use it later in my flow.
Sometimes this value will be equal to zero (intentionally) so in my flow I check to see if the value is zero before setting my variable for it, since an integer variable cannot be set to an empty or null value.
In my test case, this rollup field has a value of 250,000, which I am confident is accurate since this is coming directly from the raw outputs in my trigger (When a Dataverse row is modified). However, when I go to set my variable to this value inside of the condition control, using the dynamic content to pull the data from my Dataverse row, I am getting an error that this value is null or empty.
Is this a quirk of using a rollup column/value in flow? Any other thoughts of what could be the cause of this would be much appreciated!

Report
All responses (
Answers (