Let me give you more detail what I want to do
I want create a CSV file with previous day attendance information 3:00am everyday. My data source is share point lists.
I have a attendance list and other related lists which attendance list need look up them for information. for example.
Attendance
| JobSiteID | EmployeeID | In Time | Out Time | | |
| 1 | 1 | 9:00 | 17:00 | | |
Empoyee
| EmployeeID | Name | PositionID | | | |
| 1 | Jason | 1 | | | |
Position
| PositionID | Position | | | | |
| 1 | Technician | | | | |
JobSite
| JobSiteID | JobSite | | | | |
| 1 | Vancouver | | | | |
The expected CSV file should be like this:
| JobSite | Employee | Position | In Time | Out Time | |
| Vancouver | Jason | Technician | 9:00 | 17:00 | |
I can easily do this in PowerApps. But I want this job automatically execute everyday. The Power Automate can schedule a flow but I could not find a way to do the lookup within the Flow especially for position, it need to do 2 levels of lookup. Then, I am thinking if there is way to let the Flow to trigger this APP to do the job.
Thanks,
Jason.
