SharePoint - how to type a date in column

Question

Hello, I am working on an approval flow. I need to be able to type in a date (example 10/1/2024) in a month, day, year format. However, when I try to type a date, nothing appears. Can you advise what I am doing incorrectly?

Screenshot 2024-10-01 213759.png

date column.png

Answer 1

I apologize for the late reply.

But you seem to have forgotten to share images, and I can't see any.

Also, in response to the link not being clickable in the hyperlink columns:

The Hyperlink column type is clickable by default, but I have found this column presents challenges in Flow since it's not a simple field and requires both a URL and Description.

If the text of the URL displayed by your hyperlink class is correct. Column formatting can be done using Modern List and Text Columns. This is an easier way to do it.

That is, ditch the old hyperlink-type columns and instead have text-type columns that store URLs, and set the URLs to be clickable via column formatting.

1.Select your Column >Column Settings >Format this column >Advance mode.

Please use this JSON code:

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType":"a",
"txtContent": "@currentField",
"attributes": {
"target": "_blank",
"href": "@currentField"
 }
}

---

If the answer is helpful, please click"Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Deniselearning365,

Thank you for posting in this community.

I've noticed that you've set your dates to Friendly instead of Standard.

The standard date type displays the dates in the form we are used to seeing: Day/Month/Year (or Month/Day/Year, depending on the region you live in).

The Friendly date type displays the dates you often see on social media: yesterday, tomorrow, October 18 etc.

But even if you format the date incorrectly, there should still be content. I suggest you delete this column and recreate it to avoid other problems. Remember to empty your browser cache and check again.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hello, this did not solve the problem. Any other suggestions would be appreciated.

Thanks so much.

Denise

Answer 4

Hello @Ling Zhou_MSFT

Yes the issue has been resolved. However, I still have an issue with a hyperlink.

I have an approval flow that is triggered when receiving an Outlook email in my invoice folder. The email has an attachment and is forwarded to the correct contact.

However, when the approval appears in Microsoft list, the hyperlink doesn't work. Does the link format need to be changed for Sharepoint List?

Answer 5

@Ling Zhou_MSFT Hello, I hope all is well. Unfortunately, the firewall my company has won’t allow me to share the flow so I can only attach pictures.

However, the column that should have a clickable link doesn’t work.

Any details would be greatly appreciate.

denise