comparing table to table not possible, filter issue.

(0) Share

Report

Posted on by PonceletSeba

Dear PowerApps Community,

Ran into following issue whilst building a canvas app:

Trying to compare a multiple selection combobox to a multiple selection sharepoint column.

For example:

- combobox input "OP1" or "OP2" or "OP3" or "OP4"
- sharepoint list input "OP1" and "OP3"

When I select "OP1" AND "OP3" in the combobox I would like the sharepoint list items with "OP1" and "OP3"

When I select "OP1" or I select "OP3" in the combobox I would like the sharepoint list items with "OP1" AND "OP3", and Items with "OP1" OR "OP3"

Code I was using to try this:

(IsBlank(cboPlanning.SelectedItems.Value) || cboPlanning.SelectedItems.Value = JOB_Assigned_To.Value );

The issue with this is that a table apparently cannot be compared to another table?

Any workarounds for this?

Kind regards,

Sébastien

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

gcmfaizan 1,022 on at

Like
a
(1)

Report
Copy link

Link copied!
@PonceletSeba try to amends this formula as per your need:
Filter( YourSharePointList, CountRows( Filter( cboPlanning.SelectedItems, Job_Assigned_To.Value in YourSharePointListColumn ) ) > 0 )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like
a
(0)

Report
Copy link

Link copied!
Tried to implement it in following way:

Filter( CountRows( Filter(JOB_Assigned_To.Value;cboPlanning.SelectedItems in JOB_Assigned_To))>0 )
Sadly this didnt work.

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like
a
(0)

Report
Copy link

Link copied!
Here is the full code i'm trying to use:

//If( // varExtratasks = false; Sort( Sort( Filter( AddColumns( CollectionAllUnitsJobList; "IDcopy"; Text('Id (ID)') ); CountRows( Filter(JOBIO_DATA; cboPlanning.Selected.Value in JOB_Assigned_To) ) > 0 ); JOB_PRIORITY.Value; SortOrder.Ascending ); "Rijnummer"; SortOrder.Ascending ) //Sort( // Filter( // AddColumns( // CollectionAllUnitsJobList; // "IDcopy"; // Text('Id (ID)') // ); // (JOB_PRIORITY.Value = "Other") && (JOB_WHO.Value = "OPR"); // "Rijnummer"; // SortOrder.Ascending // ); // JOB_PRIORITY.Value; // SortOrder.Ascending //)

Was this reply helpful? Yes No
Verified answer

PonceletSeba 81 on at

Like
a
(0)

Report
Copy link

Link copied!
Solved this issue by using a single selection choicebox for cboPlanning instead of multi selection one, then evaluating it like this:
Sort( Sort( Filter( AddColumns( CollectionAllUnitsJobList; "IDcopy"; Text('Id (ID)') ); IsBlank(cboPlanning.Selected) || cboPlanning.Selected in JOB_Assigned_To.Value && Not(JOB_STATUS.Value = "Finished") ); JOB_PRIORITY.Value; SortOrder.Ascending ); "Rijnummer"; SortOrder.Ascending );
Thanks for the suggestions.

Was this reply helpful? Yes No