Add calculated column to Create Csv Operation

Like (0) Share

Report

Posted on 27 Dec 2024 09:41:34 by PL-27120937-0

Dear,

I would like to add a column to sum after get items from sharepoint list, that columns is calculated from other columns.
I try to Expression in Create CSV table, but it not work. How can I do it, please help. Thanks

Categories:

Business Process Flows

All responses (3)

Answers (1)

Mark Nanneman 989 Super User 2025 Season 1 on 28 Dec 2024 at 01:32:39

Like (0)

Report

Add calculated column to Create Csv Operation

No worries, it'd be a lot easier and more straightforward if they just let you do >= or <= like in Power FX or other languages!
Suggested answer

PL-27120937-0 6 on 28 Dec 2024 at 01:18:37

Like (1)

Report

Add calculated column to Create Csv Operation

Thank you Mark.
It works perfect. It's new with me
Verified answer

Mark Nanneman 989 Super User 2025 Season 1 on 27 Dec 2024 at 19:32:26

Like (1)

Report

Add calculated column to Create Csv Operation

The syntax in your expression in the screenshot is not correct for a power automate expression.

You would have to write this like:

if(greater(2,1),2,1)

You can review all the logical operators in the "function" tab of your expression editor.