cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CP0822
Helper I
Helper I

Calculated field from Sharepoint list into Datatable

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

 

CP0822_0-1610741883601.png

CP0822_1-1610741912781.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User III
Super User III

@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.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

3 REPLIES 3
leyburn19
Memorable Member
Memorable Member

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

RandyHayes
Super User III
Super User III

@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.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

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)

 

CP0822_0-1611251020094.png

 

 

 

This is the result. 

 

Thanks for your help

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (35,561)