Return specific Text and ID no. within Power App form

(0) Share

Report

Posted on by Prem4253

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

Categories:

Using Apps Using Formulas

All responses (6)

Answers (2)

Prem4253 487 on at

Like (0)

Report

Return specific Text and ID no. within Power App form

@WarrenBelz @stampcoin

Thanks! your solution works as expected.
WarrenBelz 148,602 Most Valuable Professional on at

Like (0)

Report

Return specific Text and ID no. within Power App form

Hi @Prem4253,

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 12 Super User 2025 Season 1 on at

Like (0)

Report

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 148,602 Most Valuable Professional on at

Like (1)

Report
Return specific Text and ID no. within Power App form

Hi @Prem4253,

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 2,720 on at

Like (1)

Report

Return specific Text and ID no. within Power App form

@Prem4253 Hi,

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 2,604 on at

Like (0)

Report

Return specific Text and ID no. within Power App form

@Prem4253,

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.