How to format text input datacard to decimal and add euro as defaults

[Tapesh]

Hi All 

Im trying to use the formula to show the textinput value of my data as something like this  " 12.33€ "

I tried to use the following formula on the different property but does not work 

on Default: 

Text(Value(Parent.Default),"[$-en-US]#.0")

also same i tried to change for format property but does not work for me. 

i also tired this on default and Format property 

Text(5.678,"#.#")

But nothing seems to be working for me. 

is there anything im doing wrong?

I want to show the results after the persons as something like this below, where the number is automatically converted into two decimals adding zeros if no values is added. 

Thanks for helping :d

[eka24]

Try

Text(Parent.Default,"[$-fr-FR]# ###,## €", "fr-FR")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Tapesh]

Hi @eka24 

This does not work, is there any solution other then this ?

[v-qiaqi-msft · Accepted solution]

Hi@Tapesh,

Based on the issue that you mentioned, do you want to format the TextInput when typing within?

I think a Variable could achieve your needs.

I have a test on my side, please take a try as below.

Set the OnChange property of the TextInput control as below:

Set(
    var3,
    Text(
        Value(
            DataCardValue3.Text,
            "en-US"
        ),
        "[$-en-US]#.00"
    ) & " €"
)

Set the Default property of the TextInput control as below:

If(!IsBlank(var3),var3,"")// In case, please indentify the if the var3 is blank

Note: DataCardValue3 represents the TextInput control.

Make sure that the Format property within the TextInput is matched to the data type. My 'Room' column is a Text column, so I choose the Format as Text.

You can check the Gif for reference.

Best Regards,

Qi

[Tapesh]

Hi @v-qiaqi-msft 

This is so perfect solution to what I wanted, but this is giving me a problem in my collection, such that when i add the total to collection it is not showing me the Sum(addition) can you please let me know why Sir?

Please have a look at my output as you said and showed its working fine, but my collection is not working now, week total shows the sum records of all the total is added 

e.g : total = 10, 10 10,

weektotal should be : 30 

Please see that on default of my weektotal: 

"€" & Sum(Recordss, TotalItems)

and On addbutton the collection is:

Collect(Recordss, 
{
    GItems: Text(Dropdown1.Selected.Value),
    TotalItems:DataCardValue43.Text,
    RDate: DataCardValue2.SelectedDate,
    Description: DataCardValue1.Text
});

Please note that in above formula

GItems is weektotal card 

                                             and                                                 

totalItems is Total Card as shown in below screenshot.

Thanks a lot for your help so far sir @v-qiaqi-msft if you can help me with this error would be glad sir. 

Thankyou. 

[v-qiaqi-msft]

Hi@Tapesh,

Have seen that you move your question to a new thread and my colleague has taken it . If my previous solution has solved your original problem as your title described, please mark my answer as a solution so that other users could find it easily. Thanks for your co-operation.

Best Regards,

Qi

[dperez13]

my app has multiple forms so if I go to make a new form, var3 gets set as a value for all the other forms. var3 is the same for all the other forms in the gallery

do i need to do updatecontext instead of set? how do i make each form have its own unique var3 value rather than they all have var3 pointing to the latest recent value???