Unanswered

Validating data from sharepoint columns in a loop

(0) Share

Report

Posted on by ShockWave21

Hello,

I have a problem because I would like to check the validation of 25 values from one record in a loop . Here is my code and it doesn't work because it doesn't find the ThisRecord context. Does anyone have any idea how this can be solved?

ClearCollect(
ColumnNames,
"Answer 1", "Answer 2", "Answer 3", "Answer 4", "Answer 5",
"Answer 6", "Answer 7", "Answer 8", "Answer 9", "Answer 10",
"Answer 11", "Answer 12", "Answer 13", "Answer 14", "Answer 15",
"Answer 16", "Answer 17", "Answer 18", "Answer 19", "Answer 20",
"Answer 21", "Answer 22", "Answer 23", "Answer 24", "Answer 25"
);
ForAll(
ColumnNames,
If(
IsEmpty(LookUp(ev_SP_List_Uhde_Gemba_Walk_Main, 'Identyfikator (ID)' = Gallery2.Selected.ID).ThisRecord),
Notify(ThisRecord.Value & " is missed")
)
);

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @ShockWave21

can u try this please:

Set(varRecord, LookUp(ev_SP_List_Uhde_Gemba_Walk_Main, 'Identyfikator (ID)' = Gallery2.Selected.ID)); ClearCollect(ColumnNames, "Answer 1", "Answer 2", "Answer 3", "Answer 4", "Answer 5", "Answer 6", "Answer 7", "Answer 8", "Answer 9", "Answer 10", "Answer 11", "Answer 12", "Answer 13", "Answer 14", "Answer 15", "Answer 16", "Answer 17", "Answer 18", "Answer 19", "Answer 20", "Answer 21", "Answer 22", "Answer 23", "Answer 24", "Answer 25" ); ForAll(ColumnNames, If( IsEmpty(varRecord[@Value]), Notify(Value & " is missing", NotificationType.Warning) ) );

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
ShockWave21 on at

Like
a
(0)

Report
Copy link

Link copied!
MuhammadAizaz 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ShockWave21 ,
Can you check this code.
ClearCollect(
ColumnNames,
["Answer 1", "Answer 2", "Answer 3", "Answer 4", "Answer 5",
"Answer 6", "Answer 7", "Answer 8", "Answer 9", "Answer 10",
"Answer 11", "Answer 12", "Answer 13", "Answer 14", "Answer 15",
"Answer 16", "Answer 17", "Answer 18", "Answer 19", "Answer 20",
"Answer 21", "Answer 22", "Answer 23", "Answer 24", "Answer 25"]
);
ForAll(
ColumnNames,
If(
IsBlank(LookUp(ev_SP_List_Uhde_Gemba_Walk_Main, ID = Gallery2.Selected.ID).[@Value]),
Notify(Value & " is missed", NotificationType.Error)
)
);
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
can u try this instead:

Set(varRecord, LookUp(ev_SP_List_Uhde_Gemba_Walk_Main, 'Identyfikator (ID)' = Gallery2.Selected.ID)); ClearCollect(ColumnNames, "Answer 1", "Answer 2", "Answer 3", "Answer 4", "Answer 5", "Answer 6", "Answer 7", "Answer 8", "Answer 9", "Answer 10", "Answer 11", "Answer 12", "Answer 13", "Answer 14", "Answer 15", "Answer 16", "Answer 17", "Answer 18", "Answer 19", "Answer 20", "Answer 21", "Answer 22", "Answer 23", "Answer 24", "Answer 25" ); ForAll(ColumnNames, If( IsEmpty(varRecord[@ThisRecord.Value]), Notify(ThisRecord.Value & " is missing", NotificationType.Warning) ) );

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
ShockWave21 on at

Like
a
(0)

Report
Copy link

Link copied!
ShockWave21 on at

Like
a
(0)

Report
Copy link

Link copied!