Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Return specific Text and ID no. within Power App form

(0) ShareShare
ReportReport
Posted on by 487
Hi,
 
I'm looking for a logic to return specific text and ID no. in one of my Title column
 
In my SharePoint list I have a Title column, ID and few other columns. When ever a new item is created in PowerApps form I want to return specific text with the ID No.
 
For example - when new item is created, show as below:
 
Project Created - 1
 
Same should also get updated to SharePoint list
 
I can do this using Power Automate to run a flow when an Item is created, but I want to achieve this within the Power App form
  • Prem4253 Profile Picture
    487 on at
    Return specific Text and ID no. within Power App form
     
    Thanks! your solution works as expected.
  • WarrenBelz Profile Picture
    148,602 Most Valuable Professional on at
    Return specific Text and ID no. within Power App form
    A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee
  • Suggested answer
    UshaJyothiKasibhotla Profile Picture
    12 Super User 2025 Season 1 on at
    Return specific Text and ID no. within Power App form
    HI 
    You can return based on last item from sharepoint list.
     
    Last(Sort('YourSharePointList', ID, Ascending))
     
    please try it ans let me know if it works.
     
    Best Regards,
    Usha Jyothi
     
  • Verified answer
    WarrenBelz Profile Picture
    148,602 Most Valuable Professional on at
    Return specific Text and ID no. within Power App form
    Put in the OnSuccess property of the Form
    Patch(
       YourSPList,
       {
          ID: Self.LastSubmit.ID,
          Title: "Project Created - " & Self.LastSubmit.ID
       }
    )
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee
  • Verified answer
    stampcoin Profile Picture
    2,724 on at
    Return specific Text and ID no. within Power App form
    Not sure if I get your point.
    what you want is overwrite a column after creation ?
    if so, 
    1. Submit the for as usual : SubmitForm(form1) // for example.
    2. On Successs, property:
       Patch(
        mylist,                       // your list
        form1.LastSubmit,          
        {Title: "Project Created - " & form1.LastSubmit.ID} // for example you want to overwrite the Title column.
    )
     
     
  • Suggested answer
    MS.Ragavendar Profile Picture
    2,606 on at
    Return specific Text and ID no. within Power App form
     
    For Patch the colum
     
    Set(
         lastSubID,
        Patch(
            Requests,
            If(
                RequestForm.Mode = 1,
                Defaults(DataSource),
                LookUp(
                    DataSource,
                    ID = ThisItem.ID
                )
            ),
            {
                 Column:{Value:(DataCardValue.Selected.Value)},
            }
        ).ID
    );
     
    Set(varTitleID, Lookup(DataSource,ID=lastSubID).Title&" -" & lastSubID);
     
    I created new column to maintain this value (Title & ID).
     
    Patch the column with this varTitleID.
     
    Patch(
            DataSource,
                LookUp(
                    DataSource,
                    ID = lastSubID
                ),
            {
                    TitleID:varTitleID,
                 
            }
        )
     
    Hope this helps!
     
    In the form you can add the column to datacard and display parent.default.
     
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1