Announcements
Hi,
I want to get Firstname in CarpoolUsers table by condition CarpoolUsers.Id = AccessControls.LoginUserId, for a text_label
Not sure why getting error, saying AccessControls.LoginUserId is table type, Id is text type
Thanks!
@feiyechen
Please provide context for your question. Is there a dropdown with AccessControls. Are you referring to a label in a gallery? Dataverse? SharePoint?
Hi, it's a text column in AccessControls table in Dataverse. The formula is in a text_label in canvas app
Ok flying blind here:
I take it AccessControls is a DataSource (Collection) so LoginUserId is a column in that Collection. Hence AccessControls.LoginUserId resolves as a table with a single column. What are you trying to do in plain English? Example: "Get the app user's LoginUserId from the AccessControls table, then using that, look up the user's first name in the CarpoolUsers table." If it's something like that, what piece of information do you have that identifies the user's record in AccessControls table? You may need two (possibly nested) LookUps.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 248 Super User 2026 Season 2
WarrenBelz 192 Most Valuable Professional
Mohsin Ali 135