
Dear Community Members, I am desperately looking for help.
I have a PowerBI report, Where I have 3 tables one coming from snowflake(main table) and 2 SharePoint lists.
My use case is, once a user clicks on an entry and clicks at the comment button, some of the selected entry columns will be fetched from PowerBI Report to the Powerapps eg; material no, description, etc, user just has to write feedback(comment) and click submit, which will be saved into the Sharepoint list, Plus i have imported the comment column in the PowerBI dashboard along with with the columns of my main table coming from snowflake.
Everything was working fine, while i realized that after i was filtering for a specific entry to see all the relevant the relevant values, while the total number of entries were around 500+ it was showing only 20+ entries.
What i figured out was that, once i click on the table visual where all of my columns are, and in the visualization pan of values, at the comment column at the down arrow i check marked at "show items with no data" afterwards my all entries were being shown which is what i wanted.
But the problem which happened now is, once i click on an entry which has no previous comment(blank) it shows blank screen in powerapps for that while if i choose an entry with a comment already(as there are some comments in sharepoint list) it shows the data for them. I am not sure what i should do so upon clicking the data should be fetched automatically so the user can submit the comments.
I would be grateful for your insight, Sorry for such a long post. but i have tried every option but i don't seem to figure out whats wrong. i would be grateful for your help~