PowerApps Formulated field does not gives correct output in Excel

(1) Share

Report

Posted on by Prem4253

652

Hello,

I have a PowerApps form connected to SharePoint list. Within this form I have a Single line of text field called "Combination".

To this Combination field I have used below expression:

Text(DateTimeValue(DataCardValue26.SelectedDate),"mmyy") & Trim(ThisItem.LocationNo & Upper( Left(ThisItem.'Customer Name',3 ) &"OP"))

This usually helps me to get - mmyy from Date field, than the location no, first 3 characters from Customer Name field and at last it adds OP.

For e.g. Date selected is 5/1/2025, Location-RTT, Customer Name (3 characters) - DDA, so the result will be as below:

0525RTTDDAOP

In App, it does shows the correct logic calculated, but in SharePoint list and the list that is extracted to Excel, few of the fields are not populating correctly.

For above instance - it is only showing OP in the "Combination" field.

Not sure, what is causing this error in Excel.

Categories:

Experimental features

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
Hi @Prem4253,

You do not need DateTimeValue and some of the bracketing may not be optimal (suggestion below)
Text(DataCardValue26.SelectedDate,"mmyy") & Trim(ThisItem.LocationNo) & Upper(Left(ThisItem.'Customer Name',3)) & "OP"

but the piece of information missing is how you are using this value to write to the SharePoint list. Can you please include the code (in Text) for this.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Qawwam 61 on at

Like (0)

Report

ThisItem.X refers to the existing record — not the new or edited values the user selects.

So, instead of ThisItem.LocationNo and ThisItem.'Customer Name' use DataCardValue_Location.Text and DataCardValue_CustomerName.Text.

Was this reply helpful? Yes No