Hi Tom,

Can you please check attached oml and let me know by using aggregate,I want to populate time slot based on onchage of food type.I have added client variable bound to form to reach aggregate filter,but can not see .

Hi Tom,

Thank you so much for the suggestion of one way But as you said earlier to try aggregates ,I want to try with aggregates as with food type selected it should return time from table.

I have tried but retuening multiple record list as aggregate output how to assign and process further not getting,Can you please check and provide your suggestion.

Thanks you.

Actually 

Hello Ujwwala,

If you want to try aggregates don't you need an aggregate with times? 

In my eyes what you need to do:

Create a table TimeforFood with the following fields:

-Time

-PreferredFoodtypeId

Then add the desired times and the right preferredFoodTypeId to that table for example (9.00, breakfast)

After this you can start using this aggregate in your screen, you will need to use a filter in your aggregate so that it only shows the right times. I posted an updated oml below, you just need to add times to this table first to make it useable.

Hi Nick,

Thank you,

I do not want to add records separately in the table but while booking slot by admin the data should be entered in timefood table so I have craeted flow but it is not updating.after that please let me know how to assign the filtered  records(I  want to add restaurant Id also)  which will be returned by aggregate to map to Time List

Hi Chris,

Yes I have gone through the training Will practice more.