I'm trying to an app where I can view an account and see the notes related to this account and then add new ones.
(like what they are doing here: https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/View-and-edit-timeline-notes/m-p/43...)
However, i'm unable to add notes to the account relationship. (doesn't show up in make.powerapps.com and I can't add relationships to notes)
But Notes already seems to have a relation to notes with the 'regarding' field. This shows the account id.
So I tried to create a form with this function:
LookUp(Notes, Regarding = Gallery1.Selected.Account)
(invalid arugment type)
I think i'm missing something very simple. Anybody knows what function I can use to find the notes related to an account without creating new relationships. (should be doable right since the regarding field is available?)
Hi @JollyDodo ,
Do you want to filter Notes based on the selection of Accounts entity?
Is the Gallery1's Items Accounts entity?
If so, please try this formula:
LookUp(Notes, Regarding = Gallery1.Selected)
//Regarding is a lookup field which is related to Accounts entity.
Thank you for your message!
In the picture you can see what i'm trying to accomplish.
I have a gallery with accounts and from there i wish to select the account and see the notes related to this account. (that are normally in the dynamics timeline. I'm using the cds connector btw.)
All of my apps have multiple SharePoint list that all have related fields. I don't like the Gallery.Selected and it won't work well for what you are wanting to do.
Instead in Gallery 1 have the OnSelect (of icon or something be): Set(varSelected, ThisItem.Title)
Replace Title with the field in Gallery 1 that is related to your item from list 2
The items for list 2 would be LookUp(DataSource, ParentID=varSelected)
ParentID being the column in your second list that is related to the first.
Keep in mind that whatever fields you have tied need to be unique for this. If I am doing a SharePoint List I use the ID field to ensure this.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications