Main Sequence: Could not find the user-interface (UI) element for this action

Help Studio
1

When i learn the class which is Excel Automation with the Modern Experience in Studio,i met a problem.I can’t use the click activity to click Format as table in the right way.Always go wrong.Main Sequence: Could not find the user-interface (UI) element for this action. Possible solutions: • Ensure application is opened and the UI element is visible on the screen at execution time • Edit the Target of the UI activity and use Validation to debug the issue. • If needed, re-indicate the element as its properties might have changed • Use “Check state” activity to check the application state before executing the action • Increase the “Delay before” value to allow time to the application to render entirely and become responsive

This image is a screenshot of a debugging or inspection window from UiPath Studio, displaying the details of an exception, variables, sequence properties, and the properties of a specific "Click: Format as Table" activity. (Captioned by AI)
This image is a screenshot of a debugging or inspection window from UiPath Studio, displaying the details of an exception, variables, sequence properties, and the properties of a specific "Click: Format as Table" activity. (Captioned by AI)3210×998 122 KB

5964d76d67a5a6af4033e64b1b32fd9
5964d76d67a5a6af4033e64b1b32fd91684×1003 150 KB

2

I also download the offical reference workflow. Same error. All the packages is the same version as study class.Anlybody can help me please?

3

HI,

To isolate cause, can you try the following sample? This works in my environment (Studio23.10.7+ UiAutomation pack 23.10.11+Excel pack2.22.4 Excel2019)

image
image1138×1006 32.4 KB

Sample20240821-3.zip (8.5 KB)

Regards,

4

@WEN_HE,

I would suggest to use Keyboard Shortcut here.

To Format as Table shortcut is Alt+H+T after this use another Keyboard shortcut activity to pass down, up, left, right keys to select desired format.

Thanks,
Ashok :slight_smile:

5

Thanks for answer!I’ve tried the following sample and it still gives me an error. Studio24.10.1+ UIautomation pack 22.10.04 + Excel pack2.16.1 Totall same as the following sample version）

6

Thanks for help.But idk how to record 3 keys?

7

@WEN_HE,

There is record button on Keyboard shortcuts activity. Use it.
If 3 keys in one Keyboard Shortcuts then use two shortcuts in tow activities.

in first pass Alt+H
in second T

Thanks,
Ashok :slight_smile: