Hello,
I have a problem that needs fixing. I am currently visualising data streaming from Microsoft Forms using a combination of Power Automate and Microsoft Lists. My flow is like this:
Forms - A new response is submitted ->
Forms - Get response details ->
Microsoft List - Create Item ->
Power BI - Add Rows to a realtime dataset
Now the problem that I am facing here is this. Sometimes, the people who submit the form may make a mistake and they want to send a second form to overwrite that mistake. I have 3 fields that I could use to catch these forms, survey participant, topic, submission date. Now, if there are people who submit about the same topic several times a year, I would take only the latest form in the year. For example:
| Participant | Topic | Submission Date |
| John | Environment | 12/07/2023 |
| John | Environment | 13/07/2023 |
The report should only show the second row and not the first. In a normal data setting, I would just add another column, latest, and set it to true or false and just filter the entire report to true. However, working with realtime data proved to be a lot trickier as there are many limitations. I keep getting an error: A circular dependency was detected, even though there is non. Creating a dax table did not work as well as when I upload the data model to Service, the connection between the dax table and realtime dataset breaks. I also checked, there is no way I could update a row in a dataset using Power Automate. The only solution I came up with so far is filtering these responses manually but obviously this is not an ideal solution.
Is there any solution for this or any way I could get around this?
Any help is much appreciated.
Thanks
