Power Platform Community Forum Thread Details

Hi Power Automate Gurus,

Hopefully someone here can help me as I am very new to PA.

I have a flow setup that takes in an excel file and can search for that value on a website. The issue I have is the next link is not able to be chosen from the UI Element so I am using the 'Move Mouse to Text on screen' action so I can click it - which then opens up the Element to be used.

For the 'Move Mouse to text on screen (OCR)' action I am unsure what to populate in the 'Text to find' area. When I put the value of the first item from the excel it works fine. I want it to be able to find the data from the excel and loop through each one.

To give you some information that may assist you assisting me.

When doing the 'Populate Text field on web page' to search for the same value it works when I enter in the text input as '%CurrentItem['StudentCode']%'

Current Item being the excel document that I have already brought into the flow and studentcode being the name of the column I am using.

Please let me know if you need further clarity or if there is more information that I can give to further assist you in helping me.

See attached the screenshot of the field I am looking to update. When replacing my attempt of coding with the value of the first code in the excel it works well.