Re: Click on link based on Value in table

asamr · ‎08-17-2022

Dear Community

I want to Click "View" based on the name in the column to the left.

When I do extract from webpage, there is no link - So I cant use the go to webpage based on link method.

Henrik_M · ‎08-17-2022

Please provide the HTML code of the table.

asamr · ‎08-17-2022

Dear Henrik

Thanks for getting back to me - Just to be sure, you want me to use the Extract function inside Power Automate Desktop, and "Extract entire HTML table" Correct?

I will do that tomorrow when I'm back at the office.

Henrik_M · ‎08-17-2022

No, not that.

I would like you to CTRL+S while on the web page to open the Save as window. Then I would like you to choose the filetype Website, only HTML and save, then upload that saved file here.

I will then inspect the web page code and provide you an answer.

asamr · ‎08-17-2022

Dear Henrik

Thanks for your patience and your help on this matter - I really appreciate it and hopefully I will learn along the way.

You saw on the above screenshot that there is the following fields:

Name

Generated Date

I want to somehow be able to tell my flow I want to click view on the row: "Sales Tracking Report" from the following "DATE" "DD/MM/YYYY"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <title>iVvy - Login</title><meta http-equiv="Content-Language" content="" >
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<meta http-equiv="Content-Language" content="" ><link href="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.2.0/css/bootstrap.min.css?v=202208170101" media="all" rel="stylesheet" type="text/css" >
<link href="https://www.ivvy.co.uk/css/login.css?v=202208170101" media="all" rel="stylesheet" type="text/css" ><script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?v=3&amp;key=AIzaSyDwpiwDMpGwo0Q16g6saUUrysJ0-BRZQY0&amp;libraries=places"></script>
<script type="text/javascript" src="https://www.ivvy.co.uk/scripts/yui/combined.min.js?v=202208170101"></script>
<script type="text/javascript" src="https://www.ivvy.co.uk/scripts/jquery/3.5.1/jquery.min.js?v=202208170101"></script>
<script type="text/javascript" src="https://www.ivvy.co.uk/scripts/jquery/swipe.min.js?v=202208170101"></script>
<script type="text/javascript" src="https://www.ivvy.co.uk/scripts/backend.min.js?v=202208170101"></script>
<script type="text/javascript" src="https://www.ivvy.co.uk/scripts/backend/form/form-table.js?v=202208170101"></script>
<script type="text/javascript" src="https://www.ivvy.co.uk/scripts/backend/lang/en.js?v=202208170101"></script><style type="text/css" media="screen">
<!--
#rememberMe-label { display:none; }
-->
</style><script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments);},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m);
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', "UA-1280345-33", "ivvy.com");
ga('send', 'pageview');
</script>        <link rel="shortcut icon" href="/images/v3/favicon-venues.png" />
        <script type="text/javascript">
            TOOLBOX.cookiePath = "/a/comwell/";
        </script>
        <!--[if lt IE 10 ]>
        <script>
            $('form dt').css('display', 'block');
        </script>
        <![endif]-->
    </head>
    <body>
        <div class="app-warning" id="browser-warning"><ul><li  id="no-javascript-warning" class="last">Warning: The browser that you are using has disabled javascript. Some features will not work whilst javascript is disabled.</li></ul></div>        <div class="container">
            <div class="row">
                <div class="col-md-4 col-md-offset-4">
                    <div class="ivvy-logo"><img src="/images/green-venue-logo.png"></div>
                    <div id="messageboard">
                        <div id="app-system-message" class="message" style="display:none;"></div>
                    </div>
                    <div id="ivvy-login-box">
                        <table cellpadding="0" cellspacing="0" border="0">
                            <tr>
                                <td valign="middle" align="left">
                                    <h2>Comwell</h2>
                                        <div class="baseapp-form"><form id="Form" enctype="application/x-www-form-urlencoded" hostUrl="https://www.ivvy.co.uk" action="/a/comwell/login?lu=%2Fa%2Fcomwell%2Fv%2F" method="post"><dl class="zend_form">
