Thank you very much. I am trying to copy data from 4 columns into a new spreadsheet, all of which is filtered to today’s date and then transfer over the data from the 4 columns only after the filter was applied. When I do it just now, via Send Keys{Ctrl,Shift,Down} and then remember selection before Launch and write to the new spreadsheet. I get only everything from all 4 columns. 1000s of rows when each day I run the reportit should be 10-30 rows only if it’s today’s date in those rows. I am hoping your information will put an end to these issues I am having. Thank you
I am trying to do a filter with postcode that is like 223344 but unable to use the Equal To (=) operator in the filter data table option. It takes it as a string but returns nothing as it treats the stored values in the same column as numeric value. How to resolve this?
If this method is not working try using C# code in .Net Script action of Power Automate Desktop. I have a video on my channel. That can give you some idea to which way to proceed
Make a video on if my excel file contains dynamic data which change everytime there is no frequency for a day bot should trigger when new data added to that excel is it possible?
Thank you very much. I am trying to copy data from 4 columns into a new spreadsheet, all of which is filtered to today’s date and then transfer over the data from the 4 columns only after the filter was applied. When I do it just now, via Send Keys{Ctrl,Shift,Down} and then remember selection before Launch and write to the new spreadsheet. I get only everything from all 4 columns. 1000s of rows when each day I run the reportit should be 10-30 rows only if it’s today’s date in those rows.
I am hoping your information will put an end to these issues I am having. Thank you
ua-cam.com/video/4NiyLNO6YcU/v-deo.html
I am trying to do a filter with postcode that is like 223344 but unable to use the Equal To (=) operator in the filter data table option. It takes it as a string but returns nothing as it treats the stored values in the same column as numeric value.
How to resolve this?
If this method is not working try using C# code in .Net Script action of Power Automate Desktop. I have a video on my channel. That can give you some idea to which way to proceed
How to filter DT with multiple values using single condition
Make a video on if my excel file contains dynamic data which change everytime there is no frequency for a day bot should trigger when new data added to that excel is it possible?
Yes it's possible using cloud flow trigger
Hi sir make a video on different triggers for sharepoint onedrive in power automate how to use it make a tutorial on it
What version you are using ?
It's 2.45