Unanswered

Converting Sharepoint Item to insert in excel create table as a number

(0) Share

Report

Posted on by jacqdr

Hi,

Good day! I have a Sharepoint list item indicating the number of hours. I'm trying to create a flow wherein I will insert those hours in excel table. But the output in excel table shows in Data Format (8-Jan) instead of Number/Float (8.00). Is there a way to format the sharepoint list item to display it as a number instead of in date format (8-Jan) ?

Thank you.

All responses (3)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Converting Sharepoint Item to insert in excel create table as a number

@jacqdr Please do this step manually in excel file. its one time change and then it will automatically take it.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in
jacqdr 6 on at

Like (0)

Report

Re: Converting Sharepoint Item to insert in excel create table as a number

hi @Hardesh15 .. is there a way to do it in the flow? do i need to do it manually?
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Converting Sharepoint Item to insert in excel create table as a number

@jacqdr Please do format your excel column as number.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in