Power Platform Community Forum Thread Details

Hi,

I am new with using power apps and SharePoint. Please help.

I created a customized form using power apps with SharePoint list as my data source.

I have this lookup column that I want to use to update another single line text column using a simple formula.

I'm trying to make this simple formula work for my Calendar View column default property:

If(
DataCardValue15.Selected.Value <> "N/A",
DataCardValue8.Selected.Value & " " & DataCardValue2.Selected.Value & " " & DataCardValue6.Selected.Value & " " & DataCardValue3.Selected.Value & " " & DataCardValue15.Selected.Value,
If(
DataCardValue15.Selected.Value = "N/A" && DataCardValue11.Selected.Value = "All Day",
DataCardValue8.Selected.Value & " " & DataCardValue10.Selected.Value & " " & DataCardValue12. Text,
DataCardValue8.Selected.Value & " " & DataCardValue11.Selected.Value & " " & DataCardValue10.Selected.Value & " " & DataCardValue12.Text
)
)

I don't get any errors on the formula, however, the values for these lookup columns are not showing

Categories:

Building Power Apps

Hi @RMSV ,

This additional LookUp columns will not have values until the LookUp column values is seleted in the App and the Form is submitted successfully. On the new form, if you would like to get corresponding values in the LookUp list after the LookUp column combo box item being selected, please add the Project listing list as another Data source and find the values based on the LookUp ID, Plant for example:

LookUp('Projects Listing', 'Job No' = JobNoDataCardValue.Selected.Value, Plant)

Furthermore, you can use Custom Cards to include one Combo box, set DefaultSelectedItems property the same as above formula, and then in a Text input box you will be able to reference these auto selected values after Job No value is selected.

Best regards,