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..