Select an item based on column entry

(0) Share

Report

Posted on by Kosenurm

802

Hi there,

I have a desktop flow which runs in unattended mode. It logs into a third party portal and searches for users based on their user name (e.g. smithj).

However, when this search is undertaken, anything containing "smithj" is returned (so sometimes more than one person) e.g. smithj2, smithj3.

The purpose of the flow is to set this user to inactive, so what it does is search for the user name, and this displays a list of all users in that portal where that user name is contained, in the form of a table...

Let's say the user to be selected was smithj2... how can I tell the PAD flow to go to this record in the UI table and select the user which matches the input (smithj2) - by the way, each user has a hyperlink to their page which is in the User column

User User name

John Smith smithj

John Smith smithj2

John Smith smithj3

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I was facing a similar challenge. With my system I was able to use double-quotes in my search for "smithj2" which only returned the middle result. Maybe yours has similar search options as well...

If not, you need to make a UI element of the hyperlink with a custom selector. Sounds like your search results are listed in a table format, so this selector's purpose will be to find the ROW that contains the User name, then click on the link. In other words: find the link which exists in a row that contains the user name.

The selector should look something something like this: tr:contains("%User%") > td > a

Was this reply helpful? Yes No
Kosenurm 802 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks - this is really helpful. What action would I use in PAD to create a custom selector?
Thanks
K.

Was this reply helpful? Yes No
Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

It is set up in a UI element. Check this page out, especially the anchored part: Build a custom selector - Power Automate | Microsoft Docs

Was this reply helpful? Yes No