PowerApps: Filter a Lookup Field Based on a Previous Field
I have two lists w/ the following details:
List 1: JobType1; Column: Title
List 2: JobType2; Columns: Title, JobType1 (lookup of Title column of List 1)
On List 3 (Request), I am trying to use PowerApps and I have two fields that are lookups of the two lists:
JobType1 - lookup field that uses the Title column of List 1
JobType2 - lookup field that uses the Title column of List 2
I am trying to filter JobType2 field in the form to display all values on the Title column on List 2 that matches the value of the JobType1 field in the form w/ the JobType1 column on List 2.
I tried using this formula but it does not work. Please help me.
Filter(Choices(IntMktg.Job_x0020_Type_x0020_2), Value in Filter('JobType1', IntMktg.Job_x0020_Type_x0020_1 = DataCardValueClient.Text).Title)
filter lookup powerapps
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
asked Nov 27 '18 at 18:51
JosephJoseph
11
add a comment |
I have two lists w/ the following details:
List 1: JobType1; Column: Title
List 2: JobType2; Columns: Title, JobType1 (lookup of Title column of List 1)
On List 3 (Request), I am trying to use PowerApps and I have two fields that are lookups of the two lists:
JobType1 - lookup field that uses the Title column of List 1
JobType2 - lookup field that uses the Title column of List 2
I am trying to filter JobType2 field in the form to display all values on the Title column on List 2 that matches the value of the JobType1 field in the form w/ the JobType1 column on List 2.
I tried using this formula but it does not work. Please help me.
Filter(Choices(IntMktg.Job_x0020_Type_x0020_2), Value in Filter('JobType1', IntMktg.Job_x0020_Type_x0020_1 = DataCardValueClient.Text).Title)
filter lookup powerapps
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
asked Nov 27 '18 at 18:51
JosephJoseph
11
add a comment |
I have two lists w/ the following details:
List 1: JobType1; Column: Title
List 2: JobType2; Columns: Title, JobType1 (lookup of Title column of List 1)
On List 3 (Request), I am trying to use PowerApps and I have two fields that are lookups of the two lists:
JobType1 - lookup field that uses the Title column of List 1
JobType2 - lookup field that uses the Title column of List 2
I am trying to filter JobType2 field in the form to display all values on the Title column on List 2 that matches the value of the JobType1 field in the form w/ the JobType1 column on List 2.
I tried using this formula but it does not work. Please help me.
Filter(Choices(IntMktg.Job_x0020_Type_x0020_2), Value in Filter('JobType1', IntMktg.Job_x0020_Type_x0020_1 = DataCardValueClient.Text).Title)
filter lookup powerapps
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
asked Nov 27 '18 at 18:51
JosephJoseph
11
I have two lists w/ the following details:
List 1: JobType1; Column: Title
List 2: JobType2; Columns: Title, JobType1 (lookup of Title column of List 1)
On List 3 (Request), I am trying to use PowerApps and I have two fields that are lookups of the two lists:
JobType1 - lookup field that uses the Title column of List 1
JobType2 - lookup field that uses the Title column of List 2
I am trying to filter JobType2 field in the form to display all values on the Title column on List 2 that matches the value of the JobType1 field in the form w/ the JobType1 column on List 2.
I tried using this formula but it does not work. Please help me.
Filter(Choices(IntMktg.Job_x0020_Type_x0020_2), Value in Filter('JobType1', IntMktg.Job_x0020_Type_x0020_1 = DataCardValueClient.Text).Title)
filter lookup powerapps
filter lookup powerapps
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
asked Nov 27 '18 at 18:51
JosephJoseph
11
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
asked Nov 27 '18 at 18:51
JosephJoseph
11
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
edited Nov 27 '18 at 20:53
RalfFriedl
6571211
6571211
asked Nov 27 '18 at 18:51
JosephJoseph
11
asked Nov 27 '18 at 18:51
JosephJoseph
11
asked Nov 27 '18 at 18:51
JosephJoseph
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Combo box control doesn't display the result. It seems a bug. I tried it out with the 3 lists and created a form on JobRequest. Here is my formula and it works if you use a dropdown. while waiting for Combo box to be fixed, you can use dropdown instead of Combo box.
Filter(Choices(JobRequest.JobType2), Id in Filter([@JobType2], JobType1.Value = DataCardValue2.Selected.Value).ID)
answered Nov 28 '18 at 23:16
user10199063user10199063
311
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53506323%2fpowerapps-filter-a-lookup-field-based-on-a-previous-field%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Combo box control doesn't display the result. It seems a bug. I tried it out with the 3 lists and created a form on JobRequest. Here is my formula and it works if you use a dropdown. while waiting for Combo box to be fixed, you can use dropdown instead of Combo box.
Filter(Choices(JobRequest.JobType2), Id in Filter([@JobType2], JobType1.Value = DataCardValue2.Selected.Value).ID)
answered Nov 28 '18 at 23:16
user10199063user10199063
311
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
add a comment |
Combo box control doesn't display the result. It seems a bug. I tried it out with the 3 lists and created a form on JobRequest. Here is my formula and it works if you use a dropdown. while waiting for Combo box to be fixed, you can use dropdown instead of Combo box.
Filter(Choices(JobRequest.JobType2), Id in Filter([@JobType2], JobType1.Value = DataCardValue2.Selected.Value).ID)
answered Nov 28 '18 at 23:16
user10199063user10199063
311
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
add a comment |
Combo box control doesn't display the result. It seems a bug. I tried it out with the 3 lists and created a form on JobRequest. Here is my formula and it works if you use a dropdown. while waiting for Combo box to be fixed, you can use dropdown instead of Combo box.
Filter(Choices(JobRequest.JobType2), Id in Filter([@JobType2], JobType1.Value = DataCardValue2.Selected.Value).ID)
answered Nov 28 '18 at 23:16
user10199063user10199063
311
Combo box control doesn't display the result. It seems a bug. I tried it out with the 3 lists and created a form on JobRequest. Here is my formula and it works if you use a dropdown. while waiting for Combo box to be fixed, you can use dropdown instead of Combo box.
Filter(Choices(JobRequest.JobType2), Id in Filter([@JobType2], JobType1.Value = DataCardValue2.Selected.Value).ID)
answered Nov 28 '18 at 23:16
user10199063user10199063
311
answered Nov 28 '18 at 23:16
user10199063user10199063
311
answered Nov 28 '18 at 23:16
user10199063user10199063
311
answered Nov 28 '18 at 23:16
user10199063user10199063
311
311
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
add a comment |
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
Thanks @user10199063. Can you enlighten me a bit since I am pretty new to PowerApps? JobRequest.JobType2 is the name of the lists/form and the field that I am wanting to have the filter? And if I add drop down fields to replace the combo fields, how to I connect them to the appropriate columns and use them on the formula you provided?
– Joseph
Dec 4 '18 at 10:17
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53506323%2fpowerapps-filter-a-lookup-field-based-on-a-previous-field%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
