Unanswered

Add a calendar

(0) Share

Report

Posted on by s44

691

Hello, I created a Gantt chart that displays different events depending on the time as you can see below (I put my project as an attachment, you will have to look at the screen "Screen2") :

All my events are stored in a SharePoint list called "Provider2".

Usine : Text type

DateArrivee : Date and Hour type

DateFin : Date and Hour type

Status : Choice type

I would like to add to the left of my diagram, a calendar so that when you click on a date, it displays the diagram with all the events corresponding to this date. But I can't seem to realize that at all.

I would like to have something like this :

Can you help me please ? Thanks in advance ! I've been stuck on it for several days 😞

--------------------------

In red, it's my gallery which contains all the hours.
In blue, it's my gallery which contains all my items.
In fushia, it's my gallery that displays all the columns for the hours.

lblIndicator_1 :

Fill : If(
 ThisItem.Status.Value="Not Started";
 White;
 ThisItem.Status.Value="Active";
 Orange;
 ThisItem.Status.Value="Delayed";
 Red;
 ThisItem.Status.Value="Completed";
 Green;
 Gray
 )



X : Value(
 DateDiff(
 Date(
 Year(ThisItem.DateFin);
 Month(ThisItem.DateFin);
 Day(ThisItem.DateFin)
 );
 ThisItem.DateFin; Hours
 ) 
)* (galBodyMonths_1.Width / 24)



Width : (Value(
 DateDiff(
 Date(
 Year(ThisItem.DateFin);
 Month(ThisItem.DateFin);
 Day(ThisItem.DateFin)
 );
 (ThisItem.DateFin); Hours
 )
) -
Value(
 DateDiff(
 Date(
 Year(ThisItem.DateArrivee);
 Month(ThisItem.DateArrivee);
 Day(ThisItem.DateArrivee)
 );
 ThisItem.DateArrivee; Hours
 ) 
) 
) +1 * (galBodyMonths_1.Width / 24)

Categories:

General Questions

AI Builder

Using Apps Using Formulas

Dataflows

Mixed Reality

Connectors

Gant Test (2).msapp

All responses (4)

Answers (0)

s44 691 on at

Like (0)

Report

Re: Add a calendar

Weird... I manage to import it myself :0
Ok thanks, I will try it!
StephaneLefevre 24 on at

Like (0)

Report
Re: Add a calendar

Your file cannot be used. It must be the .Zip file to import to PowerApps. I Tried to zip it, but impossible to import it anyway.
When you build the calendar from @mdevaney , the date is used as the Item. So, for your calendar gallery, the onSelect action can store in a variable the selected date:
On gallery onSelect:
Set(varSelectedDate;ThisItem.Value)
Once done, you can use it in your other galleries to select appropriated date / items

Hope this helps
s44 691 on at

Like (0)

Report

Re: Add a calendar

But on his tutorial the person does not explain how to make each date rectangle clickable to access the right diagram corresponding to the right date. 😞
StephaneLefevre 24 on at

Like (0)

Report

Re: Add a calendar

Here is an excellent post from @mdevaney explaining how to build a calendar.

Make A Calendar In Power Apps - Part 1 - Matthew Devaney

Hope this helps. If so, thank you to mark as Accepted and put a Thumb up...