each exteract of the report can have diffrent amount of impacted applications columns accordiung to the issue wuith the biggest ammount of impacted apps. So, whenever you will type Fees in Name Box, it will immediately position your cursor there suggesting that this is the group which you need to open. Select Columns A and B and in the Name Box (Left to Formula bar), you can give it a name say Fees.

and associated VBA code to automatically resort/rename sheats to new names. Let's say, you grouped Columns are A and B. If the amount of your SP List records is more than 2000, you could consider bulk-load your SP List records into a collection, then use the collection as data source in your app instead of your original SP List. i have a report extracted from a tool with issues and the impacted application per issue to excel. Excel Rescue is a done-for-you small tasks service for Microsoft Excel. Note: Please change the ' Data row limit for Non-delegable queries' option to maximum value - 2000within Advanced settings of App settings. Right click the chart whose data series you will rename, and click Select Data from the right-clicking menu. If the amount of your SP List is more than 2000, the RenameColumns function could only process first 2000 records, the rest of records in your SP List would be ignored. To rename a data series in an Excel chart, please do as follows: 1. The RenameColumns function could only process 2000 records at most from your data source. Please check the following article for more details about the RenameColumns function:īut there are some limits within the RenameColumns function - the RenameColumns function is not a Delegable function in PowerApps app. Hi columns in a SP List data source (using RenameColumnsfunction) would not affect the functions in your canvas app.Īctually, the RenameColumns function would just return a new temporary table with the transform applied, the underlying table/original table would not be changed/modified.

Microsoft excel rename columns