HI All
I have a sharepoint list where entries are made via a Powerapp.
I have a person lookup field which once populated will then populate hidden fields such as Department.
the problem i have is that people move departments and so therefore my Power BI reports are incorrect.
What i would like to do is create a flow that will carry out and Automated check (2 times a day) of the person and their department and if that has changed update the list.
Is this possible?
this is something new to me so i don't know if it can be done.
Thanks Gary 🙂