cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GuestOnaQuest
Frequent Visitor

Issue when using CDS view in PowerApps (canvas)

I am creating view (Active AssetRisks) in CDS:
View.PNG
Within PA I create collection: ClearCollect(ActiveRisks, Filter(AssetRisks, 'AssetRisks (Views)'.'Active AssetRisks')); 
I set a datasource for view gallery as 'ActiveRisks'. However, I can't access 'Risk Class No Action' field: ThisItem.'Risk Class No Action'.'Risk Class'; If I change the datasource for the gallery to the entity itself (AssetRisks) then I do get 'Risk Class No Action'.

 

Does it has something to do with the fact that 'Risk Class No Action' is a lookup field from the over entity?

 

How can I bypass this limitation and still utilize view functionality of CDS?

1 ACCEPTED SOLUTION

Accepted Solutions
GuestOnaQuest
Frequent Visitor

Re: Issue when using CDS view in PowerApps (canvas)

Since as I have already mentioned the 'Risk class no action' is a lookup from another entity, we need to do lookup from within PA as well. So I created a collection containing all risk classes (AllRiskClasses) and: LookUp(AllRiskClasses, 'Probability No Action' = ThisItem.'Probability No Action' && 'Impact No Action Taken' = ThisItem.'Impact No Action Taken').'Risk Class'

View solution in original post

1 REPLY 1
GuestOnaQuest
Frequent Visitor

Re: Issue when using CDS view in PowerApps (canvas)

Since as I have already mentioned the 'Risk class no action' is a lookup from another entity, we need to do lookup from within PA as well. So I created a collection containing all risk classes (AllRiskClasses) and: LookUp(AllRiskClasses, 'Probability No Action' = ThisItem.'Probability No Action' && 'Impact No Action Taken' = ThisItem.'Impact No Action Taken').'Risk Class'

View solution in original post

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Users online (8,144)