Im trying to create an If Statement so that if the choice field is a Sell, I Sum the amount and if its a Buy I add Subtract the amount by multiplying it by -1.
My error is saying incompatible types for comparison. But it will not work if I set it to .Value either posted below
I imagine that "UpcomingSettlementsFundsGroupingFunds" is a colletion (or SP list or whatever)?
if so, you have to browse the source in a loop before doing your condition.
ForAll( UpcomingSettlementsFundsGroupingFunds; If( Choices(ThisRecord.'Transaction Type').value = "sell" .....
Edit: Replace the ";" by ","
Hi @daruom ,
It wouldnt allow
Choices(ThisRecord.'Transaction Type').value = "sell"
So I used the below but - I'm getting an error stating "cannot compare a table with text" on the If Statement
Try that :
ForAll( UpcomingSettlementsFundsGroupingFunds; If( ThisRecord.'Transaction Type'.value = "sell" .....
Or UpcomingSettlementsFundsGroupingFunds.settlementDump, I'm not sure about your data source.
Also when you do "file> collection" you can see the complex data and field structure, if you have screenshots?
And also put your code in quotes, it will be more readable and practical.
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!