Hi, i am. trying to add a column from another datasource to my datatable, but my syntax keeps giving me the below error message
Solved! Go to Solution.
Hi @tbabe12 ,
I may not have this exactly correct, but you do not need the As statement and you need to add the field name from the Jobs lists you are adding.
Search(
AddColumns(
WorkOrders,
"Jobs”,
LookUp(
Jobs,
job_addressl_Columnl = job_addressl
).YourFieldName //need the field to add
),
searchQuering,
"job_addressl"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
What type of visual is job_address1_Column1? If it is a textbox, it should be job_address1_Column1.Text. The easiest way to figure out what should go there is to press a period and see what the system suggests. If it says job_address1_column1.Selected you will need to press the period one more time and do it again.
Hi @tbabe12 ,
I may not have this exactly correct, but you do not need the As statement and you need to add the field name from the Jobs lists you are adding.
Search(
AddColumns(
WorkOrders,
"Jobs”,
LookUp(
Jobs,
job_addressl_Columnl = job_addressl
).YourFieldName //need the field to add
),
searchQuering,
"job_addressl"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@tbabe12 ,
Firstly, you have double quotes around job_addressl_Column1, which you do not need and I also noticed not you have a list and field name (jobs) the same - not good practice. Also Search() does not seem to like working outside and AddColumns function (I have now properly tested the syntax), so try this
Filter(
AddColumns(
WorkOrders,
"JobNotes",
LookUp(
Jobs,
job_address1_Column_1 = job_address1
).job_Notes
),
searchQuering in job_address1
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
the datasource i am trying to add is Jobs, and the field names are job_Notes and job_warrantydate_closed
What type of visual is job_address1_Column1? If it is a textbox, it should be job_address1_Column1.Text. The easiest way to figure out what should go there is to press a period and see what the system suggests. If it says job_address1_column1.Selected you will need to press the period one more time and do it again.
Filter(
AddColumns(
WorkOrders,
"JobNotes",
LookUp(
Jobs,
job_address1_Column1.FieldDisplayName = job_address1
).job_Notes
),
searchQuering in job_address1
)
searchQuerying happen to be a variable i created for the search box, but using this filter, i can not search for my job_address, as the field is empty, also the jobnotes field is empty too. my question is , i am wondering why my job_address field and Job notes field are not showing values and also why i can not search using address.. thanks
I'm confused. What are you talking about?
User | Count |
---|---|
250 | |
105 | |
82 | |
51 | |
43 |