Share via

add repeat item labels in a PivotTable office script

Oisín Liston 20 Reputation points
2023-06-15T21:04:16.23+00:00

Can office scripts support adding repeating item labels in a PivotTable? When I try to record this action within Excel online it gives a error - activity cannot be recorded.

Are there plans to update office scripts to support this action?

I'm using office scripts with a pivot table to transpose and summarise data within a tab on an excel online file before converting the data to a table for input into a Power Automate flow.

As such I need all item labels to repeat for the table to populate correctly.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,732 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,979 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,002 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,008 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oisín Liston 20 Reputation points
    2023-10-18T12:20:44.61+00:00

    Yes you can do it manually via the settings but need to be able to do it via office script.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.