Need help with PowerApps "If" Populating Form Fields.

[K-Beats]

Hello MS Community,

I have a gallery connected to sp list A and a form connected to sp list B. Onselect from gallery populates multiple fields on the form. then on submit, triggers flow that populates a word template.

The Gallery is basic info for client. it also has 5 contact sections in the list (Section meaning 6 rows dedicated for each contact) and I am trying to get the names of specific contacts to populate on the template if they exist.

I am trying to in one DataCard, If contact 1 POA , Contact 2 POA, Contact 3 POA, etc.. has "Guardian" use value from Contact 1 Name, Contact 2 Name, etc.

Also the Contact X POA is a drop down with that can select multiple values.

This is the first script that doesn't give me errors but also produces no results.

If(

"Guardian" in SelectedFaceSheet.'Contact 1 POA'.Value,

SelectedFaceSheet.'Contact 1 Name',

"Guardian" in SelectedFaceSheet.'Contact 2 POA'.Value,

SelectedFaceSheet.'Contact 2 Name',

"Guardian" in SelectedFaceSheet.'Contact 3 POA'.Value,

SelectedFaceSheet.'Contact 3 Name',

"Guardian" in SelectedFaceSheet.'Contact 4 POA'.Value,

SelectedFaceSheet.'Contact 4 Name',

"Guardian" in SelectedFaceSheet.'Contact 5 POA'.Value,

SelectedFaceSheet.'Contact 5 Name',

Blank()

)

Thanks In Advance

 

[cwebb365]

are you pulling from the collection or you pulling real time as you fill in the forms? If you’re just populating something that has the values and you probably need use .text or .value after contact name. Hard to tell without knowing what SelectedFaceSheet schema is and how / when that gets populated 

[K-Beats]

@cwebb365 , Thanks so much for your help

I am pulling from one list to populate another. Static works fine.

My Gallery is a SP list. 

The onselect for the gallery is 

Then I have a form connected to a different SP List

I am trying to populate certain fields 

After trying what you suggested I noticed this. Which is the data I am trying to get. 

Which is leading me to believe The problem is here.

which is configured like this

 

[cwebb365 · Accepted solution]

Youre gonna face palm but you miss spelled guardian in the choice or wherever the poa value there is coming from 🙂

[K-Beats]

5 Days!!!!! I blame the English language!!!!😅😅😡

@cwebb365 Thank you sooooo much!!!!! It worked!

Face Palm is an understatement!