web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Adding a row to a goog...

Power Automate - Building Flows

Answered

Adding a row to a google sheet

(0) Share

Report

Report

Posted on by Binskit

29

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

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Adding a row to a google sheet

@Binskit you can add it as expression see

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Re: Adding a row to a google sheeate

Hi @Binskit ,

You could Create the flow as below:

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.

Was this reply helpful? Yes No
Binskit 29 on at

Like (0)

Report

Re: Adding a row to a google sheeate

I get this error:

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

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Adding a row to a google sheeate

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 560 Super User 2025 Season 2

#2

Tomac 347 Moderator

#3

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans