we're building an employee onboarding form, upon completion we want our flow to create an Employee ID using the onboarding list ID + dddmm of the employee's birthdate.
Employee birthdate 16/08/1984 - becomes 1608
So far we can create the ID with the full birthdate, but we would like to exclude the year from the employee ID.
Appreciate your support.
You can try the formula -
For more details see https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Thanks a lot for your reply.
Please excuse my layman knowledge with flow and syntax.
Where do I exactly added this formula in, if my variable's name is Birthdate
I tried the expression, but didn't let me add it. I also tried composing it but won't work either.
In the EmployeeID, in the composed string 'U[ID][BirthDate]' you need to replace the [BirthDate] with a formatDateTime([BirthDate],'dd/MM') expression.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.