<div id="staticDomain-element-container" class="form-element static"><dt id="staticDomain-label"><label for="staticDomain" class="optional">Account:</label></dt>
<dd id="staticDomain-element"><div id="staticDomain">comwell</div></dd><div style="clear:both;"></div></div>
<div id="userName-element-container" class="form-element"><dt id="userName-label"><label for="userName" class="required">Username:</label></dt>
<dd id="userName-element">
<input type="text" name="userName" id="userName" value="" autocomplete="off" placeholder="Username" maxlength="99" createType="text" class=" longInput"></dd><div style="clear:both;"></div></div>
<div id="password-element-container" class="form-element"><dt id="password-label"><label for="password" class="required">Password:</label></dt>
<dd id="password-element">
<input type="password" name="password" id="password" value="" autocomplete="off" placeholder="Password" maxlength="99" createType="password" class=" longInput"></dd><div style="clear:both;"></div></div>
<div id="rememberMe-element-container" class="form-element"><dt id="rememberMe-label">&nbsp;</dt>
<dd id="rememberMe-element">
<input type="hidden" name="rememberMe" value="0"><input type="checkbox" name="rememberMe" id="rememberMe" value="1" class="checkbox" createType="checkbox"><span class="checkboxContent">Remember me for 30 days</span></dd><div style="clear:both;"></div></div>
<div class="form-element SubmitButton"><dt id="Submit-label">&nbsp;</dt><dd id="Submit-element">
<input type="submit" name="Submit" id="Submit" value="Login" createType="submit" class="v2-bt-active" isSubmitElement="1"></dd><div style="clear:both;"></div></div>

<input type="hidden" name="_token_" value="9b7b86d43cfff3a3c01d684f6f0908fb" createType="hidden" id="_token_"></dl></form></div>                                </td>
                            </tr>
                        </table>
                                                <div class="forgot-password">
                            <a href="/a/comwell/login/forgot-password">I can't remember my password</a>
                        </div>
                                                                    </div>
                    <div style="clear:both;"></div>
                    <div class="service-status">
                        <a href="https://status.ivvy.com/">Service Status</a>
                    </div>
                    <div class="version">
                                            </div>
                    <script type="text/javascript">
    //<!--
var myForm = new TOOLBOX.FormTable({"id":"Form","attributes":{"hostUrl":"https://www.ivvy.co.uk","action":"/a/comwell/login?lu=%2Fa%2Fcomwell%2Fv%2F","method":"post","name":"Form"},"elements":{"staticDomain":{"id":"staticDomain","name":"staticDomain","type":"BaseApp_Form_Element_Static","belongsTo":null,"helper":"formText","createType":"static"},"userName":{"id":"userName","name":"userName","type":"BaseApp_Form_Element_Text","belongsTo":null,"helper":"formText","autocomplete":"off","placeholder":"Username","maxlength":99,"createType":"text","class":" longInput"},"password":{"id":"password","name":"password","type":"BaseApp_Form_Element_Password","belongsTo":null,"helper":"formPassword","renderPassword":false,"autocomplete":"off","placeholder":"Password","maxlength":99,"createType":"password","class":" longInput"},"rememberMe":{"id":"rememberMe","name":"rememberMe","type":"BaseApp_Form_Element_Checkbox","belongsTo":null,"checked":false,"helper":"formCheckbox","class":"checkbox","content":"Remember me for 30 days","createType":"checkbox"},"Submit":{"id":"Submit","name":"Submit","type":"BaseApp_Form_Element_Submit","belongsTo":null,"helper":"formSubmit","createType":"submit","class":"v2-bt-active","isSubmitElement":true,"cancelText":"Cancel"},"_token_":{"id":"_token_","name":"_token_","type":"BaseApp_Form_Element_Hidden","belongsTo":null,"helper":"formHidden","createType":"hidden"}},"subForms":[],"belongsTo":null,"warningOnNavigate":false,"disableOnSubmit":true,"watchedElements":"null","skipSubmitChecks":false});
if (document.getElementById("userName")) { document.getElementById("userName").focus(); TOOLBOX.focusField("userName"); }    //-->
</script>                </div>
            </div>
        </div>
    </body>
</html>

Henrik_M · ‎08-18-2022

The content that I need to see is not there, so either you've saved the wrong page (the login screen?) or the relevant HTML code is generated from a script.

I need you to do the following, instead:

Press CTRL+SHIFT+C to start the browser's developer tools in inspection mode, then click on your table. Resize the code view to show as much of the HTML code as possible, then screenshot and share here.

Hope it makes sense 🙂

asamr · ‎08-18-2022

Dear Henrik

Hope you have the information you need - Else tell me 🙂

Henrik_M · ‎08-18-2022

I want to somehow be able to tell my flow I want to click view on the row: "Sales Tracking Report" from the following "DATE" "DD/MM/YYYY"

In that case, I would add a UI element of the View link, and open the selector editor. Activate text editor and build a new selector through the following steps:

tr[class*="listing_table_row"] which makes sure that the row we click on has the class indicating it's a row in the table.
tr[class*="listing_table_row"]:contains("Sales Tracking Report") which makes sure the row contains that text.
tr[class*="listing_table_row"]:contains("Sales Tracking Report"):contains("%Date") which makes sure that our row ALSO contains the date text saved in a %Date% variable.
tr[class*="listing_table_row"]:contains("Sales Tracking Report"):contains("%Date") a:contains("View") which tells PAD to click the link with the text View. So this is the final selector.

Let me know how it works.