cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Attempting to filter a list rows present in a table

I am trying to filter a list rows present in a table.

 

The table in in Teams as a document in the document library.  It has a table set.  The data is all there.

The fields are Date, Name, Response.  

I want to filter it so that I only get back the rows that match todays date (and ignore any other row that has any other date)

 

I'm not sure if I use the Advance options (such as Filter Query) or do I add a Filter Array function (I have tried that, it doesn't work).

 

Currently for today's date I am using an expression 

formatDateTime(convertFromUtc(utcNow(), 'E. Australia Standard Time'), 'dd/MM/yyyy')
 
Any help would be greatly appreciated.  
The resulting output is turned into HTML (apply to each, Select, Create HTML Table) and pumped into send an Email (v2).  This works successfully, but puts ALL rows into the email.
3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you please share the screenshot of your flow and the run history of the flow so we could better understand your issue and provide the 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.

v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Does your issue still exists?

 

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.

Anonymous
Not applicable

The problem does still exist.  I have worked around it by making the spreadsheet temporary and using Update a row rather than Insert a Row.  But that means I have no persistent data.  I will post up some images later today of the original flows that don't work.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,046)