Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dvPQPXPEo7X5V/H1WSX52G
Power Apps - Building Power Apps
Answered

First, Last, FirstN and LastN???!!!

Like (0) ShareShare
ReportReport
Posted on 22 Jan 2019 23:08:40 by

How can I make this work.

 

After trying so many different ways I came up with this.

 

I have a datacard called Job steps and I have 10 textinputs as shown below. (Also see pic for reference)

 

textinput 1

textinput2

textinput3

textinpit 4

.

.

.

.

textinput10

 

I want the textboxes to get back their default values when user opens the submitted form in edit mode.

 

I used If(!Exisitng, "1.", First(Split(ThisItem.JobSteps,"|")).Result). -- - I am checking if it is not an existing form then have 1. in the textinput, if not (if its edit form) have the defaulted value that the user submitted when they created this form.

 

Technically the above formula works for my First TextInput but how can I get back the other TextInput information?

 

I tried the formula (See below) For the second textinput but I am not sure how to make this work.

 

My patch function for this coloumn is 

jobsteps: Concatenate(TextInput7.Text,"|", TextInput8.Text, "|", TextInput14.Text)

 

 

Any help is highly appreciated!!!

 

  • asdeev Profile Picture
    on 23 Jan 2019 at 15:22:38
    Re: First, Last, FirstN and LastN???!!!

    @PaulD1
    @KroonOfficeSol

     

    This is awesome! Thank you thank you thank you!! It works.

  • Verified answer
    PaulD1 Profile Picture
    2,914 on 23 Jan 2019 at 00:41:37
    Re: First, Last, FirstN and LastN???!!!

    If I understand correctly, you want to get back element N from an array.

    For element 1 you are using: If(!Exisitng, "1.", First(Split(ThisItem.JobSteps,"|")).Result)

    For element 2 you can use a combination of Last and FirstN, e.g.

    If(!Exisitng, "1.", Last(FirstN(Split(ThisItem.JobSteps,"|"),2)).Result)

    So you are saying, return the first 2 items and give me the last one.

    To get element 3 would be:

    If(!Exisitng, "1.", Last(FirstN(Split(ThisItem.JobSteps,"|"),3)).Result)

  • Verified answer
    KroonOfficeSol Profile Picture
    587 on 22 Jan 2019 at 23:36:37
    Re: First, Last, FirstN, LastN??!

    @asdeev

     

    For the second and so on you could try

    Last(FirstN(Split(ThisItem.JobSteps,"|"),2))).Result)

    Change the 2 to 3,4,5,6,7 and so on.

     

    Should work I would think.


    Paul

     

     

  • asdeev Profile Picture
    on 22 Jan 2019 at 23:13:33
    First, Last, FirstN, LastN??!

    After trying so many different ways I came up with this.

     

    I have a datacard called Job steps and I have 10 textinputs as shown below. (Also see pic for reference)

     

    textinput 1

    textinput2

    textinput3

    textinpit 4

    .

    .

    .

    .

    textinput10

     

    I want the textboxes to get back their default values when user opens the submitted form in edit mode.

     

    I used If(!Exisitng, "1.", First(Split(ThisItem.JobSteps,"|")).Result). -- - I am checking if it is not an existing form then have 1. in the textinput, if not (if its edit form) have the defaulted value that the user submitted when they created this form.

     

    Technically the above formula works for my First TextInput but how can I get back the other TextInput information?

     

    I tried the formula (See below) For the second textinput but I am not sure how to make this work.

     

    My patch function for this coloumn is 

    jobsteps: Concatenate(TextInput7.Text,"|", TextInput8.Text, "|", TextInput14.Text)

     

     My datasource is SQL and Jobsteps is one of the coloum in it.

     

    Any help is highly appreciated!!!

  • asdeev Profile Picture
    on 22 Jan 2019 at 23:11:38
    First, Last,, FirstN, LastN??!! Please help

    After trying so many different ways I came up with this.

     

    I have a datacard called Job steps and I have 10 textinputs as shown below. (Also see pic for reference)

     

    textinput 1

    textinput2

    textinput3

    textinpit 4

    .

    .

    .

    .

    textinput10

     

    I want the textboxes to get back their default values when user opens the submitted form in edit mode.

     

    I used If(!Exisitng, "1.", First(Split(ThisItem.JobSteps,"|")).Result). -- - I am checking if it is not an existing form then have 1. in the textinput, if not (if its edit form) have the defaulted value that the user submitted when they created this form.

     

    Technically the above formula works for my First TextInput but how can I get back the other TextInput information?

     

    I tried the formula (See below) For the second textinput but I am not sure how to make this work.

     

    My patch function for this coloumn is 

    jobsteps: Concatenate(TextInput7.Text,"|", TextInput8.Text, "|", TextInput14.Text)

     

     

    Any help is highly appreciated!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 83 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 54

#3
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

Overall leaderboard
Loading started