Formula work in Dev Studio but not when published. (Integrated App)

[franskl]

Good Day,

I will be very greatful for any help. Have been struggling for the last couple of days to debug this.

I have a formula which evaluates dates of leave taken. When true, it shows a text label ("Dates already taken")

This formula also works in another Canvas App connected to the same SP List without any issues.

For the intgrated app, the formula works in the app maker but when I publish it, not.

Note: 

• This is a Sharepoint integrated app
• DateValue2_1.Text is a text field
• Personnel Number is a text field

Formula:

If(
!IsBlank(DataCardValue8) && !IsBlank(DataCardValue9) && User().Email = "test@xyz.com",
LookUp(
'SAP Correct Leave',
'Personnel Number' = DateValue2_1.Text &&
(
(DateValue('Start Date') <= DataCardValue8.SelectedDate && DateValue('End Date') > DataCardValue8.SelectedDate && 'Personnel Number' = DateValue2_1.Text) ||
(DateValue('Start Date') <= DataCardValue9.SelectedDate && DateValue('End Date') >= DataCardValue8.SelectedDate && 'Personnel Number' = DateValue2_1.Text) ||
(DateValue('Start Date') < DataCardValue8.SelectedDate && DateValue('End Date') >= DataCardValue9.SelectedDate && 'Personnel Number' = DateValue2_1.Text)
),
true
)
)

What Am I missing ? Appreciate any feedback.

Many thanks in advance.

[mmbr1606]

hey @franskl 

is it an issue that rises up for certain users, or for everybody using the published app?

did you make sure that the app is shared with them, and that they have the right permissions on you datasource?

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[franskl]

Yes, the app is shared with the tester and he is also the only one seeing the text label when testing as it shows in the formula.

User().Email = "test@xyz.com"

[mmbr1606]

thanks for clarifying.

if its a sharepoint list, does he also have the right permission to the list (or other datasource you might use)

[franskl]

Yes, he has Full Control. This user is also a Site Administrator.

[franskl]

No help available ?

[franskl]

I have now changed the formula and it evalutes correct in the App Studio. See attached screenshot.

I get 2 records and the message is visible.

But it still does not work after it has been pusblished. why would this be ?

If(

    !IsBlank(DataCardValue8) && !IsBlank(DataCardValue9) && User().Email = "test@test.co.za",

    CountRows(

            Filter(

                'SAP Correct Leave',

                ('Personnel Number' = DateValue2_1.Text) &&

                (DateValue('Start Date') <= DataCardValue8.SelectedDate && DateValue('End Date') > DataCardValue8.SelectedDate && 'Personnel Number' = DateValue2_1.Text) ||

(DateValue('Start Date') <= DataCardValue9.SelectedDate && DateValue('End Date') >= DataCardValue8.SelectedDate && 'Personnel Number' = DateValue2_1.Text) ||

(DateValue('Start Date') < DataCardValue8.SelectedDate && DateValue('End Date') >= DataCardValue9.SelectedDate && 'Personnel Number' = DateValue2_1.Text)

            ))

         > 0,

        true,

        false

    )

[royg]

 Hi @franskl,

I'd check a couple of things in your revised formula:

1. Add Lower() on your Email comparison in case it contains upper case characters

2. Your If function has too many sections - 

The first is the comparison part (checking that the dates are not empty and that the user email is correct)

The second part, if the first comparison part evaluates to True - returns a boolean result (true or false if the count of rows that meet the filter criteria is greater than 0)

The third is the value to return if the first comparison part evaluates to False. In that case you return True.

The fourth part is irrelevant. 

Hope this helps you make some progress

[franskl]

Hi @royg 

The formla evaluates correct in APP Studio. But when I publish the APP, then it does not work.

[franskl]

The DataCard SelectedDate value shows 29/01/2024 00:00:00

Can the time value make that the dates don't compare  when doing the Filter ?