Display the correct item of a SharePoint list based on date

(0) Share

Report

Posted on by Hii_iii

691

Hello,
I'm creating a schedule on Power Apps that displays the time of different events from a SharePoint list.

My Power Apps schedule:

My Sharepoint list:

On the left of the screen, in front of each line of the planning, I would like to display all the factories (i.e "Usine" in my SP list) which are concerned by the event indicated on the planning. For example on the first line, we see that there is an event Lundi (i.e Monday in english) and Mardi (i.e Thuesday in english). So, we should display "d" and "e" in front of this line on the left.

I want the items of "Usine" here :

However, I can't manage to do this. Could you help me please :(? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@s44

What is the Items property of your gallery? The data for Usine should be provided to the gallery in that formula.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Is this :
@RandyHayes
Item of Gallery4 : Filter(Fournisseur; DateArrivee <= DateValue(Label4.Text) And EndTime >= DateValue(Label4.Text))

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@s44

Very good. The Usine column would be available to you.

Where exactly in your gallery do you want the Usine value to appear? In front of each Date or Time or to the very far left of the entire row?

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

@RandyHayes Thank you for your quick response, I would like to display the value of Usine here:
All to the left in front of the events 🙂

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@s44

All good except that you are nesting this gallery (Gallery4) in another Gallery (Gallery2). It is in Gallery 2 that you are asking to have the values displayed.

So, what is the Items property of Gallery2 ?

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Gallery2 is this : @RandyHayes
On the left there is no gallery :c

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@s44

So, gather your data at the outer gallery level instead of individually inside of it.

Change your Gallery2 Items formula to the following:

ForAll( Sequence(If(DateDiff(varVideoFirstDayView; DateAdd(varVideoMonth; 1; Months); Days)>35; 42; 35)); With({_date: DateAdd(varVideoFirstDayView; Value; Days)}; {Value: Value; Items: Filter(Fournisseur; DateArrivee <= _date && EndTime >= _date) } )

Change your Gallery4 Items property to: ThisItem.Items

Put a label in your Gallery 2 (to the left where you want it) and put the following formula:

Concat(Distinct(ThisItem.Items; Usine); Result & ";")

This should provide what you are looking for.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

I have this error message when I change Gallery4 Items property 😞 : @RandyHayes

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

@RandyHayes

Ohh, I think there's been a misunderstanding. :0
My gallery2 ends where is a red line. So there is no gallery on the left, where I want to display the Usine values

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@s44

That is not an error message. That is a normal message in the formula editor. The Editor is not able to provide information on scoped data (anything with ThisItem). This is completely normal and not an issue.

As for the placement. You are going to need to move your nested Gallery4 over to the right in order to provide a space for your label. This was a given in that you want to have such a column in your gallery.

So, move that gallery over to the right and the header label as well and then add the new label for the Usine value to be shown.

Was this reply helpful? Yes No