Hi, I have some problem about power apps,
This is the formula for my button. To generate a request ID.
NewForm(Form1);Navigate(EditScreen_new, ScreenTransition.Fade);
Set(NextRequestID, "UNI-QA-00001");
ClearCollect(
LatestRequestIDs,
FirstN(
Sort(
Filter(
Task_University,
Not(IsBlank(RequestID))
),
RequestID,
SortOrder.Descending
),1
)
);
If(
CountRows(LatestRequestIDs) = 0,
Set(NextRequestID, "UNI-QA-00001"),
Set(
NextRequestID,
"UNI-QA-" &
Text(Value(Mid(Last(LatestRequestIDs).RequestID, 8,Len(Last(LatestRequestIDs).RequestID) - 7)) +1, "00000")
)
);
DataCardValue37.Text = NextRequestID;
I'm using this formula to generate a request ID, unfortunately in the part Not(IsBlank(RequestID))
is having a warning, delegation warning.
"Delegation warning. The highlighted part of this formula might not work correctly on a large datasets. the NOT operation is not supported by this connector."
This code stills works as-is and I'm using Sharepoint List to collect the datas. Any suggestion will be appreciated thanks.
