Power Platform Community Forum Thread Details

Hi all, I have a gallery which shows months and number of days worked. I am attempting to lookup the days worked column from a table called 'Forecast' to see if a record exists for a given month, in which case the existing value should be used, else 0 (ready for patching). Unfortunately, only the first value of the Days worked column is retrieved (the lookup does correctly only return this value for the months in which the record exists.) I should add, the data source of the gallery is a different table just containing the list of months. Does anyone know how I can return the correct 'Days worked' values?

Thanks in advance.