Date is calculated column on given point in sharepoint there its showing write value but in gallery not displaying please anyone can help

(0) Share

Report

Posted on by mehulpurohit

After date its showing some extra digits

Categories:

Building Power Apps

issue.jpg

I have the same question (0)

All responses (34)

Answers (2)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @mehulpurohit ,

SharePoint calculated columns simply do not "play well" with Power Apps. Do the calculation in Power Apps and see if that works for you.

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
mehulpurohit 64 on at

Like (0)

Report

@WarrenBelz can you suggest some formula remove that last text from date

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Would this work
Left(LabelDateField.Text,Find(":",LabelDateField.Text)-4)

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

Like (0)

Report

@mehulpurohit ,

Firstly, you need to get away from the Label showing the calculated field and address the List field directly. What exactly are you trying to display and is the field data only or date/time.

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

Like (0)

Report

@mehulpurohit ,

Firstly, you need to get away from the Label showing the calculated field and address the List field directly. What exactly are you trying to display and is the field date only or date/time.

Was this reply helpful? Yes No
mehulpurohit 64 on at

Like (0)

Report

Text(ThisItem.next) gives 2022-12-30T08:00:00Z where next is calculted date in sharepoint list i used Text(ThisItem..next, "[$-en-US]dd-mmm-yyyy") its showing this formula uses scope not supported for this evaluation

Was this reply helpful? Yes No
mehulpurohit 64 on at

Like (0)

Report

@Corissandageri Text(ThisItem.next) gives 2022-12-30T08:00:00Z where next is calculted date in sharepoint list i used Text(ThisItem..next, "[$-en-US]dd-mmm-yyyy") its showing this formula uses scope not supported for this evaluation

Was this reply helpful? Yes No
mehulpurohit 64 on at

Like (0)

Report

@WarrenBelz Text(ThisItem.next) gives 2022-12-30T08:00:00Z where next is calculted date in sharepoint list i used Text(ThisItem..next, "[$-en-US]dd-mmm-yyyy") its showing this formula uses scope not supported for this evaluation

Was this reply helpful? Yes No
mehulpurohit 64 on at

Like (0)

Report

@Corissandageri this will not work as it is date type not text

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

Like (1)

Report

@mehulpurohit ,

What I am trying to establish is the actual date field name (not the calculated column) in SharePoint that the calculated field is based on. As I mentioned calculated fields in SharePoint simply do not work consistently with Power Apps.

Was this reply helpful? Yes No