Hi @Newuser11 I hope you are doing well.
It seems that your question is about how to pass the correct UI element value from Excel to the web form when dealing with a scenario where the "Other" option opens a dropdown with additional options.
Here are some steps you might consider:
Identify the Radio Button Value:
- In your Excel sheet, you may have the value that specifies the radio button option for each row.
Handle "Other" Option:
- Check if the radio button option is "Other."
- If it is "Other," extract the corresponding value for the dropdown in your Excel sheet.
Pass Correct UI Element Value:
- When filling out the web form, use conditions in your Power Automate Desktop workflow.
- If the radio button option is not "Other," simply select the appropriate radio button.
- If the radio button option is "Other," first select the "Other" radio button and then select the value from the extracted dropdown options.
Hope this helps,
If I have addressed your inquiry successfully, kindly consider marking my response as the preferred solution. If you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.
Additionally, I offer specialized consultancy and development services leveraging Power Automate Desktop. If you're interested in exploring these services further, feel free to DM me, and we can initiate a discussion. Thank you for your engagement!
Kind regards,
Will SG
Managing Director & Automation Lead
RAMS CR (Recruitment & Automation)
LinkedIn Profile
