I need help writing this statement.
ForAll(PartNumbers_Updated_Pre.MD_PartNumber,Patch(NewMDL, LookUp('[dbo].[VIEW_POWERAPPS_BASIC_ACCTIVATE_DATA]','[dbo].[VIEW_POWERAPPS_BASIC_ACCTIVATE_DATA]'.ProductID=PartNumbers_Updated_Pre.MD_PartNumber,ID),{ID: ID, ProductID: ProductID, Available: Available}))
The expectation is that I get a table of data given Where "MD_Partnumber" from PartNumbers_Update.Pre equals "ProductID" from the SQL table. The columns "ID" and "Available" need to be pulled int NewMDL.
This statement I think communicates the logic, but does not resolve.
Solved! Go to Solution.
Hi @martinav
You should be able to do this with something like this:
ClearCollect(Collection3,
AddColumns(RenameColumns(Collection1, "MD_PartNumber", "MD_PartNumber1"),
"Available",
LookUp(Collection2, MD_PartNumber1=MD_PartNumber).Available,
"Location",
LookUp(Collection2, MD_PartNumber1=MD_PartNumber).Location
)
)
Hi @martinav
It's a bit tricky to say without being in the designer but the bits I've highlighted in red are the parts that I would experiment with removing.
ForAll(PartNumbers_Updated_Pre.MD_PartNumber, Patch(NewMDL, LookUp('[dbo].[VIEW_POWERAPPS_BASIC_ACCTIVATE_DATA]','[dbo].[VIEW_POWERAPPS_BASIC_ACCTIVATE_DATA]'.ProductID=
PartNumbers_Updated_Pre.MD_PartNumber,ID), {ID: ID, ProductID: ProductID, Available: Available} ) )
Assuming that PartNumbers_Updated_Pre is the name of your SharePoint list, you should be able to ForAll over this without specifying MD_PartNumber. Perhaps if you make this change, the IntelliSense/any error messages will guide you towards the correct syntax in the remainder of the formula.
Your reccomendation is what I started with. Adding all that extra were my efforts of desparation to try to get it to work. Somtimes, its just a nuance in symantics.
The flyover help is also bloody worthless...
Hi @martinav
Is there any part of flyover help that you can share?
Just to confirm, is there definitely no mismatch in data types? For example, if '[dbo].[VIEW_POWERAPPS_BASIC_ACCTIVATE_DATA]'.ProductID is defined as an int in SQL Server, is MD_PartNumber defined as a numeric data type in SharePoint?
Yes.. Ive bailed on this approach. More later.
@timl ,
Ok... lets start over with what I'm trying to accomplish:
I have two collections:
Collection1([ID, MD_PartNumber,PartName,Rev,Status,Approved])
Collection2([ProductID,MD_PartNumber,Available,Cost,Location,Vender,Active])
I want to make Collection3([ID,MD_PartNumber,PartName,Rev,Available,Location])
I need Collection3 keyed on MD_PartNumber. MD_Partnumber is non-repeating in both collections.
I dont think it sounds complicated... I just cant seem to make it happen.
Hi @martinav
You should be able to do this with something like this:
ClearCollect(Collection3,
AddColumns(RenameColumns(Collection1, "MD_PartNumber", "MD_PartNumber1"),
"Available",
LookUp(Collection2, MD_PartNumber1=MD_PartNumber).Available,
"Location",
LookUp(Collection2, MD_PartNumber1=MD_PartNumber).Location
)
)
Thanks for posting in the community @martinav and I'm sorry you're experiencing this issue. Can you review the above reply and advise if it was helpful?
Thank you,
@Anonymous
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
267 | |
225 | |
76 | |
38 | |
37 |
User | Count |
---|---|
338 | |
224 | |
121 | |
71 | |
57 |