Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Tabular Connectors]: import N:1 as tabular #2842

Open
MikeStall opened this issue Feb 6, 2025 · 0 comments
Open

[Tabular Connectors]: import N:1 as tabular #2842

MikeStall opened this issue Feb 6, 2025 · 0 comments

Comments

@MikeStall
Copy link
Contributor

For CDP, Power Apps imports N:1 fields as scalars, not relationships.

Power Fx code should do that too to be consistent with Power Apps.

So this should work against a Salesforce table:

Filter(Opportunities, StartsWith(ThisRecord.OwnerId, "your_user_id_here"))

Where OwnerId is a N:1 lookup field. Because OnwerId is imported as a scalar (string) value and not a record.

This is different than Dataverse, where N:1 gets imported as a record.

Image
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@MikeStall