Hi @Meshare ,
Glad that helped!
In order to interact with the data in the workbook, you'll need to use the appropriate actions from the Excel Online (Business) connector. For example you can use the "Get a row" action to read out the cells of a row out of a table then you can do calculation based on those cells in the succeeding actions.
Below is a simple example that reads one row from a table of my workbook and adds up the numbers from two of the cells.
Here is the sample table:
| Name | Value1 | Value2 |
| Apple | 1 | 4 |
| Banana | 2 | 5 |
| Cherry | 3 | 6 |
Here is the sample flow that reads a table row from a newly created workbook and adds up the numbers from two cells, then sends the result (in my case, "Result = 5") through the mobile notification.
The expression used to calculate the result (in the mobile notification action) is:
add(int(outputs('Get_a_row')?['body/Value1']), int(outputs('Get_a_row')?['body/Value2']))
I would suggest you read a bit more on how to use the Excel Online (Business) connector in Power Automate. There're a bunch of good articles out there on the internet. For example:
* https://piyushksingh.com/2020/07/06/power-automate-read-excel-file/
* https://medium.com/@anoopt/different-ways-of-getting-excel-data-using-power-automate-e21292b1d02a
You can also search up in this forum to see many great suggestions/tips contributed by the community.
Hope this helps!
Yutao
