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.
with Search, it keeps returning an error... using this syntax
job_address1_Column1_1.FieldDisplayName = job_address1
)WorkOrders,searchQuering , job_address1
But if i use this below Search syntax alone, it gives me what i am searching for but no added column
I think you should probably split the processes up.
Step 1 - Add an extra column to the collection.
ClearCollect(WorkOrders2,AddColumns(WorkOrders,""JobNotes", LookUp(Jobs, job_address1_Column1_1.FieldDisplayName = job_address1).job_Notes))
Protip: I'd make a gallery or data table and just confirm everything came over as you expect.
Step 2 - Rewrite your search function. Search(WorkOrders,SearchQuering,"Job_address1","jobNotes",etcetc)
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.