Unanswered

Calculated field is not showing data on SP list

(0) Share

Report

Posted on by JediWookie

Hello,

I'm using the following forumla to auto generate a tracker number. The formula is working for me and the field on the form is displaying the correct information, however when I go to the actual sharepoint list, the values are not being displayed.

If(!IsBlank(ThisItem.ID), Value($"{ThisItem.ID}{Text(ThisItem.Created,"mmyy")}"))

I've deleted and re-added the data card multiple different times thinking that would resolve it, however I still cannot get it to display.
My SP List settings for that item, I've tried it as Single Line of Text as well as number, neither of them are displaying.

What am I missing to get the calculated data to show on my actual list and not only on my form?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JediWookie

First of all, a SharePoint calculated field does not work well within PowerApps and the calculation should be done in PowerApps and saved to a number field. That being said, if you change the schema of a SharePoint list, ie. (renaming, deleting or adding new columns), I strongly recommend save the changes in SharePoint, close the window and re-open it. Then go to PowerApps and delete the connector and re-import it.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JediWookie

First of all, a SharePoint calculated field does not work well within PowerApps and the calculation should be done in PowerApps and saved to a number field. That being said, if you change the schema of a SharePoint list, ie. (renaming, deleting or adding new columns), I strongly recommend saving the changes in SharePoint, closing the window and re-opening it and check to make sure the changes were made. Then go to PowerApps and delete the old SharePoint connector and re-import it back into PowerApps.

Was this reply helpful? Yes No
JediWookie 22 on at

Like (0)

Report

Hi, Just to confirm, my calculation is taking place in PowerApps form. inside both my view and edit forms, the correct calculated data is showing. However, it's not showing on my SP list, which is currently set to a number.

I've just cleared all of my cache (for the 5th time) and deleted the field on both edit/view, saved/published, cleared cache again, re-added calculation field and data displays on form, but it's still not showing on my list.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JediWookie

I wrote the first paragraph primarily for others to review as this is a common problem. The first place I would check to troubleshoot it to look at the Update property of the card containing that field and make sure it reflects the control inside the card. If the calculation is done using data from other cards, you could reproduce the calculation in the Update property of the card using the values from other controls in the form. For more suggestions, I would need to see the actual calculations and where the data comes from.

***** if you have changed the structure or the column names of the SharePoint list, you MUST refresh it in the browser before changing anything in PowerApps***** This may not hold for you but for anyone else reading this, don't ignore this step.

Was this reply helpful? Yes No
JediWookie 22 on at

Like (0)

Report

I give each item on my SP list a unique number that reflects the auto generated ID (from the SP list) and then add the Month and Year that the SP list item was created. So, item 112 created in July 22, would be 1120722

So the calculations are coming from two lists that are auto generated at the time the "new" form is submitted/saved.

On my SP list, I have created a new column called "TrackerID" which is set up as a number.
On my Powerapps form, in the Default Value - I have the formula above and it is displaying the correct number.

When I click on the items in my list and look at the forms, it's showing the value. But if I export my list or just viewing my list, the "TrackerID" column is coming over blank.

I'm new to this, if there is something specific you need a screenshot of just let me know I dont know what other data would be helpful.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JediWookie

The Id of a SharePoint list is not generated until the record is actually saved, so it doesn't exist when you are saving

Could you provide default value and name of the control inside the trackerID card and the text of the Update property of that card.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JediWookie

Could you provide default value text and name of the control inside the trackerID card and the text of the Update property of that card.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@JediWookie

Sorry, I read your comments more closely and revised the above post.

Was this reply helpful? Yes No
JediWookie 22 on at

Like (0)

Report

The ID/Created is set when the "new" form is submitted. When I look at my sharepoint list on a brand new item, I can see that it has the ID/Created by already set.

I'm not looking for the calculation to take place on my "new" form. Only on the "View" and "Edit" because at that point, the ID and created is already in place.

Was this reply helpful? Yes No
JediWookie 22 on at

Like (0)

Report

My calculation IS taking place in Powerapps, not Sharepoint. The value that is being calculated in PA is not displaying in the column on my SP list.

At this point, it's not a big issue I thought it would be helpful to have but it seems like it's more of a problem to have instead of just doing it manually like I have been doing.

Was this reply helpful? Yes No