compare list A Element (multi-selection) with list B (column) and show in Gallery

(0) Share

Report

Posted on by mrn3rv0us

Hi Guys

I am trying to compare two lists.

There is a list of rooms, each room contains different tasks that are assigned via a selection in the sharepoint list (multi selection possible).

The list Task contains all possible tasks with description.

I want to enter the room in an input field and list all necessary tasks in a gallery.
Is there a way to filter the room in "Room List" and then compare the contained tasks with "Task List" and display them if they match?

I hope you can help me

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @mrn3rv0us,

Do you want to filter the Task list based on the room input within the TextInput?

Could you please tell me that if the Task in RoomList is a LookUp field or Choice filed?

Was this reply helpful? Yes No
Verified answer

mrn3rv0us 9 on at

Like (0)

Report
Hi @v-qiaqi-msft

Exactly, I have now replaced the text field with a scanner field. For the scans I have the QR code with value: "Room 1", "Room 2" and "Room 3".

For a scan, I always get only one match.
From the matched room, I now want to compare the Task with the TaskList and display the matched Task on a gallery.

The Task column is a selection field.

This is my first solution

Scan Field
//Temporary variable for scanned QR- code Set(tmpScan;Self.Value);; //filters the room and creates a collection "roomCol", which contains all tasks of the room ClearCollect(roomCol;Ungroup(Filter(RoomList;Room = tmpScan);"Task"));;

Gallery
//Filters TaskList with the Collection values Filter(TaskList; Task in roomCol.Value)

However, only every second scan currently works.

Was this reply helpful? Yes No