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

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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,337)