Power Platform Community Forum Thread Details

Dear community,

I am stucked in something. I want to create a budget template for HR where the manager will be able to asign an FTE for each month and employee of a determinate section . The attachment may clarify my objective.

The datasource is an Sql table where I have the fte, employee, section, etc. For showing the data I am using a gallery with text edit boxes, in the grid I am filtering in each month column a LookUp Formula like this : LookUp( '[dbo].[factftemonthly]'; And(Month(fecha)=1;Year(fecha)=yearBudget);fte) but that's not a good solution since obviously, I am still having a row for every month.

I am thinking of alternative solutions but I think they are very bizarre and I am sure that there is a simpler way to do it.

I would really appreciate some help ,

thank you very much in advance