Dear experts, I am totally disappointed and sad as i have tried everything but without any luck. I would be grateful if you could help.
I have a usecase, In which there is a cloud database table, along with 2 sharepoint lists( which are used to store the comments of 2 users) every user has his own sharepoint list.
The usecase, once a user clicks on an entry in the PBI Report and click on their specific comment button, the powerapp popup comes in, and it fecthes 4 relevant column info in the app and asks for a comment, which is then saved in the sharepoint list.
As mentioned earlier, i have imported the sharepoint list also in the PBI Report to show all the comments made, it is visible in the PBI Dashboard as well. It shows the comments without any issues.
However, I would like to show the most recent comment made, based on those two relevant columns which are Material no and Info column and i would like the previous comment to be either updated with the new comment or either hide the previous with the new one.
But in the sharepoint the old and new data should be there based on the comments made.
I would be grateful if you could give me a solution to achieve this as its been 2 weeks i have tried numerous toturials, but they didn't help, I am a newbie in powerbi but its very critical for me to do this task asap.
Looking forward to your kind feedback.
