How to show a Fill-in value inside a Free-Text for a choice field inside our edit form

(0) Share

Report

Posted on by johnjohn123

3,514

We have the following SharePoint Choice field which allow fill-in value:-

aloow fill in.png

Then we created a canvas app >> where the above field will be mapped as a combo box, so i have did these modifications:-

1) i removed the mapped combo box and enter radio button with static values representing the standards options as per the above field definition.

2) I added a checkbox and free text to allow the user to either select a radio option or enter a manual value, as follow:-

3) finally i updated the Update property of the card, as follow:-

If(varManualAdd2,{Value : TextInput2.Text},Radio1.Selected)

now this is working for creating a new item.. but since i am using the same form to edit items.. so how i can do the following:-

1) when i retrieve the list item and define it inside Item property for the form:-

If(IsBlank(varRecord),Defaults('Online Credit Request'),varRecord)

how i can map the value of this Choice field>> to get the related Radio option selected

2) incase the current value does not match any of the static Radio choices, how to enter the value inside the free text?

Any advice ?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

The problem you are going to encounter is that, when you add a new choice from a fill-in, that will become part of the choices.

So, if a person enters $100, for example, you are expecting to see the textbox come up later when editing to show the $100. You can devise a formula to do this, but the problem comes if someone else enters $200 in the textinput. Now your list contains both the 100 and 200. So...which one would you show when editing?

My suggestion would be to not use a fill-in value, but to simply record the written in value into another column in your datasource. That way, you can display this value to the user when editing the record without any issues.

I hope this is helpful for you.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes yes i know , but to fix this i can do these checks:-

1) get the current item amount

2) check if this Amount is inside the Radio static items, and if so, to select the related radio button, while if the check fail, to enter the current item Amount inside the input field.. but i am not sure how i can write such a formula?
Thanks

**You might did not notice that the Radio button is having static items and not a dynamic ones (i did so to avoid the issue you referred to)... so filled in choices will not be shown inside the Radio buttons static Items values..

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sorry...I see you replied to this (as I mentioned in your other post).

Your issue still remains - if one user enters 100, it will now be in your Choices. If another user enters 200, it will now be in your choices.

So how would you decern between the two?

@johnjohn123

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes fill-in values will not be shown inside my choices as my choices are static inside the Items property as shown in this picture which i posted already

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Yes, but you want the fill in choice to appear in your text input control...correct?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes No... if the choice is not within the static item.. to show it inside the free text input

Was this reply helpful? Yes No