Unanswered

datacard default value sp

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a person type datacard in my form (in my case the datacard is called 'Privacy/ATIP Manager Approval'). My goal is to have the datacard display a default value or person's email address who is associated to that role (for an example 123@gmail.com). However, I want it to first check a SP list (named DOA). That SP list will have a column called 'Role' that will include various roles such as the Privacy/ATIP Manager, IT Director, etc. If the Privacy/ATIP Manager has delegated his role to an incumbent (meaning someone else acts in his role for a certain period of time as in between the Start and End Date) and the form is being filled in within the Start and End Date of this person acting as the Privacy/ATIP Manager, I want that person's name displayed as the 'Default' value instead of the original Privacy/ATIP Manager's name.

To be more specific, the important columns within my 'DOA' SP list are the Incumbent (Person), Delegate (Person), Start Date(Regular Date), End Date (Regular Date), Role (Multiple Choice), and Active Incumbent (Y/N) columns. I have attached an example along with a screenshot of what an entry would look like:

With this information, would you know the code I should put in the Default part of the datacard (or it may be another area I'm not sure)? I'm still very new to Power Apps and I'm running into loads of errors with my attempts. Please let me know if there is any other information you need!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

May I ask if your datacard called ‘Privacy/ATIP Manager Approval' is a form built with the SP list as the data source?
We assume that your datacard exists in a form with DOA as the data source.

We created the SharePoint List as you offered.

Add a datacard into the Form.

The Items of the Combo Box:
[ThisItem.Delegate,ThisItem.Incumbent]

The DefaultSelectedItems of the Combo Box:
If(Int(DateDiff(Today(),ThisItem.'Start Date',TimeUnit.Days)) <= 0 && Int(DateDiff(Today(),ThisItem.'End Date',TimeUnit.Days)) >= 0,
            ThisItem.Delegate,
            ThisItem.Incumbent
        )

We can see the Combo Box is worked from the screenshot.

If we change the date.

It will still worked as we expect.

Hope this will help you.

Best Regards,
Tina
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Wow, I appreciate all this. I understand the logic you've enabled based on your code and screenshots. I realize I wasn't very clear on a few things so allow me to be a bit clearer. The DataCard 'Privacy/ATIP Manager Approval' is apart of another SP list separate from the 'DOA' SP list. Also, the purpose of the 'Active Incumbent' column is to do the date calculation within SP. It determines if Today's date is in between the Start and End Date of an entry in the DOA SP list. If it is, Active Incumbent is set to Yes. If Today's date isn't between the two dates, 'Active Incumbent' is set to No.

I don't see the DefaultSelectedItems tab anywhere. Should I be looking at the DataCard itself when implementing these functions or the DataCardValue?

Something I was trying to get working earlier would be something like this in terms of displaying the default value for the DataCard, I just am really struggling with the syntax and getting it to work:
If(
    LookUp(DOA, Role = "Privacy/ATIP Manager").'Active Incumbent' = "Y",
    LookUp(DOA, Role = "Privacy/ATIP Manager").Incumbent.Email,
    "joshua.john@gmail.com"
)

Let me know if this help cleared up anything, sorry for the miscommunication!