On button click, check if there are blank values in SharePoint list

(0) Share

Report

Posted on by AlexTheKidd

178

I'm working on an app which should check if there are any blank values when I click a button.

I have two SharePoint lists: 'Deliveries' and 'Pallets_1'.

There is a gallery item that is selected, and on the new screen, only the selected delivery is shown - from here, I can create X number of pallets (created in 'Pallets_1'), which needs to have the measurements "Height", "Length" and "Width".

When clicking "Complete", it should check if all measurements in the pallets linked to the same Title as 'Deliveries' have any data in them - if not, then an alert will display; if all measurements have data, then it will patch (the patch function is already working).

Trying my hand at pseudocode:

Match the Title in Deliveries with the Title in Pallets_1
Then look at all pallets with the same Title, and check if the measurements are blank - if blank, notify the user that there are inputs missing

If I'm not providing enough information, please let me know which information is needed.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

victorcp 2,350 Moderator on at

Like (1)

Report
Copy link

Link copied!

Try this:
If(
IsEmpty(
Filter(
Deliveries,
Title = <Title from Pallets_1>,
IsBlank(<Height_Field>) || IsBlank(<Length_Field>) || IsBlank(<Width_Field>)
)
),
Notify(<Alert>),
Patch(...)
)

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!
Written without checks. Please try :

With({ Matching:Filter(Deliveries,Title = Pallets_1.Title) }, If(Filter(Matching,Length = Blank()),Notify("Error",NotificationType.Information,5000)) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
This will do it:

With({ Matching:Filter(Deliveries,Title = Pallets_1.Title) }, If(Filter(Matching,Length = Blank()),Notify("Error",NotificationType.Error)) )

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
AlexTheKidd 178 on at

Like (0)

Report
Copy link

Link copied!

Tried the snippet from both @phipps0218 and @Gochix , and both shows the following issues (ignore delegation warning):
-----

Was this reply helpful? Yes No
Verified answer

Gochix 1,937 Moderator on at

Like (1)

Report
Copy link

Link copied!
You can try the solution @victorcp provided :
If( IsEmpty( Filter( Deliveries, Title in Pallets_1.Title, IsBlank(<Height_Field>) || IsBlank(<Length_Field>) || IsBlank(<Width_Field>) ) ), Notify(<Alert>), Patch(...) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
AlexTheKidd 178 on at

Like (2)

Report
Copy link

Link copied!

You are correct! I tried it at first, but didn't work - I must've missed something when I first tried it. Thanks to @victorcp, and @Gochix for pushing me to try it! This community is absolutely amazing!!

Was this reply helpful? Yes No