I was working on the powerapps and I’m kind of facing a blocker,
Solved! Go to Solution.
Hi @rebel,
Could you please share a bit more about the Approvers field cwithin your SP list? Is it a Person type column?
Do you want to send one email for each one of the list of Approvers?
Further, could you please share a bit more about the Sendapprovalemailandfollowupviaemail.Run() function that you mentioned?
I suppose that the Approvers field is a Person type column (which does not enable multiple options) within your SP list, and the EGBLBrif represents the SP list on your side is it true?
If you want to execute/fire your flow for each one within the list of User Objects (Persons), I have made a test on my side, please take a try with the following workaround:
App configuration:
Set the OnSelect property of the "Send Email" button to following formula:
ForAll('20181011_case7'.List_x0020_Of_x0020_Approvers,'20181011_case7_1'.Run(List_x0020_Of_x0020_Approvers.Email))
Flow configuration:
The flow works successfully as below:
Note: The List Of Approvers column is a Person type column in my SP list, which does not enable multiple options.
On your side, you should take a try with the following formula:
ForAll(
EGBLBrif.List_x0020_Of_x0020_Approvers,
Sendapprovalemailandfollowupviaemail.Run(List_x0020_Of_x0020_Approvers.Email, List_x0020_Of_x0020_Approvers.Email)
)
In addition, if you want to send one email to multiple users, I think it is not necessary to use ForAll function to send one email for each user (fire/execute flow for each user).
You could consider take a try to concatenate all email addresses into a single one string using Concat function, and then pass the concatenated string from your app to your flow. I have made a test on my side, please take a try with the following workaround:
In order to concatenate all email addresses into single one string, please take a try with the following formula:
Concat(EGBLBrif.List_x0020_Of_x0020_Approvers,List_x0020_Of_x0020_Approvers.Email&";")
More details about the Concat function in PowerApps, please check the following article:
Best regards,
Kris
Hi @rebel,
Could you please share a bit more about the Approvers field cwithin your SP list? Is it a Person type column?
Do you want to send one email for each one of the list of Approvers?
Further, could you please share a bit more about the Sendapprovalemailandfollowupviaemail.Run() function that you mentioned?
I suppose that the Approvers field is a Person type column (which does not enable multiple options) within your SP list, and the EGBLBrif represents the SP list on your side is it true?
If you want to execute/fire your flow for each one within the list of User Objects (Persons), I have made a test on my side, please take a try with the following workaround:
App configuration:
Set the OnSelect property of the "Send Email" button to following formula:
ForAll('20181011_case7'.List_x0020_Of_x0020_Approvers,'20181011_case7_1'.Run(List_x0020_Of_x0020_Approvers.Email))
Flow configuration:
The flow works successfully as below:
Note: The List Of Approvers column is a Person type column in my SP list, which does not enable multiple options.
On your side, you should take a try with the following formula:
ForAll(
EGBLBrif.List_x0020_Of_x0020_Approvers,
Sendapprovalemailandfollowupviaemail.Run(List_x0020_Of_x0020_Approvers.Email, List_x0020_Of_x0020_Approvers.Email)
)
In addition, if you want to send one email to multiple users, I think it is not necessary to use ForAll function to send one email for each user (fire/execute flow for each user).
You could consider take a try to concatenate all email addresses into a single one string using Concat function, and then pass the concatenated string from your app to your flow. I have made a test on my side, please take a try with the following workaround:
In order to concatenate all email addresses into single one string, please take a try with the following formula:
Concat(EGBLBrif.List_x0020_Of_x0020_Approvers,List_x0020_Of_x0020_Approvers.Email&";")
More details about the Concat function in PowerApps, please check the following article:
Best regards,
Kris
Great works perfectly!!
However since it wasn't giving me too much flexibility when it comes to our users, I went with a Sharepoint List for the Approvers to add some tags and types but concatenating them in CC after is perfect !
Thanks a lot for your help