Unanswered

Excel Set checkbox state fails

(0) Share

Report

Posted on by PAD_Charles

I'm using the Set checkbox state in window action and want to set it to Unchecked. The initial state is unknown, it may be checked or unchecked. When I use the action, it does not uncheck it if it is in a checked state. There is no error.

Specifically I'm using the Subtotal function from Outline. I want to check the Stock checkbox and uncheck the Sector checkbox. This is how the dialog box opens most of the time. The check/uncheck isn't working. Any thoughts? Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

VJR 7,635 on at

Like (1)

Report

Hi @PAD_Charles

This may definitely have to got to do with the selectors.
For a windows application this should work without any issues, unless the selectors are incorrect. Can you share what your selectors show for the checkboxes.

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (0)

Report

Hmmm can't get it to work either.
Tried with the "Set checkbox state" and it only highlights the checkbox text.
But I can click it by using "Click UI element in window", if I ask it to click left, with X offset at 10.
If I don't use an offset of 10 then it will click just left of the checkbox.

My selector
The selector below is made short by me, have tried with the one that PAD catches, and same result.

My click action

Was this reply helpful? Yes No
PAD_Charles 9 on at

Like (0)

Report

Hi, thanks for trying to help. Is this what you're looking for?
> window[Class="bosa_sdm_XL9"][Name="Subtotal"] > list[Name="Add subtotal to:"] > checkbox[Name="Sector"]

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (0)

Report

I don't think it's a selector problem.
Btw.: You can make your selector as short as this
checkbox[Name="Sector"]

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (1)

Report
I've previously experienced that the subwindows in Excel work inconsistently when activated with the regular actions.

What you might need to do, is check whether or not the checkbox is checked, and if we have to click on it, use the following code:

UIAutomation.GetElementDetails Element: appmask['Window \'Create Sparklines\'']['Button \'OK\''] AttributeName: $'''Location and Size''' AttributeValue=> AttributeValue Text.SplitText.SplitWithDelimiter Text: AttributeValue CustomDelimiter: $''', ''' IsRegEx: False Result=> TextList Variables.TruncateNumber.RoundNumber Number: TextList[2] / 2 + TextList[0] DecimalPlaces: 0 Result=> X Variables.TruncateNumber.RoundNumber Number: TextList[1] + TextList[3] / 2 DecimalPlaces: 0 Result=> Y MouseAndKeyboard.SendMouseClick.ClickAt ClickType: MouseAndKeyboard.MouseClickType.LeftClick MillisecondsDelay: 0 X: X Y: Y RelativeTo: MouseAndKeyboard.PositionRelativeTo.Screen MovementStyle: MouseAndKeyboard.MovementStyle.Instant

Was this reply helpful? Yes No
PAD_Charles 9 on at

Like (0)

Report

Thanks for posting this. I don't know how to add code to Power Automate Desktop, but this gave me the idea to check the state of each checkbox and "check" it if needed.

Was this reply helpful? Yes No