Update SharePoint Text Fields with Choice Column Item in PowerApps

[PVLove]

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

[rampprakash]

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

[#3]

 Please Mark as Answer if it is helpful and provide Kudos

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

Blog : https://microsoftcrmtechie

[PVLove]

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]

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())

Please let us know if misunderstanding your requirement

[PVLove]

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 · Accepted solution]

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