Unanswered

Get sharepoint list entries in a gallery, based on created date of another list

(0) Share

Report

Posted on by KKok

Hi all,

First the situation: 2 sharepoint lists (1 is a daily checklist, the 2nd is a list of multiple reports as a result (or addon if you will) on the checklist.

Im working on a canvas app where both lists are connected, collegea's fill in the daily checklist (list 1) and can add multiple reports (list 2).

Now i want a screen in the app with 1 Viewform and 1 gallery, where they can view the details of a checklist (selected from the maingallery) in the viewform and i would like it that on that same screen, in the gallery, they get an overview of the reports (2nd sharepoint list) where made on that same date.

I am guessing i need to use the Lookup function, but am at a loss how to populate it.

To get from the main gallery to the details screen im using this Onselect command on the button:

Navigate(Details1,ScreenTransition.None,{info:'Linker overzicht'.Selected.ID}).

The info part is because i want them to be able to press only on the > button and not on the gallery itself (as it is with default gallery layout).

Screenshot 1: main gallery (from here, on the left they can select a checklist to view the details of)

Screenshot 2: The details screen, on the left they get the info from a selected checklist, on the right i would like to see the entries from List 2 which where created on the same date as the selected checklist.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

jready 10 on at

Like (0)

Report
Copy link

Link copied!

If I understand everything correctly, I think you need to filter list 2 where details screen created date is equal to List 2 created date. Maybe something like the code below.

Filter('List 2', DetailsScreenCreatedDate.Value=List 2 CreatedDate.Value)

Was this reply helpful? Yes No
KKok 2 on at

Like (0)

Report
Copy link

Link copied!

@jready Thank you for your help, unfortunatly it was not what i was looking for.
It gave me an idea though to use the Filter function and Created columns which contain the dates. I found the correct formula:
In the Onselect field of the navigation button in the Main gallery i created 2 variables which take the ID and the Created column from the selected sharepoint list entry (list 1).
Navigate('Details checklist',ScreenTransition.None,{info:'Linker overzicht'.Selected.ID, info2: 'Linker overzicht'.Selected.Created})

Then in the "view screen" i let the viewform take the selected list entry from the ID variable. Nothing fancy there:
LookUp(''List1',ID=info)

On the gallery (view screen, right side) i let it filter the entries from List 2 based on the Created column/variable of the selected entry of List 1, for which i had to convert it to Text and get rid of the timestamp.
Filter('List2', Text(Created,"[$-en-US]mm-dd-yyyy") = Text(info2,"[$-en-US]mm-dd-yyyy"))

So now they get the information of the selected checklist of List1 on the left and on the right they get a gallery overview of the entries placed on that same date in List2

Was this reply helpful? Yes No