question

PMD75-4917 avatar image
0 Votes"
PMD75-4917 asked DSPatrick answered

Power Automate / Flow - Excel data to SharePoint list

Hi !
Flow question for you all.

I’m trying to pull date data (3 cells) from Excel and update date columns (start date, End date, Review date) in SharePoint.

The line item has a primary identifier (ID) which is matched to the Item in SP, (so If ID = ID, true)

Here’s the problem. I’ve tried converting the date but the Flow fails, and I’ve tried multiple tweaks and changes but now the flow ”Succeeds” but the data isn’t updated!

What am I missing?
Could someone please explain how to convert Excel date into a format that SharePoint date column will accept.

Thanks to all.

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.