Hi there
I'm new to Power Apps and hope someone can help me out here.
I'm working on a canvas app to record produce waste.
It is very straight forward, I connected to a SQL server and created a table in the dataverse where I have added sql columns.
My issue is that when when a user selects a crop like carrots, the harvest delivery drop down should filter down to carrot only deliveries.
In SQL I would use this:
select top 1000000 'HarvestLoad Waste' as [Type], hd.HarvestLoadKey as [Key], cr.CropKey as ParentKey, hd.DocketNo as [Name]
from HarvestLoad hd
join Planting PL on PL.PlantingKey = hd.PlantingKey
join Variety va on pl.VarietyKey = va.VarietyKey
join Block bl on bl.BlockKey = pl.BlockKey
join Farm fa on fa.FarmKey = bl.FarmKey
join Supplier su on su.SupplierKey = fa.SupplierKey
join Crop cr on cr.cropkey = va.cropkey
where su.Active = 1 and hd.DateTimeDelivered >= dateadd(week, -6, getdate())
order by hd.DocketNo desc
How would I go about it in Power Apps? Help please..
