Hello thank you first of all. I want to change it so that it sends an e-mail if today's date is the same as or past the DateOfBirth. What change needs to be made?
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(addDays('1899-12-30', int(item()?['AMC End Date']), 'dd/mm/yyyy'), formatDateTime(utcNow(), 'dd/mm/yyyy'))' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. I am facing such kind of issue.Do you have any solution for it???
Hi can you show demo of how to filter specific column to display previous day to current day? For example filter display from previous Monday to current Monday?
Look for addDays() expression in PowerAutomate. If you looking for a week's data then use utcNow() for todays Date and addDays(utcNow(), -7) will give you a week before date. Thanks
How to send the filtered excel date output data in an email. Can you cover the same in separate tutorial. Majorly want to know the date formatting issues in html table.
I also want to know the same thing. how to send an Excel date output in an email. I tried a lot of tricks but all failed. I am not able to get the date column in any other format other than UTC (default format). could you please show us how to do how to format the date column in (MM/DD/YY) format and then use that in an email
Hello @abm, i want to capture both Date and time, when I put filter I am getting output as 2021-06-25T00:00:00.000Z, how do I capture time also, please suggest
Hello sir, thanks for the informative videos, your videos help a lot, really appreciate your efforts. I have a query, if you could reply or prepare a video on that. I have an Excel table in which there is a date column and I want that table to be shared in an email. the issue am facing is with the date column which is not getting formatted and giving the date values in UTC format only. could you please advise how to resolve this?
Hi Andy You need to use the expression formatDateTime(addDays(utcNow(), -60), 'yyyy-MM-dd') This will give minus 60 days from todays date. Use that as the filter. Thanks
Hi, I have columns like 1, 2, 3 till 31, these are dates. I used composed action to extract todays date in a variable. after list rows , I want to check if a value is present in todays days column and get the whole row.
Hi Thanks for the example. You can do this by pushing all the values into an array then filter by the index. If you still need help let me know. I might do a video about this. Thanks
Hi hope you can help i get this message when i try your method. My date column is called DiarisedDate.The execution of template action 'Filter_array• failed: The evaluation of 'query action 'where' expression int(ltemO? ['DiarisedDate']), 'dd/MM/ywy'), '12/11/2023)' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. Here is my "where" : [ DiarisedDate ' dd/MM/yyyy ' ) , ' 1899-12-30 ' , ' 12/11/2023 ' ) " any help would be great
Hi @texbriz Check the Excel action step 'List rows present in a table' Click the show advanced options. Then select the DateTime Format to ISO 8601 Thanks
Hi Vjaindra Thanks for watching my video. Please post your question here? If not post your query to Power Automate Community and let me know. powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks Your for reply , Actually I have created one Feedback survey form and collecting responses. Now to send that response excel with desire Pivot, I have design power process. But, whenever response is going to the management in the email which going completed response data from the begging .I am enable to filter by date or regions and send only specified date period data to management with desire Pivot table and require regions data by using any filter function by period and send only incremental periodic data in the email Please let me know how I can do this . Thanks Vjaindra Sonawwane
Hi I need to see bit more info about this. Could you please post this under Power Automate Community. Please tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows Thanks
Brother, THANK YOU THANK YOU THANK YOU THANK YOU! - I spent over 4 hours trying to find a solution to my issue and you saved my skin. THank you!!!!
Hi
Glad to hear that it helped. Thanks for the support and comment.
Hello thank you first of all. I want to change it so that it sends an e-mail if today's date is the same as or past the DateOfBirth. What change needs to be made?
Great video. My question is how to modify this such as the Reminder date equal today's date?
Hi
Use expression utcNow() to get todays date. Use format expression to convert to 'yyyy-MM-dd' before you doing the comparison.
Thanks
So what would the full expression look like as my column is called DiarisedDate?
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(addDays('1899-12-30', int(item()?['AMC End Date']), 'dd/mm/yyyy'), formatDateTime(utcNow(), 'dd/mm/yyyy'))' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
I am facing such kind of issue.Do you have any solution for it???
Hi can you show demo of how to filter specific column to display previous day to current day? For example filter display from previous Monday to current Monday?
Look for addDays() expression in PowerAutomate. If you looking for a week's data then use utcNow() for todays Date and addDays(utcNow(), -7) will give you a week before date.
Thanks
@@abm4975 do you have any vids that similar to that issue? I tried many expression but it still having error.
Connect me via teams. I will have a look. You can see my contact details from my channel about section.
Thanks
whats your team channel name then? or discord?
www.youtube.com/@abm4975/about
About > Scroll down > Details > For business inquiries: View email address. Click here
How to send the filtered excel date output data in an email. Can you cover the same in separate tutorial. Majorly want to know the date formatting issues in html table.
I also want to know the same thing. how to send an Excel date output in an email. I tried a lot of tricks but all failed. I am not able to get the date column in any other format other than UTC (default format). could you please show us how to do how to format the date column in (MM/DD/YY) format and then use that in an email
Hi
Contact me via my channel about section. You can get my email and connect me via teams. I will have a look.
Thanks
Can you show demo of how to filter the excel dates by month and send email in power automate?
Hi Janice
I have made a video based on your request. Please have a look and comment.
th-cam.com/video/cRodk5ayAso/w-d-xo.html
Thanks
Hi, I want to do something similar to this, but based on that date column, how can I use that date to send an email, can you explain please
Hi
Please have a look at this.
th-cam.com/video/puR70yQMJKE/w-d-xo.html
Thanks
Hello @abm, i want to capture both Date and time, when I put filter I am getting output as 2021-06-25T00:00:00.000Z, how do I capture time also, please suggest
Please see this post
powerusers.microsoft.com/t5/Building-Flows/Convert-Excel-date-value/m-p/968528#M135553
Hello sir, thanks for the informative videos, your videos help a lot, really appreciate your efforts. I have a query, if you could reply or prepare a video on that. I have an Excel table in which there is a date column and I want that table to be shared in an email. the issue am facing is with the date column which is not getting formatted and giving the date values in UTC format only. could you please advise how to resolve this?
Hi
I need to look into this. I could offer a screenshare help for this. Check my channel about section. Connect me via Teams.
Thanks
how can i filter by iqual or les than 60 days before today?
Hi Andy
You need to use the expression
formatDateTime(addDays(utcNow(), -60), 'yyyy-MM-dd')
This will give minus 60 days from todays date. Use that as the filter.
Thanks
Hi, I have columns like 1, 2, 3 till 31, these are dates. I used composed action to extract todays date in a variable. after list rows , I want to check if a value is present in todays days column and get the whole row.
Table
Name 1 2 3 4
ABC M READ M M
RSD A A READ A
XYZ A A A A
I want to check if today's date column contains value READ if yes output Name.
Hi
Thanks for the example. You can do this by pushing all the values into an array then filter by the index. If you still need help let me know. I might do a video about this.
Thanks
Hi hope you can help i get this message when i try your method. My date column is called DiarisedDate.The execution of template action
'Filter_array• failed: The evaluation of
'query action 'where' expression
int(ltemO?
['DiarisedDate']), 'dd/MM/ywy'),
'12/11/2023)' failed: 'The template
language function 'int' was invoked with a
parameter that is not valid. The value
cannot be converted to the target type.'.
Here is my
"where" :
[ DiarisedDate
' dd/MM/yyyy ' ) ,
' 1899-12-30 ' ,
' 12/11/2023 ' ) "
any help would be great
Hi @texbriz
Check the Excel action step 'List rows present in a table' Click the show advanced options. Then select the DateTime Format to ISO 8601
Thanks
Is it possible to filter data from Excel based on submitted time?
Please see this
powerusers.microsoft.com/t5/Building-Flows/Convert-Excel-date-value/m-p/968528#M135553
Very good ..i have some more query on date filtering.........possible to talk ??
Hi Vjaindra
Thanks for watching my video. Please post your question here? If not post your query to Power Automate Community and let me know.
powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks Your for reply ,
Actually I have created one Feedback survey form and collecting responses.
Now to send that response excel with desire Pivot, I have design power process.
But, whenever response is going to the management in the email which going completed response data from the begging .I am enable to filter by date or regions and send only specified date period data to management with desire Pivot table and require regions data by using any filter function by period and send only incremental periodic data in the email
Please let me know how I can do this .
Thanks
Vjaindra Sonawwane
Hi
I need to see bit more info about this. Could you please post this under Power Automate Community. Please tag me as @abm. I will have a look.
powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks
@@abm4975 Hi Dear,
I have posted a query in the forum and marked you as @abm.
I am struggling to put filter with email name and send email
Could you please post the community link here? I will have a look.
Thanks
What the 1899-12-30 does in the expression?
It works out the Excel Date Integer to correct readable format of a date as in dd-MM-yyyy format.
run flow condition end date should be greater than start date in Forms
Hi Abhijith
Could you please explain bit more about this? Do you need help in this? Please let me know.
Thanks