Friday, January 31, 2020

Read Date from Excel in MS Flows


Introduction:
When we read a date from Excel using MS flows, the date is in text format.

The date in the Excel is 18/3 but the one as per MS flow is 43908

Solution:
The work around here is
addDays('1900-01-01T00:00:00Z',sub(int(items('For_all_excel_records')?['Due Date']),2))

Output:


No comments:

Post a Comment

Close Quote When DocuSign Envelope is Completed Using Power Automate

  Introduction: When your CRM and DocuSign are not connected, yet you wish to automate Closing Quote and saving your file in SharePoint, yo...