How can I click the button to create new item and save data

[kit1128]

Hi guys,

I was creating a system for businesses hiring and I want to do the key indicators when job creating. When I click the button(+),

it will add the new text input. The save button can upload all text input to database and the (x) button will delete the last text input.

In the phone interview, I can give a grading to candidate for each key indicators

[gabibalaban]

If you don't have a collection yet, on OnVisible property of the screen set a collection to keep the KeyIndicators.

You can use a gallery to keep the KeyIndicators.

Set the Gallery items property on KeyIndicators collection and the On Select property of + button to Collect(KeyIndicators,Defaults(KeyIndicators),{}).

and you'll have a new line in the Gallery.

Please note that at the end you can refer to items even to the value of the controls inside the Gallery using ForAll(Gallery.AllItems ....) .

Hope it helps !

[v-yutliu-msft · Accepted solution]

Hi @kit1128 ,

Do you want to add key indicators when creating a new job and score for candidate based on every key indicators?

Could you tell me your data source and the fields data type in your data source?

I assume that you use sharepoint list as data source.

I've made a similar test for your reference:

1)create two sharepoint lists.

List1 for job requirements: job_name(text type), key_indicator(text type)

List2 for interview result: job_name(lookup type,look up to list1's job_name field), interviewername(text type),interview_result(text type),totalscore(number)

2)connect your app with these two lists

3)The creating job screen:

insert a drop down(for choosing job name), a list box(list selected job's existing  key_indicators), a textinput(enter new  key_indicator),a "+" button(update new  key_indicator), a "X"button(delete key_indicator)

Looks like this:

set the job name drop down's Items:

Distinct(list1,job_name)

set the list box's Items:

Filter(list1,job_name=drop down1.Selected.Result)

 set the list box's Value: 

 key_indicator

set the "+"button's OnSelect:

If(IsEmpty(
           Filter(list1,job_name=drop down1.Selected.Result,key_indicator=TextInput.Text)
           ),
Patch(list1,Defaults(list1),{job_name:dropdown1.Selected.Result,key_indicator:TextInput.Text})
)

 set the "x" button's OnSelect:

Remove(list1,LookUp(list1,job_name=drop down1.Selected.Result,key_indicator=TextInput.Text)

Then if you select job name in the drop down, the list name will display the selected job's existing key_indicators.

If you enter data in the textinput, click "+", you will create a new record with the selected job name and new key_indicator.

If you click "x", you will delete the relatced record.

3)The interview screen:

insert a drop down(to choose job name), a textinput(to enter interviewer name), a gallery( to display selected job's key_indicators), a rating inside the gallery(to score for interviewer), a submit button.

Looks like:

set the drop down's Items:

Choices(list2.job_name)

set the gallery's Items:

Filter(list1,job_name=drop down2.Selected.Value)

set the label's Text inside the gallery:

ThisItem.key_indicator

 set the submit button's OnSelect:

Patch(list2,
      Defaults(list2),
      {job_name:drop down2.Selected,
       interviewername:TextInput2.Text,
       interview_result:Cocat(interviewGallery.AllItems,interview_result&":"&Rating1.Value&";"),
       totalscore:Sum(interviewGallery.AllItems,Rating1.Value)
       }
       )

 Then if you select a job name, the gallery will display related key_indicators, you enter interviewer name and rate for every key_indicators in the gallery. If you click the submit button, you will submit the interview result.

Best regards,

[kit1128]

HI @v-yutliu-msft @gabibalaban,

Thank you very much for your help, it helped me a lot, thanks!!!

[kit1128]

Hi @v-yutliu-msft ,

I've another question, can powerapps made that as shown

When i was click the +button, that will be created a new text input.

Thanks

[v-yutliu-msft]

Hi @kit1128 ,

I suggest you create a new issue in our forum if you have other new problems.

Now let me answer you this question for thank you marking my last solution before 😀:

I'm afraid it's not supported to create a textinput by clicking a button.

You need to insert all the textinputs that you need when you design the app.

Then you could decide how many textinputs to be visible by clicking the "+" button.

I've made a similar test for your reference:

I assume that you need 5 textinputs at most.

Step1: insert 5 textinputs and a "+" button, a "-" button

Step2:set the screen's OnVisible:

Set(num,1)

set the "-" button's OnSelect:

Set(num,num-1)

set the "+" button's OnSelect:

Set(num,num+1)

Step3:
set textinput1's Visible:

If(num>=1,true,false)

set textinput2's Visible:

If(num>=2,true,false)

set textinput3's Visible:

If(num>=3,true,false)

set textinput4's Visible:

If(num>=4,true,false)

set textinput5's Visible:

If(num>=5,true,false)

Then firstly only one textinput is in the screen, if you create the "+" button,the number of textinputs will increase one, if you click "-" button, the number of textinputs will decrease one. At most there will be 5 textinputs in the screen.

Best regards,

[kit1128]

Hi @v-yutliu-msft ,

Thank you for always stepping in to help when I need you most.😁