web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / web form filling from ...
Power Automate
Answered

web form filling from excel sheet which contains a gender column

(0) ShareShare
ReportReport
Posted on by 75

Hi all i am trying t filla webform from a excel sheet which contains a gender column, iam unable to make the radio button select the appropraite gender value based on the excel data.

The UI element picker either picks male or female only. 

I have the same question (0)
  • Verified answer
    Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 2 on at

    Hi @bensat2 ,

    Here you cant pass data directly for ui,

    First use if condition

    if currentitem['gender'] = 'male'

    click this

    else click female

    Ahammad_Riyaz_0-1702617716845.png

     

     


    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    Regards,
    Riyaz

  • bensat2 Profile Picture
    75 on at

    bensat2_0-1702623194875.png

    Hi 

    this is the field in my form

    bensat2_1-1702623720664.png

    The flow say there is no variable clled currentitem[Gender]

     

  • bensat2 Profile Picture
    75 on at

    unable to create the variable current item gender, what is the ui element to be selected in the image i shared above of the form

     

  • Verified answer
    Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 2 on at

    Male give without double quotes

  • Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 2 on at

    Ahammad_Riyaz_0-1702630441641.png

     

     


    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    Regards,
    Riyaz

  • bensat2 Profile Picture
    75 on at

    Could you just show a screen shot of creating currentitem[gender]

  • bensat2 Profile Picture
    75 on at

    have shared the screen shot of my web form

     

  • Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 2 on at

    CurrentItem is a variable what we passing for each row  i hope you read excel and stored in variable and passing through loop so in for each automatic created variable currentitem.

    %CurrentItem['Gender'] %

    I hope in your excel Gender is the column name in excel else you can use index also.

    %CurrentItem[3] %

    These all are examples.

     


    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    Regards,
    Riyaz

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 298 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 159 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 150 Super User 2026 Season 2

Last 30 days Overall leaderboard