I retrieved a couple of records from a Dynamics environment and put them into a html table.
The html table has a couple of columns and I want to add up the values of a column in order to get the total value.
I am only interested in the total of a single column denominated 'CreditAmount' that only includes numeric values.
How can I achieve that?
Note: I do not really bother whether a html table or something else is used. The important issue for me is getting the total amount of the records retrieved in order to use this total in a subsequent step.
Could you please share a bit more about the html table that you mentioned?
Do you want to extract data from a html table within Microsoft Flow?
If you want to extract data from a html table within Microsoft Flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently. There is no way to analyze a html table within Microsoft Flow, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
If you only want to get the total amount of the records retrieved, I think the length() function could achieve your needs. I have made a test on my side and please take a try with the following workaround:
Within Compose action, the length expression read as below:
The flow works successfully as below:
The records existed within my SharePoint list as below:
More details about the length function, please check the following article: