Create a Collection based on filter data from table in dataverse

(0) Share

Report

Posted on by anjali52

I have a table 'QW_Issue Type Libraries' in dataverse as below

In power apps I have form as below which is from another table in dataverse.

Now I want to create a collection onChange property of machine datacardvalue which I created as below.
Clear(IssueFinal);
ClearCollect(IssueTypeExtracted, Filter('QW_Issue Type Libraries', cr0b0_machine = DataCardValue9.Selected.Value));
ForAll(IssueTypeExtracted,Collect(IssueFinal,{Value: IssueTypeExtracted.cr0b0_issuetype}))

When I open my collection there are 5 filtered rows according to the selection but they are not displaying any data.

How can I get values in collection which than can be used as item property for Issue type to display only related choices for the user to select.

FYI : All columns in 'QW_Issue Type Libraries' are choice column and are sync to global choices.

Please it would be great help if anyone can help with these issue.
Thanks in advance.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @anjali52 ,

So Power Apps doesn't download all columns unless it is forced to. There are two ways out:
1. You can turn off the Explicit Column Selection app setting. However, I would strongly advise against it as it increases the data downloaded to the app and affects performance.
2. You can add a test label and set its Text property to something like First(IssueFinal).ColumnName & First(IssueTypeExtracted).ColumnName. Just repeat this for the column names.

Let me know if this helps.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!
Hardit Bhatia
Microsoft Business Applications MVP
Microsoft Certified Trainer MCT
Blog | Twitter | LinkedIn | Facebook | YouTube | Email
anjali52 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the help. It works.