Validation of sharepoint list entry

Hi there. I have a list in SharePoint with the following 3 columns: "equipment", "from", and "to". The "equipment" column is a dropdown list where multiple equipments can be selected. The "from" colu...

Lists

SharePoint Online

RobElliott

Silver Contributor

Apr 20, 2023

lexetordo you can't compare items in a list, so for example if someone has already selected Camera then it will still be available for all other items you create. You will need to do this with Power Apps as the front end and your SharePoint list as the data source.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

lexetordo

Copper Contributor

Apr 26, 2023

Hi, againRobElliott

Following your advise, I set up an app. My level in Power App is -1, but I succeed to set it up 99% properly. I made all adjustments and now I need to add a validation in order to not let the user to add a new record if at least one equipment is selected for the same date between those times previously added by another user.
It would have been easier if only one equipment was selected, but since there could be more selected, I can't figure out.

You probably need some other info from me regarding the name of items used in app, but if you could just use whatever names you decide, I can handle to change them with the real ones. Anyway, I let here an image of EditScreen from Tree view

Thanks.

Forum Discussion

Validation of sharepoint list entry

Resources