Update SharePoint Text Fields with Choice Column Item in PowerApps

(0) Share

Report

Posted on by PVLove

299

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
PVLove 299 on at

Like (0)

Report

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

corpRequest1.png

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
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

Was this reply helpful? Yes No
PVLove 299 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (2)

Report
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

Was this reply helpful? Yes No