Unanswered

Display Employee ID in PowerApps form onview in SharePoint integration form

(0) Share

Report

Posted on by MohamedMo

i have SharePoint backend form uploaded all employee IDs in it and added formula to add the ID of employee who opened the form this is working fine

but i found that when the employee opened the form in View or edit the ID not displayed it became empty so is there any recommendation to solve this issue

want to display the ID of the user who created the item

tried the below but ThisItem.'Created By'.Email gives me error

Set(
varEmployeeID,
Coalesce(
LookUp(
'Database',
Emails = ThisItem.'Created By'.Email,
'Employee IDs'
),
"ID not found"
)
);

the below formula working with once the form is opened.

Set(

    varEmployeeID,

    Coalesce(

        LookUp(

            'Database',

            Emails =  Office365Users.MyProfile().Mail,

            'Employee IDs'

        ),

        "ID not found"

    )

);

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 151,978 Most Valuable Professional on at

Like (0)

Report
Display Employee ID in PowerApps form onview in SharePoint integration form

Hi @MohamedMo,

There is nothing fundamentally wrong with this code
Set( varEmployeeID, Coalesce( LookUp( 'Database', Emails = ThisItem.'Created By'.Email, 'Employee IDs' ), "ID not found" ) );

providing you are running it from inside a Gallery or Form where all fields of your datasource (I assume a SharePoint List) are available (you have not used ShowColumns or specified fields to display). Where are you running it from - if a Gallery, what are the Items or a Form the Item and DataSource ?

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
MohamedMo 85 on at

Like (0)

Report

Display Employee ID in PowerApps form onview in SharePoint integration form

Hello @WarrenBelz

thanks for your response but once i added it the below error appear to me.

Was this reply helpful? Yes No