Announcements
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
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
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
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
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:
I know using the DataCardValue is not good practice, but I'm at a loss on how to resolve the the issue.
Thanks!
I'm not using a Data card. Just a name to differentiate from the SP column name.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
