Hello all,
I've a power automate that notify a manager with different fields from a sharepoint table.
One of those fields is the cost center and I need to create a condition that evaluates a yes/no column called OtherCC. If it's yes i wanna retrieve one column called "CCtoDebit" from sharepoint list called Requests, otherwise, I want to retrieve "CostCenter" from sharepoint list called Users.
The lists are conected by lookup column and I'm doing the get items on flow.
I tried this way
if(triggerOutputs()?['body/OtherCC']=true, triggerOutputs()?['body/CCtoDebit'], outputs('Get_item_from_Users')?['body/CostCenter']) but it always says expression invalid. I've also tried 1 instead of true and yes, with and without " or '.
Any idea?
Best regards,
Miguel Teixeira
