Can someone please help.
I have created a form in Powerapps which once submitted, a new item is created in a Sharepoint list. Two of the fields within the form requires the user to input bank sort code and account number. In some cases, the sort code and account number will begin with zeros but when the item is created in the Sharepoint list, it does not bring over any leading zeros. I know its not an issue with Sharepoint as when an item is created directly on Sharepoint, the fields show the leading zeros. I have tried changing the format from number to text in Powerapps but doesn't resolve the issue.
Solved! Go to Solution.
One more idea. Can you please share the code used in the Update property of SortCode_DataCard1?
The Update property controls what is being submittd to SP.
Replace your code with to have the text show in SharePoint exactly as input in PowerApps
Or if you want exactly 5 leading zeros do this instead
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
there is bug related to language, you may face the issue, as I see red cross next to the field
if you insert some test label and you put in text suggested code
do you get an error? If not what is error next to the fields?
e.g. in Czech you need use
otherwise the "conversion" does not work....
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Did you miss the call? Check out the recording here!