I am creating a list which will be used for daily forklift checks that need to be completed via a power app. What I would like is a column that can calculate whether there has already been a check form completed in the day so there is no need for a second.

For example I check the forklift in the morning and complete the form. Someone else gets on the forklift in the afternoon and when they scan the QR code in the vehicle to bring up the check form the "status" column can be shown which should show that the check has already been completed today.

Hopefully that makes sense?

1 Answer 1


I don't think it is possible using SharePoint calculated columns.

Calculated columns has below limitations:

  • You cannot reference a value in a row other than the current row.
  • You cannot reference a value in another list or library.

Documentation: Introduction to SharePoint formulas and functions

You will have to write custom logic as per your requirements inside Power Apps only.

  • Okay thank you. Do you have some advice for the best place to start with the custom logic I may need?
    – Jack
    Commented Mar 10, 2023 at 9:54
  • Doc for barcode scanner: learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/…. Based on barcode value you can check if same value is available in existing list items or not. You can use Filter() for this. If you found matching item, you can show item details using other control in power apps like label/text input. Commented Mar 10, 2023 at 10:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.