Power Platform Community Forum Thread Details

As picture showed, I have read data from excel and stored the supplier names in a list in power automate desktop as CurrentMonthSupplier

However, since the values in website's drop down list are partially different from those in excel,

for example,

value(supplier name) in the excel: Apple company, Orrange company BV

value(supplier name) in website's drop down list: Apple company BVBA, Orrange company

Please tell me how to use a partial match to correctly set drop-down list value on webpage.

Thanks in advance!

Categories:

Set drop-down list value on webpage using a partial match from data in excel