# | results |
0 | Alen |
1 | John |
2 | Eric |
It worked!! however, how can I use these values inside the list rows query for power automatefor ex,(contains(unq_entity/unq_name, #value 1 from datatable#) and unq_entity/unq_postcode eq value 2)
WebAutomation.LaunchEdge.LaunchEdge Url: $fx'https://afd.calpoly.edu/web/sample-tables' WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False WaitForPageToLoadTimeout: $fx'=60' Timeout: $fx'=60' PiPUserDataFolderMode: WebAutomation.PiPUserDataFolderModeEnum.AutomaticProfile TargetDesktop: $fx'{"DisplayName":"Local computer","Route":{"ServerType":"Local","ServerAddress":""}}' BrowserInstance=> Browser
WebAutomation.ExtractData.ExtractHtmlTable BrowserInstance: $fx'=Browser' Control: $fx'html > body > div:eq(1) > div:eq(0) > table:eq(1)' ExtractionParameters: {[$fx'Name', $fx'Telephone', $fx'Email', $fx'Office'], [$fx'', $fx'', $fx'', $fx''] } PostProcessData: False TimeoutInSeconds: $fx'=60' ExtractedData=> DataFromWebPage
LOOP FOREACH CurrentItem IN $fx'=DataFromWebPage'
SET Firstcolumn TO $fx'=Index(CurrentItem, 1)'
END
ClearCollect(colTest,Table({'#':0,Result:"Test1"},{'#':1,Result:"Test2"},{'#':2,Result:"Test3"}));
Set(var1,Index(colTest,1).Result);
Set(var2,Index(colTest,2).Result);
Set(var3,Index(colTest,3).Result);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.