cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PVLove
Helper I
Helper I

Update SharePoint Text Fields with Choice Column Item in PowerApps

Hello All,

I have a PowerApps canvas form with a SharePoint Choice column and two Single Text columns. When a User selects "Yes" from the Choice column I want to populate the first Single Text column with a specific User name, and populate the second Single Text column with that User's email. The Choice column determines if the request form is a 'Corporate Request' and the items are No and Yes. The two text columns will always be the CFO's name (Corporate Approver) and his email (Approver Email). I have tried multiple solutions that I've found online and nothing has worked. Can anyone tell me what functions I should use on each of the column properties?

Thank you for any assistance.

PLove

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Community Champion
Community Champion

Hi @PVLove 

 

I'm not using a Data card. Just a name to differentiate from the SP column name.

  • Combo Box refers SP List
  • Text field refers Combo box

StalinPonnusamy_0-1631295293229.pngStalinPonnusamy_1-1631295311727.png

 

View solution in original post

5 REPLIES 5
rampprakash
Power Participant
Power Participant

Hi @PVLove,

 

Try below query

 

In the Name Field set Default Value as

If(Dropdown1.Selected.Value ="Yes","Set Name Here",Blank());

 

Then Email Field set Default Value as

If(Dropdrown.Selected.Value=Yes, "Set Email Here",Blank())

 Please Mark as Answer if it is helpful and provide Kudos

 

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie

rampprakash_0-1631214322388.jpeg

 

 

Hi @rampprakash ,

Thank you for responding!  I'm using a SharePoint Choice column and not a Dropdown.  I've tried using the following expression for the Default value in the Name field, but it triggers the error displayed in the screenshot.

 

Name field > Default value:

If(CorporateRequest.Selected.Value = "Yes", "Peyton Henderson", Blank())

 

Patti

StalinPonnusamy
Community Champion
Community Champion

Hi @PVLove

 

Corporate Request is a choice column in SP and the Items property for the dropdown is

Choices(SPList.CorporateRequestCollumnName)

 

The text Default property is

If(CorporateRequestDataCard.Selected.Value = "Yes", "Peyton Henderson", Blank())

StalinPonnusamy_0-1631278189533.png

Please let us know if misunderstanding your requirement

Hi @StalinPonnusamy ,

Thank you for responding!  I finally go it to work, but only with the expression below.

 

Name > Default >

If(DataCardValue52.Selected.Value = "Yes", "Peyton Henderson", Blank()).

 

The Name > Default field will NOT accept the expression:

If(CorporateRequest.Selected.Value = "Yes", "Peyton Henderson", Blank())

 

I know using the DataCardValue is not good practice, but I'm at a loss on how to resolve the the issue.

Thanks!

Patti

StalinPonnusamy
Community Champion
Community Champion

Hi @PVLove 

 

I'm not using a Data card. Just a name to differentiate from the SP column name.

  • Combo Box refers SP List
  • Text field refers Combo box

StalinPonnusamy_0-1631295293229.pngStalinPonnusamy_1-1631295311727.png

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,308)