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
Solved! Go to Solution.
Hi @PVLove
I'm not using a Data card. Just a name to differentiate from the SP column name.
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:
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
Hi @PVLove
I'm not using a Data card. Just a name to differentiate from the SP column name.
User | Count |
---|---|
164 | |
90 | |
73 | |
64 | |
57 |
User | Count |
---|---|
213 | |
153 | |
96 | |
88 | |
66 |