How to generate a code based on user data input

[nikola_bgd]

Hi,

I'm building a customized Sharepoint form in PowerApps and what I want to do is have a Sharepoint text field that is being populated by PowerApps based on the values which the user inputs in the PowerApps form. Something similar to Sharepoint calculated column, but being done by PowerApps.

This is how the calculated column function (column Code) would look in Sharepoint list: =Text(Created, "[$-en-US]ddmmyy")&Upper(Left(Country, 3))&Text(Created, "[$-en-US] ss")&Number

So the form in Powerapps will have the fields:

-Country

-Number

The Created column is the time of data creation (submiting the form in PowerApps).

How to setup powerapps to automatically generate the data for column Code ?

Cheers

[RandyHayes]

@nikola_bgd 

Based on what I read in your post, you will have a PowerApp that will have an EditForm in it.  In that form, users can enter a country and a number.  Then when submitted, the Code column should contain a combined text value of the date creating, the country, the seconds of the current time, and the number entered.

My first question would be this - are Country and Number columns in your SharePoint List?

If so, then you will have these (country and number) columns in your EditForm.  You need to find out their entry control names within the form datacards.  So, expand the datacard in the left tree view, look for the DataCardValuexx name for both the Country and the Number datacards.

Then, for your Code column datacard in the EditForm (first unlock it) then set the Update property to:

Text(Now(), "[$-en-US]ddmmyy") & Upper(Left(DataCardValuexx.Text, 3)) & Text(Now(), "[$-en-US] ss") & DataCardValueyy.Text

Replace the DataCardValuexx with the control for the Country, and replace DataCardValueyy with the control for the Number.

I hope this is helpful for you.

[nikola_bgd]

Hi @RandyHayes ,

Thanks for your help!

I've tried to change the code but still get some errors:

- Name isn't valid

- The function left has some invalid arguments

This is the code:

Text(Now(), "[$-en-US]ddmmyy") & Upper(Left(ComboBox1.Selected.Text, 3)) & Text(Now(), "[$-en-US] ss") & DataCardValue29.Text

Basically there's an issue with: Upper(Left(ComboBox1.Selected.Text, 3))

It refers to a choice card..

[RandyHayes]

@nikola_bgd 

So then considering your response, I can assume that Country is a Choice Column.

If that is the case then change your formula to the following:

Text(Now(), "[$-en-US]ddmmyy") & Upper(Left(ComboBox1.Selected.Value, 3)) & Text(Now(), "[$-en-US] ss") & DataCardValue29.Text

[nikola_bgd]

@RandyHayes 

The formula still has errors:

1. Name isn't valid, the identifier isn't recognized

2. The funcion left has some invalid arguments

[RandyHayes]

@nikola_bgd 

Please provide the Items property for the ComboBox.

[nikola_bgd]

Hi @RandyHayes 

I managed to get it running:

Text(Now(),"[$-en-US]ddmmyy")&Upper(Left(Concat(ComboBox1.SelectedItems,Country),3))&Text(Now(),"[$-en-US] ss")&DataCardValue29.Text

[RandyHayes]

@nikola_bgd 

This will give you inaccurate results if you have this defined as a multi-select combobox.

But, it did give the clue I was looking for from that last reply.

Your formula should work as this:

Text(Now(),"[$-en-US]ddmmyy") & Upper(Left(ComboBox1.Selected.Country,3)) & Text(Now(),"[$-en-US] ss") & DataCardValue29.Text

Edit: corrected typo in the formula 

[nikola_bgd]

@RandyHayes 

It works! Thanks a lot!

Just one final touch, the result has a space  220519ANG 582, do you know how to fix this?

[RandyHayes · Accepted solution]

@nikola_bgd 

Excellent!

Yes, the space is in your text format.  Change the formula to this:

Text(Now(),"[$-en-US]ddmmyy") & Upper(Left(ComboBox1.Selected.Country,3)) & Text(Now(),"[$-en-US]ss") & DataCardValue29.Text