Power Platform Community Forum Thread Details

Dear Powerapps users,

I'm using for the first time the new Table control, everything is pretty easy but formatting the date. I would like to use DateTimeFormat.ShortDate or "mm/dd/yyyy" but looks like is not possible, I don't see any property of the table that allow me to do that, the only could be FieldType that contains a "d", I tried with that one but no change whatsoever.

Datasource is a SharePoint List and those field are the one created automatically by SharePoint once you create a list, are not created by me.

Any idea how this could be solved?

Thank you

Roberto

Categories:

Power Apps Pro Dev & ISV

Ok I basically found the solution and I've to be honest the real hint has been given to me by ChatGPT even though after the hint I've to figure it out so many other things. Any way the result is the following, which is the desired one

You can't modify the formatting of a SharePoint table field created automatically by SharePoint (those standard fields that any SharePoint list has), so I created a collection and I using the AddColumns() function I could add a new field that as input take the existing one and changing the format, as shown below

<code>

   ClearCollect(cl_issue_project, 
     AddColumns(TPL_Internal_Project_Issues, 
       CreateDate, Text(Created, "dd/mm/yyyy"), ModifyDate, Text(Modified, "dd/mm/yyyy"), Person, Author.DisplayName
      )
    )

</code