Check date automaticaly in sharepoint list when filling a form in power apps

[Lagloire]

Hi everyone

I'm facing this issue: how can be checked automaticaly the date user register in the form comparatively at other date he has previously registered in other sharepoint list?

I mean, user first has registered date data in  app "A" which was stocked in sharepoint list "A". Now he will register date data in other app "B" which is going to be stocked in sharepoint list "B". The idea is, when he will do the second registering in the app "B", i want to check automaticaly in sharepoint list "A" is the date data is correct or not. If is not correct, a message will be displayed on the app B screen to let him know that his data is not correct. Can you help me with this check and the message to be displayed?

Thank you in advance.

[Lagloire]

@WarrenBelz Thank you for your support. Is there possible to have a teams chat/call to show you some details about the project?

[WarrenBelz]

Hi @Lagloire ,

I have limited internet for the next week, so unfortunately, that is not an option.

[Lagloire]

@WarrenBelz Hi

Thanks for your support. I'm facing now below issues :

1 = User Email adress

2 = Date

3 = Month

4 = Number 1

5 = Number 2

6 = Leaving raison

7 = StartDate

8 = EndDate

9 = Leaving time (Morning or afternoon)

10 = Coming time (Afternoon or Night)

11 = Total of leaving days

12 = Raison 2

13 = Number

14 = Total number, which is igual to : 5+11+13

15 = Comment

Calculated datas in columns 11 and 14 in power apps are not sending to SP list. I've heard that it is not possible to patch calculated column from power apps to sharepoint list. Possible solution is to make calculation in sharepoint list column based on datas of others column. Now, my calculated column is to count working days between 2 dates taking into account weekend and holidays. The formula i wrote is working perfectly in power apps, but is not working in calculated column in sharepoint. I found this formula online to make it in SP list column: 

IF(ISERROR(DATEDIF([StartDate],[EndDate],”d”)),””,(DATEDIF([StartDate],[EndDate],”d”))+1-INT(DATEDIF([StartDate],[EndDate],”d”)/7)*2-IF((WEEKDAY([EndDate])-WEEKDAY([StartDate]))<0,2,0)-IF(OR(AND(WEEKDAY([EndDate])=7,WEEKDAY([StartDate])=7),AND(WEEKDAY([EndDate])=1,WEEKDAY([StartDate])=1)),1,0)-IF(AND(WEEKDAY([StartDate])=1,(WEEKDAY([EndDate])-WEEKDAY([StartDate]))>0),1,0)-IF(AND(NOT(WEEKDAY([StartDate])=7),WEEKDAY([EndDate])=7),1,0))

Adapting it to my case by changing "StartDate" and "EndDate", it is not working for me at all. More, the formula is not taking into account, France Holidays.

So, any solution to solve this issue?

The others issues like :

- When click on a field to fill, data already filled in previous column desappear,

- Calculated field based on datas from second row of each line are not correct. Rows of first lines work perfectly

- Some user data to be displayed on home screen not working at all

are not solved yet.

[WarrenBelz]

Hi @Lagloire ,

I have very limited use for calculated columns in SharePoint (they do not "play well" with Power Apps at the best of times, so I do the calculation in Power Apps and write it back to the appropriate column (Text or number) in SharePoint. So unfortunately, I am not the best person to ask about the brain-melting formula you have there. 

[Lagloire_22]

@WarrenBelz ok thank you