Answered

Daily reporting from a teams spreadsheet

(0) Share

Report

Posted on by MarkCoates

Hello,

I have a flow where my team fill in a form and input data, this is then recorded on a teams spreadsheet in the background.

I now wish to create a new flow where I can send selected people in the business a daily report with todays downtime, which will be picked up from the spreadsheet in teams.

I’m very basic with power automate, is there any good guides or videos that will show me how to do this?

All I want is todays inputs on a daily basis sent via an email.

This is as far as I can get with errors.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (3)

Sort by

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MarkCoates ,

Maybe you could try the following expressions:

formatDateTime(item()?['Date'], 'yyyy/MM/dd')
formatDateTime(utcNow(), 'yyyy/MM/dd')

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
MarkCoates 63 on at

Like (0)

Report
Copy link

Link copied!

Hi Charlie,

I get the following error message;

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@lessOrEquals(formatDateTime(item()?['Date'], 'yyyy/MM/dd'), formatDateTime(utcNow(), 'yyyy/MM/dd'))' failed: 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'."

My date columns:

2022-08-31 2022-08-31T00:00:00
2022-09-04 2022-09-04T22:17:48

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MarkCoates ,

It seems that there are null values in the data source.

In addition, maybe you could try the following expressions.

@and(not(equals(length(item()?['Date']), 0)),lessOrEquals(formatDateTime(item()?['Date'], 'yyyy/MM/dd'), formatDateTime(utcNow(), 'yyyy/MM/dd')))

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
MarkCoates 63 on at

Like (0)

Report
Copy link

Link copied!

Hi Charlie,

Got a report through on the test but it is sending everything on it rather than just data from today?

Any ideas? Maybe the lessorequals should be greaterorequals?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MarkCoates ,

Please try the following expressions:

@and(not(equals(length(item()?['Date']), 0)),equals(formatDateTime(item()?['Date'], 'yyyy/MM/dd'), formatDateTime(utcNow(), 'yyyy/MM/dd')))

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
MarkCoates 63 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
MarkCoates 63 on at

Like (0)

Report
Copy link

Link copied!

Hi Charlie,

Thank you very much, that is up and running!

Just another issue now, when I go to add a Create a HTML table and customise it, it automatically applies an "Apply to all" condition on it and i'm getting multiple e-mails or multiple tables in 1 e-mail?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MarkCoates ,

Maybe you could try to write the expression manually instead of using Dynamic content directly.

item()?['ColumnName']

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
MarkCoates 63 on at

Like (0)

Report
Copy link

Link copied!

Charlie - Thank you very much!

One final question (Hopefully!) You've been a really great help...

Is there a way to show just the dd/mm/yyyy in the table and remove all the seconds and minutes stuff?

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MarkCoates ,

Please try the following expressions.

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

Best Regards,

Charlie Choi

Was this reply helpful? Yes No