Submitted on03-26-201812:05 AMSubmitted byrlazaroon03-26-201812:05 AM
It would be great if there is a possibility to add the "Refresh Data Table" action for "Excel Online (Business)" component. This should be the same result as clicking on "Data -> Refresh All Connections" in Excel Online.
... View more
Submitted on06-20-201812:50 AMSubmitted byefialtteson06-20-201812:50 AM
Hi all! I have been analyzing different options to perform a fuzzy search. This feature is very useful when trying to consolidate entries with typos or simply different formatting preferences, so “Mr. Andrew Hill”, “Hill, Andrew R.” and “Andy Hill” all refer to the same underlying entity. It seems that depending on the data source, the options for fuzzy search differ. For example: -Excel already has an add-on for such purpose (see here and here for more info) -Azure SQL server also has its own approach (see here for more info) -Named Entity Recognition module in Azure Machine Learning Studio is limited to people (PER), locations (LOC), and organizations (ORG) (see here for more information) -Sharepoint Lists does not seem to have this feature available S o I was thinking a good feature for Microsoft Flow would be to offer a Fuzzy comparison action block in a similar way to the Excel add-in by taking data sources (or two arrays) as input. You can also select: -the column pairs you want to compare (could be more than one) -which columns from each source will be part of the output -the similarity threshold -the max number of matches By having this feature as a Flow action block we could extend such feature to any data source.
... View more