Answered

Populating a field based on selected field in same datasource

(0) Share

Report

Posted on by chrisbarbers

Hi all

I have a SharePoint form with two data sources on it, I have successfully populate the Meeting Name in the second based on what is selected in the first, but I want to now use that second value to populate the Coordinators from the selected record, it is a multi select user field, and in my example/test case there are 3 people selected, what is the best way to show the 3 people and then be able to test if the current user is one of those?

I tried the flow approach but I need the coordinators to be available during the form update or creation process so I am in essence trying to look it up during the form creation, the flows only give it to me after the record is created.

Any thoughts/guidance would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @chrisbarbers,

To be honest, current provided info make no sense on helping you figure it out, too few details...

You need to tell me what your two data source look like , what is this Coordinators, Meeting Name in the second?

What is second value that used to populate the Coordinators?

What is this selected record?

What is your example/test case?

What is the relationship between two data sources?

Was this reply helpful? Yes No
chrisbarbers 37 on at

Like
a
(0)

Report
Copy link

Link copied!

So I have split the form into two top half is datasource 1 which is the form for adding items to the current SP List, this has a few drop downs/fields, 1 is Meeting Name which is DataCardValue2
I am using the selected DataCardValue2 value to make the Meeting Name - DataCardValue8 in the second datasource the same, this works great.
In datasource 2 there is a field called Coordinators at the moment in my lower half of the form this is shown as a drop down as it is a user multi select field, but it currently works like the standard field in that I can select multiple people, what I want/need is it to show the values based on the selected Meeting Name.
Does that help?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @chrisbarbers,

So Coordinators is a Person coumn allowing multi select?

To filter the Person fields in your second data source, you could try to set the Items property:

Ungroup(Filter(list2,MeetingName.Value=DataCardValue8.Selected.Value).Coordinators,"Coordinators")

Was this reply helpful? Yes No
chrisbarbers 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-qiuyu-msft so it didn't quite work, but I played around a bit and made some progress, using
Ungroup(Filter(Meetings,'Meeting Name' in DataCardValue2.Selected.Value).Coordinators,"Coordinators") which uses the datasource 1 Meeting Name field or
Ungroup(Filter(Meetings,'Meeting Name' in DataCardValue8.Text).Coordinators,"Coordinators") using the second Meeting name field (.Value didn't work here) I now get the list of the Coordintaors associated with that Meeting name (albeit twice in both cases), but they are not selected, I assume because this contains Filter, can I use a different approach to select them?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @chrisbarbers,

I have mentioned that in my previous reply that you need to tell me more about your data type ,which is the key to your issue.

I could not imagine the data set on your side.

I am using the selected DataCardValue2 value to make the Meeting Name - DataCardValue8 in the second datasource the same.

I provide the formula based on the above decription, you said the Value parameter, I am not sure the data type.

Please do provide all the column type of your columns in both your data sources.

Was this reply helpful? Yes No
chrisbarbers 37 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiuyu-msft apologies, yes the Coordinators column is a person column with multi select, 3 people are selected in the column for the particular record that matches the meeting name in DataCardValue8 (but it could be more or less for other meeting names), your formula or my version of it is filtering it correctly to show the correct 3 people in this case, albeit twice.

What I am trying to do is get the values in a field or variable(s) so I can reference them against the current user in order to limit options in the other datasource, i.e. if current user != coordinators then limit options....

Hopefully that clarifies.

Was this reply helpful? Yes No
Verified answer

chrisbarbers 37 on at

Like
a
(0)

Report
Copy link

Link copied!

I have worked out a solution, thanks

Was this reply helpful? Yes No