Japanese version. Steps Power Automate alone is too much work, so we will utilize an Excel sheet. Create a table with the items “Value” and “Rank” on the sheet for calculation. No data rows are required. Place this Excel file in a location that can be accessed by Power Automate, such as OneDrive. Prepare array variables. Repeat the items of the array variable with “Apply to each”. The rank is calculated using the RANK.EQ function. Set up “Add a row into a table” in “Apply to each” and specify the following Parameter Value LocationDocument LibraryFileTable The location of the target Excel file and the table name. Value Current item Rank … Continue reading How to rank arrays of numbers.(Power Automate Cloud flows)