Answered

Caution message on data card when duplicate employee ID exists in the SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to display a caution message to the user when they enter an employee id that already exists in the SharePoint list. Duplicates can be entered but we want to warn them that one exists so duplicates are created only when really needed.

Can someone help me with the code and steps to do this? I am very new to PowerApps.

SharePoint List: Flexible Schedule

Data Card: Employee ID_DataCard1

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
Assuming your Employee ID SP column is called EmployeeID, you could try this:

If ( DataCardValue1.Value = LookUp('Flexible Schedule', EmployeeID = DataCardValue1.Value, EmployeeID), " << your caution message >> ")

depending on your data types you may need may need to play around with wrapping the data card values in Value() if numbers or use ... .Text if text fields.

You will likely need to place this code in the text property of a label somewhere in your app canvas.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Each data card contains a ErrorMessage1 Label, we can use it to display the caution message.
Set the Text property as below:

If(DataCardValue1.Text in [@'Flexible Schedule'].'Employee ID', "This Name exists",Parent.Error )

Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft this was perfect, thank you very much!

Was this reply helpful? Yes No