Power Apps - Building Power Apps

How to get email address through id in the power app

(0) Share

Report

Posted on by NS-10041416-0

148

Hi,

There is column as CreatedBy(custom) which has user display Name.

Through flow I am able to get the id into the power app in the form of

6b72523f-1584-f011-b4cc-000d3ab80c7d

But I am not able to get the email address using the id and I tried various methods i.e.

CreatedById:Text(app.CreatedById), 
CreatedByEmailAddress: Office365Users.UserProfileV2(Text(app.CreatedById)).mail

Unfortunately I am receiving blank so please let me know if I am making any mistake here.

Regards,

Sudheer

Categories:

Connectors

I have the same question (0)

All responses (4)

Answers (0)

Pstork1 68,332 Most Valuable Professional on at

Like (0)

Report

How to get email address through id in the power app

Is the column a Dataverse choice column? That's what it looks like since you are getting a GUID which represents the option in the Option Set for the column.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
NS-10041416-0 148 on at

Like (0)

Report

How to get email address through id in the power app

CreatedBy is a lookup column that has been mapped with CreatedBy(Delegate).

Regards,

Sudheer

Was this reply helpful? Yes No
Kushal_M 64 on at

Like (0)

Report

How to get email address through id in the power app

NS-10041416-0 ,

Try using GUID method instead of Text method to wrap the flow output of user guid and see if you get the email address from users table or office 365 users .

CreatedById:GUID(app.CreatedById),

CreatedByEmailAddress: Office365Users.UserProfileV2(GUID(app.CreatedById)).mail

Also, you can try the below workaround if the above didn't work.

LookUp(
Users,
systemuserid = GUID(app.CreatedById),
internalemailaddress
)

🏷️ Please tag me @Kushal_M, if you still have any queries related to the solution or issue persists.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,332 Most Valuable Professional on at

Like (0)

Report

How to get email address through id in the power app

'Created By (Delegate)' points to a record so you should be able to get the primary address using something like

ThisItem.'Created By (Delegate)'.'Primary Email'

But I'm not sure what you are using App. for in your code. The creator of the app isn't surfaced by the app automatically.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No