Filtered table as a source for block

Hi Honeycode Community,

I'm having a trouble regarding the source of a block, and will get the values from there.
Formula that I used FILTER(Inventory,"$[USER]=Inventory[User] AND Inventory[Date]=$[Date]-1") in block,
I want the data to be filtered and retrieve the rows. as of now i can only get the data of the first row and in the block source it returns me a warning.
image

Hi @John-ce1c,

Thanks for your post and screenshot here! :slight_smile:

If you wish to retrieve and display data of multiple rows, you will want to create a list object and enter your filter formula in the source of that list.

Blocks can display data of a single row, so that is why the message you're seeing states to update the formula to return a particular row.

Here's a good article by @LoriA that explains the difference between lists and blocks:

Let us know if that helps and if you have any other questions on this. :honey_pot: :honeybee: