Answered

compare text value from a web page

(0) Share

Report

Posted on by qunq

Dears

I am trying to make a flow that reads from an Excel sheet then inputs this information into a web page then extracts the outcome and writes it back to Excel. the outcome is a text value. I want to compare the outcome as follows

Start with OK
Not start with OK

but I got an error . do you have any idea how to fix this issue?

Flow

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @qunq ,

Can you provide the web extracted data screenshot.The format of the extracted data is the problem.
Just try with the IF condition possible the same logic.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
eetuRobo 4,484 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Your SAC variable is a datatable. So if it will always have just one column and one row the refer to it as %SAC[0][0]%

So in your Switch where there is just %SAC% change it to %SAC[0][0]%

Was this reply helpful? Yes No
Verified answer

qunq 32 on at

Like (0)

Report
Copy link

Link copied!

Dears
thank you for your comments. I believe the flow is working fine now after I trimmed the text.

Was this reply helpful? Yes No