Answered

Calculated field from Sharepoint list into Datatable

(0) Share

Report

Posted on by CP0822

Hi,

I have a calculated field in my SP list and I want to show this column in a datatable in PowerApps. The column is called "Trigger_time" but when I try to get the field in my table I didn't find it as a possible field to add

I know I could try using AddColumns and Collections/List but is there an easy way to pull this from SP List?

Thanks for your comments

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

leyburn19 2,157 on at

Like (1)

Report
Copy link

Link copied!

I don't think Calculated fields are an option here, mainly because they do not store data, they only show a result at run time. You should be able to build your own calculation field in the app that will achieve teh same result

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@CP0822

Yes, calculated columns will be available for your data table. However, I would consider using a Gallery if possible over a DataTable because the DataTable is NOT going to see your calculate as a Date properly and you will end up with a ISO representation of your Date rather than a formatted date. You can control this better in a Gallery.

If you are not seeing your calculated column, I would first make sure you are looking for its "Real" name. If the column has been renamed at any point, it will still retain its original name.

Go into your SharePoint list settings and click on the calculated column to edit it. Then look in the URL in the browser. The URL will end with field=something. something is the REAL name of the column.

That is what you will be looking for in the Edit Fields of the DataTable.

I hope this is helpful for you.

Was this reply helpful? Yes No
CP0822 66 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes

Thanks, actually I pulled the calculated field from the SP list at the end. Not sure why I couldn't see the column at the beginning but it happened just the thing you mentioned about the format and I solved this situation using this formula

DateAdd( DateTimeValue(ThisItem.Trigger_time),-TimeZoneOffset(),Minutes)

This is the result.

Thanks for your help

Was this reply helpful? Yes No