Hi all,
I've created a nice looking simple gantt chart in Power Apps to have an overview of our firm's projects. I've followed this great video and it's working well. Data is a SP list in my case.
I've got two issues:
- It doesn't work well for projects which started before this year, 2022 - I'd like them to be displayed like starting on 1.1.2022 with End date coming from the SP list. I have the following formula in the width property of the label placed in a gallery:
If((Value(EndDays.Text) - Value(StartDays.Text)) * GanttProjects.Width / 365 > DateDiff(_StartDate, _EndDate), (Value(EndDays.Text) - 0) * GanttProjects.Width / 365,(Value(EndDays.Text) - Value(StartDays.Text)) * GanttProjects.Width /365)​where EndDays.Text is DateDiff(Date(2022,1,1), DateValue(_EndDate.Text))+1
_EndDate.Text is simple the End Date from the SP list
where StartDays.Text is DateDiff(Date(2022,1,1), DateValue(_StartDate.Text))+1
_StartDate.Text is simple the Start Date from the SP list
But for some of the projects in the gallery this doesn't work. Is there a way how to say that if they started before 1.1.2022 to make them appear like starting there and then just put the End Date to the correct position?
- Second one might be easier - I have a combobox which should filter the items in the gallery based on the Geographic Impact field. That field is a multi-choice column in SP list. User can only select one item in the combobox.
If he selects global, he'll see all projects with Geographic Impact being global, but for those items where there is more items selected, including Global, they'll not appear - so the item can have both Global and Europe in the Geographic Impact column and that will not appear. I have the following formula for that, any chance this can be improved?
(Concat(
'Geographic impact',
Value,","
) in GeographicImpactCombobox.Selected.Value || GeographicImpactCombobox.Selected.Value = Blank())​


Report
All responses (
Answers (