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)

Verified answer

victorcp 2,350 Moderator on at

Like (1)

Report

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,935 Moderator on at

Like (0)

Report
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,508 Super User 2024 Season 1 on at

Like (0)

Report
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

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,935 Moderator on at

Like (1)

Report
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

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