Power Platform Community Forum Thread Details

Hi Team ,

I excel row which have value like this AB1234, AB321, AB543

I have split this by comma(,)

so now I want to pass this values one by one

like Web Application open - Value search 1) transaction AB1234 - process and completed next

2) transaction value enter AB321 same procees it completed. then

3) third transaction value enter = AB543

I want to loop through split values

Categories:

Power Automate Desktop

@Sanket1

Try like below suggested flow:

Code[Recapture google text box if it throws an error]:

SET Groupvalues TO $'''AB1234, AB321, AB543'''
Text.SplitText.SplitWithDelimiter Text: Groupvalues CustomDelimiter: $''',''' IsRegEx: False Result=> TextList
WebAutomation.LaunchChrome.LaunchChrome Url: $'''www.google.com''' WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False WaitForPageToLoadTimeout: 60 Timeout: 60 PiPUserDataFolderMode: WebAutomation.PiPUserDataFolderModeEnum.AutomaticProfile BrowserInstance=> Browser
LOOP FOREACH CurrentItem IN TextList
WebAutomation.PopulateTextField.PopulateTextFieldUsePhysicalKeyboard BrowserInstance: Browser Control: appmask['Web Page \'https://www.google.com/\'']['Text area \'Search\''] Text: CurrentItem.Trimmed Mode: WebAutomation.PopulateTextMode.Replace UnfocusAfterPopulate: True WaitForPageToLoadTimeout: 60
END

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