Thanks for the reply, @datalearner !
Regarding your first question, as the flow is currently set up, there will be no errors, because the condition and the filter are doing the exact same thing, so the condition is essentially pointless. That's good, it's an extra action that we can remove. 👍
I'm not sure that I wholly understand your second question, though. However I will try.
If you are already using the ODATA filter to only retrieve rows where the Revenue is 1000000, that will limit what you can do with the data here. For example, if that is already there and you also wish to calculate a value on revenue - cost being over 1000000, that will be logically impossible, I think. Because the initial revenue would need to be greater than 1000000, and the only revenues that you have are exactly 1000000.
Further Suggestions
I would suggest that in order to get better data, and better access to the data, you either:
- More Columns - Add more columns to the table in excel.
- Go SharePoint - Move the whole set of data to a SharePoint list (or Microsoft List).
More Columns
If there is nothing stopping you from editing the original table, then you should add all the data that you might need to work with there.
This will enable you to pass completed information into the flow, and will reduce your flow actions. It will also enable you to visualise the logic more simply in the flow.
If the table itself is sacred, but the workbook can allow additional worksheets, then add another worksheet that has a new table that updating from the original, where you can have all the extra columns that you wish. Then simply run the flow from the new table.
Go SharePoint
Alternatively, if you consider using a list for this data, then you might find that it is a LOT more flexible in terms of how the information is accessed and manipulated, in addition to making adding extra columns of data, and exporting information to other formats (even Excel!) easily. 🙂
