How to show historical log in PBI visual with PowerApps form

[siddrow]

Hi

I am looking at creating a PowerApps form that will allow users to manually enter data into a visualiation. Is there a way to show a log of all the previous entries with the date of entry too? There will be 7 columns that they will be able to manually enter into, so not ideal to add a date field to the form and create 7 "updated on" date columns. 

thanks

[PijushRoy · Accepted solution]

Hi @siddrow 
Your Process should be
1. Two table, one table is for Data and another table is for LOG
2. When users update the data in Power App, Log file will saved the log
3. Bring the Log file into Power BI
4. Create relationship between Data table and Log table in Power BI Data model
5. Use the Log table in Tooltip page 

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[siddrow]

One more thing - is it actually possible to use the write back powerapps function if the columns I need to manually update are custom columns that I created in my power query? I don't actually have a data file for any of my data, the columns that aren't custom columns are direct from Snowflake.

[siddrow]

Would it capture a log of all the changes made to that cell or just the last one? Hoping to have an appended log that contains all the dates and changes that were made for that cell, instead of it creating a new column each time a change is made in that cell. The data set is quite big - approx 8 manual entry columns and anywhere between 8,000-10,000 rows.  Trying to work out the best way to create the log. 

[PijushRoy]

Hi @siddrow 

Yes, you can use PATCH function in Power App to store log for data update/delete etc. You should create another file to store the data.
Please go through the below tutorial to understand the PATCH function
https://www.youtube.com/watch?v=W8JjF2k0IQA 
https://www.youtube.com/watch?v=BzZ0a3zRFUk
https://www.youtube.com/watch?v=HMN-SWwkA3Q

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[siddrow]

and there isn't a way to have that log show in the power BI visualisation? =e.g. if I hovered over the cell in PBI visualisation that was changed, it would show the Power Apps change log for that specific cell?