cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Adding a row to a google sheet

I am using an email trigger to add a row to a google sheet.

The first column in the google sheet is date field.

At the moment the flow picks up the received date and time using the "Received time" dynamic content.

I wanto only add the date coming from the received time but i cant get the syntax to work.Screen Shot 2020-10-04 at 8.22.31 am.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @Binskit ,

 

You could Create the flow as below:

1.png

formatDateTime(triggerOutputs()?['body/receivedDateTime'],'yyyy-MM-dd')

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

@Binskit  you can add it  as expression see

 

int.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Community Support
Community Support

Hi @Binskit ,

 

You could Create the flow as below:

1.png

formatDateTime(triggerOutputs()?['body/receivedDateTime'],'yyyy-MM-dd')

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

I get this error:

 

"One or more fields provided is of type 'Null', a different type is expected."

Highlighted

Hi @Binskit ,

 

Could you please share the screenshot of the configuration of the flow and the run history of the flow so we could better understand the issue and provide the proper workaround?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,916)