Insert a datetime field with Power automate

(0) Share

Report

Posted on by Julien_Admin

Hi everyone,

I want to insert value with Power automate from Excel file, but when I have a field with dateTime Type, It will be insert with MM/DD/YYYY

I used the formatdate expression but it doesn't give me the best answer.

Have you any suggestion please ?

Best regards,

Julien,

I have the same question (0)

All responses (6)

Answers (4)

Sort by

Verified answer

Mohamed GRAIB 2,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Julien,

Have you the action List rows present in table ? If yes, you must configure this action before the utilization of formatdate expression.

Please mark the answer as verified if that's resolve your problem

Was this reply helpful? Yes No
Verified answer

Abdul Wahab 12,119 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Julien_Admin,

Use the Date time format while striving records from excel, It will give your desired results.

Was this reply helpful? Yes No
Julien_Admin 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Abdul Wahab and Mohamed GRAIB

I have another issue how to mapp the lookup field with the Excel rows.

Have you any suggestion please ?

Was this reply helpful? Yes No
Verified answer

Mohamed GRAIB 2,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

You must add an action

List rows as shown in the figure below :

You must choose the table name of your lookup.

Then when you mapp, you must add the plural name of your table (your column)

You can also initialize a variable and utilize it in your action.

You can follow this link

https://powerusers.microsoft.com/t5/Building-Flows/How-to-map-lookup-field-in-update-record-action-in-flows/td-p/312182

Please mark the answer as verified if that's helpful for you.

Was this reply helpful? Yes No
Julien_Admin 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Mohamed

I have implemented this solution, but, I had an error when the row in my Excel table does not contain data.

I must implment another solution or use an expression.

Was this reply helpful? Yes No
Verified answer

Mohamed GRAIB 2,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

In this case,

I suggest this solution,

You must initialise a variable for your lookup Field and define your variable.

After that, try to use this expression in your lookup field

if(empty(your variable),null,concat('/plural table name(',your variable))'))

Just when you add your variable add it dynamically, there many '' that will be added here.

Please mark the answer as verified if that's resolve your problem.

Was this reply helpful? Yes No