Just want to seek help about this my LookUp Formula. I don't know what's the problem on this.
What am I doing is that I want to call the group name on my screen based on the person who is currently logged in.
Here's my sp list of Members, inside my Members list LookUp the GroupAssignment with GroupName on my Groups list.
and here is the formula I used to get the GroupName based on the MemberName(or the one who is logged in)
first I set the GroupAssignment. on Onstart property of the App.
Then I LookUp the textbox to see what GroupName I belong but it returns me this error.
Solved! Go to Solution.
Try switching the Groups lookup, so it'd be as follows:
Lookup(Groups, ID = varGroupNum, GroupName)
Also make sure that varGroupNum is actually a number and not text. If it is text you could amend your formula as follows:
Lookup(Groups, ID = Value(varGroupNum), GroupName)
Just an update.
It seems my formula is okay but it's data type is in Table.
I need to put this Value on my form which is a text data type. Do you have guys any idea on how can I change a Data Type?
Hello @Digital ,
It still not work it's data type still on table. what I need right now is to change it's data type to string or text to make the value on table visible on a text box.
Hi @Marlin-A ,
Since the GroupAssignment is the LookUp column, so the varGroupNum is saved as a table containing Id and value columns of related Group record.
If you want to see the GroupName, please try this:
Lookup(Groups, ID = varGroupNum.Id, GroupName)
Hope this helps.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021