Convert Calculate Column to Text

(0) Share

Report

Posted on by knsrinath

527

I have one Calculated column in share Point called TicketID.

Formula in Calculated Column =[Title]&[SerialNo]

There is delegation issue with calculate column while using lookup.

Is it possible to convert Calculated Column to Text Column in same column or in other column (With out Flow)

Request your help to resolve the delegation issue.

Thanks & Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @knsrinath ,

Calculated fields are not Delegable (as well as having other issues). Depending on what you are trying to query, you can use AddColumns and join them (but this is also subject to Delegation limits on the output).

You might consider writing the result to a Text column at the time it is input using Patch, then the query is fully Delegable.

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No
knsrinath 527 on at

Like (0)

Report
Copy link

Link copied!

Hi@WarrenBelz

Thanks for your Reply.

Can you please share any patch code if you have.

Thanks & Regards

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @knsrinath ,

You have not given me any references, put on the OnChange of whichever item you are updating

Patch( DataSource, ThisItem, {YourTextField:YourTitleBox.Text & YourSerialNoBox.Text} )

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No
knsrinath 527 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Please find the below code I am using

I have a calculated Column in SharePoint called as TktNo - [Title]&[Sno]

Ticket Numbers are DRF00001,DRF00002,DRF00003................

Request you help me to resolve delegation issue.

Thanks & Regards

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@knsrinath ,

You would patch to the Text column with the combination of the first two formulas

YourTextColumn: "DRF" & Last(Sort(F123Data,Sno).Sno+1

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No