Unanswered

Use share point ID for validation in Powerapps?

(0) Share

Report

Posted on by Maijija117

Hi, I am doing app about student, subject and time to study each day.

I create SharePoint list "timeslot". I type a short line of message like 07.00 08.00 09.00 for each row then SharePoint auto generate the ID.

From this scenario, my 08:00 was assigned ID as 1 and 08:30 was assigned ID as 2. The last time slot is 20:00 and assigned as 25.

I would like to make a validation rule that "time to" should be greater than "time from" (time from and time to referred from the same SharePoint list). In PowerApps form, user will pick a combo box showing timeslot "time from " and "time to" and a data card will be showed ID.

I cannot find any sample for this validation to make one ID must be greater than another ID. Please help if you understand my question and and suggest any solution for me. Thanks in advance 🙂

Pichaya

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Maijija117
Are you creating a new record with your form? A new record does not yet have any ID meaning the comparison cannot be done this way.

Are you planning on using multiple days in your app? Where is the day being considered? We only want to compare to times on the same day.

Please show a screenshot of your app and a screenshot of your datasource in your reply.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Maijija117 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh! I just realize that this is a problem

"Are you creating a new record with your form? A new record does not yet have any ID meaning the comparison cannot be done this way."
I just want to consider time on the same week day. I use "yes/no" to select the day. And yes, I cannot use ID of time slot to validate the rule I want. I will try other ways. But If you can give any suggestion please tell.