10
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,
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.
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.
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
Please mark the answer as verified if that's helpful for you.
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 ?
Hi Julien_Admin,
Use the Date time format while striving records from excel, It will give your desired results.
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
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
