New data not showing

(0) Share

Report

Posted on by Seth18

146

Hi everyone!

I’m working on a PowerApp linked to two SharePoint lists:

EmployeeMaster – This contains the Staff ID and User Account.
Another SharePoint list – This holds the Employee ID, which is displayed in a DataCard.

I’m trying to show the Staff ID from EmployeeMaster based on the email in the Employee ID DataCard. Here’s the formula I’m using:

 If(
    !IsBlank(DataCardValue12),
    LookUp(
        EmployeeMaster,
        'User Account' = Office365Users.UserProfileV2(DataCardValue12.Selected.Email).userPrincipalName,
        'Staff ID'
    ),
    ""
)
The Issue:This formula worked perfectly with the old data in EmployeeMaster, but after I deleted all the old data and replaced it with new data (without changing any column names), the formula stopped working. Now it just shows blank, even though the formula hasn’t changed.
Here’s what I tried so far:
Refreshed the SharePoint connection in PowerApps.
Removed and re-added the EmployeeMaster data source.
But it’s still not showing the Staff ID.
Any ideas on what could be causing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Mark Nanneman 993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Seth,

Does your formula show any errors in your Canvas App editor? It looks like it contains some syntax errors to me.

1. I think you need to fix your "!IsBlank()" function. Maybe add ".Selected.Email" or change it to an !IsEmpty on your datacard's .SelectedItems. An !IsBlank(DataCardValue) that doesn't specify any properties of DataCardValue will always return true.

2. Your lookup formula looks incorrect. If you want to output the "Staff ID" you need to put that after your closing parenthesis for your LookUp. Like "LookUp(...).'Staff ID'"

If(

!IsBlank(DataCardValue12.Selected.Email),

  LookUp(

  EmployeeMaster,

'User Account' = Office365Users.UserProfileV2(DataCardValue12.Selected.Email).userPrincipalName).'Staff ID',

  ""

)

Was this reply helpful? Yes No
Seth18 146 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mark Nanneman,

Thank you for your response!

Currently the canvas App editor is not showing any error and to clarify the datacardvalue12 is an employee Name. So in what i am doing is that when the employee name is elected then i want the Employee ID to be shown. Like i mentioned above with the old data it shown but with a new data (just making change to some users info) currently it just blank. And your suggested code is also showing the blank result as well :/

Was this reply helpful? Yes No