cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sahara22
Post Patron
Post Patron

Add hours to sharepoint list column

Hello, I have a flow that copies from and excel sheet then creates items in a sharepoint list. When it copies over the time, its 7 hours behind. 

 

I'm currently using this expression to copy the list of items from excel : item()?['ColumnName']. Can I add something to this expression to add 7 hours to the time?

 

 

Thank you,

3 REPLIES 3
Sahara22
Post Patron
Post Patron

tried the below and it didn't work..

 

 

formatDateTime(addHours(item()?('ColumnName'),+7),'MM/dd/yyyy HH:mm'))
Sahara22
Post Patron
Post Patron

Any idea's?

 

Sahara22
Post Patron
Post Patron

Hi, would it be better to change this format in power apps? 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,974)