cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luvagoldenk9
Helper I
Helper I

Format Date on Second Record Read into Flow

Hello!

 

I have a power automate that is triggered when a new Audit record is added to a Share Point Request list. That record contains the  ID of the parent record that it is associated with:

 ID (auto assigned by Share Point)ID of the Parent
Share Point List Audit158
Share Point List Summary8 

 

The Audit record is read first and then the ID of the Parent is used to read the Summary record. The flow is formatting an email and needs to format the Summary record Created (only want the date portion, not the time). When formatting the email, the Summary record 'Created' does not show up in the Dynamic content to select.

 

After the read of the Summary record, I tried to insert an Initialize Variable (and then was going to do substring to extract only the date portion):

Power App Error.jpg

The flow errors with:

 

Flow save failed with code 'InvalidVariableInitialization' and message 'The variable action 'Initialize_variable' of type 'InitializeVariable' cannot be nested in an action of type 'Apply_to_each'.'.

 

Any thoughts on how to get the Create (date portion only) from a second record that is read in a flow?

 

Thank you in advance for your help!

2 REPLIES 2
mahoneypat
Dual Super User
Dual Super User

You can initialize your variable before the Apply to Each and then use Set variable to change it to the value from the current item with each iteration.  Also, you can format your Created datetime within the Apply To Each using item() in an Expression.

 

For example,

formatDateTime(item()?['Created'], 'MM/dd/yyyy')
 
Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi Pat!

 

Thank you for the quick response.

 

I had to initialize an array variable and saved the formatted Create date per your format DateTime guidance.

 
When the array variable for Create date is referenced in the email, the date displays as:
 
["02/15/2021"]
 
Do you know if there is a way to clean up the array variable (remove the leading [" and trailing "]) so that only the date 02/15/2021 is displayed? Thank you for your help!
 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,165)