Im trying to achieve the following scenario and have searched the net for days and even tried to get Chat GPT to help but didnt get anywhere. Any help with this would be greatly appreciated.
I have two storage accounts in Azure, users will upload lots of files (number unknown).
- I want logic app to detect the change to container
- monitor it till no more files have been uploaded for 20mins.
- Then send a single approval email to manager,
- Once approved, copy the data from the source storage account to 2nd storage account.
- Once copied logic app find out which user uploaded the files
- and send them an email to say request approved and data copied.
I got most of it working except these two issues
1st issue i had was that if the user uploaded 15 files to container, then my logic app sent 15 emails to manager for approval (i want just one when upload is completed).
2nd issue is that i cant figure out how to get users email address from the blob they uploaded. i had to upload a file with the users email address in it.
For the first issue, try disabling the
Split onparameter in the trigger:For the second issue, perhaps you can use Graph API to retrieve user's identity object, which contains the email address?
Example: https://learn.microsoft.com/en-us/graph/api/user-get?view=graph-rest-1.0&tabs=http#example-3-use-select-to-retrieve-specific-properties-of-a-user