You’re offline. This is a read only version of the page.
49
Hello,
So I was demo'ing some screens in Excel using OneDrive for Business connector. The screen works and I'm happy with the result.
The screen allows a user to type in the project name and various text inputs are filled with the appropriate data and some labels are. The end goal being that you can patch over the text inputs but I haven't got to that yet.
However, when copying over the data to a SharePoint List the formula that use to work is now returning 'blank' on exactly the same data set and I've reviewed that it isn't blank.
So this is how it looks, the green ticks are where the label/input is pulling from OneDrive. The working formulas are:
Start: Text(LookUp('CodeCentre - Project Delegation', TextInput2.Text = "Project Defintion").'Start date', DateTimeFormat.ShortDate)
End: Text(LookUp(Table1_1, TextInput2.Text = 'Project definition').'Finish date', DateTimeFormat.ShortDate)
Commercial: LookUp(Table1_1, TextInput2.Text = 'Project definition').Commercial
Email: LookUp(Table1_1, TextInput2.Text = 'Project definition').'Commercial Email'
The broken formulas, pulling from SharePoint List are:
Project Manager text input: LookUp('CodeCentre - Project Delegation', TextInput2.Text = "Project Defintion").ProjectM
^ This isn't broken but is returning a blank value
ProjectM Email text input: Search('CodeCentre - Project Delegation', TextInput2.Text, "Title")
^ This search function is broken and I'm not sure why but I was looking for an alternative way to pull the data.
Any help would be much appreciated thanks.
Solved my own answer which is a nice way to loop this off.
ProjectM Email text input: Search('CodeCentre - Project Delegation', TextInput2.Text, "Title")
Title is used incorrectly as a the word "Title" as oppose to the column 'Title'.
🙂
Share
Report
All responses (
Answers (
