Power Platform Community Forum Thread Details

Is it possible to hide sections of a word document using data from a SQL stored procedure.

So simply hide section when Field01 = TRUE

Categories:

Hi,

I haven't tried this yet but from what I have found, this should work.

CREATE PROCEDURE GetSectionVisibility
AS
BEGIN
SELECT Field01 = CAST(1 AS BIT) -- Example: 1 (TRUE) means section should be hidden
END

Open your Word document.
Add content controls to the sections you want to conditionally hide.
- Go to the Developer Tab in Word (enable it via Word Options if not already visible).
- Insert Rich Text Content Controls or Plain Text Content Controls around the sections to hide.
- Assign unique titles or tags to these controls (e.g., Section1, Section2).