Hi all,
I have made a cacading lookup fields. The filters works fine but i can't save the data to SharePoint.
Here is the distinct filter
Distinct(Filter( Choices(Testlijstje.DoctypeSubtypeArchief), Value in First(collArchief).DoctypeSubtypeArchiefopzoeken.Title ),Value)
On the update datacard i have add this:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: LookUp('DoctypeSubtypeArchiefopzoeken', DoctypeSubtypeArchief = DoctypeSubtypeArchief_DataCard1.Selected.Value, ID), Value: DoctypeSubtypeArchief_DataCard1.Selected.Value }
DoctypeSubtypeArchiefopzoeken = lookuplist
DoctypeSubtypeArchief = Column name
DoctypeSubtypeArchief_DataCard1 = name datacard
PowerApps say the code is invalid but i can't see why?
Solved! Go to Solution.
Hi @Anonymous ,
There is something wrong with your formula. You should use combo box control name to call the selected value, instead of data card name.
So you should modify your formula as below:
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: LookUp('DoctypeSubtypeArchiefopzoeken', DoctypeSubtypeArchief = DataCardValue1.Selected.Result, ID),
Value: DataCardValue1.Selected.Result
}
Please replace the DataCardValue1 to the similar name of combo box in the data card, and check if your issue is fixed.
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.
Hi @Anonymous ,
Coud you try to use DoctypeSubtypeArchief_DataCard1.Selected.Result?
Due to the Distinct() function, the return value is Result instead of Value. Please modify your formulas as below:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: LookUp('DoctypeSubtypeArchiefopzoeken', DoctypeSubtypeArchief = DoctypeSubtypeArchief_DataCard1.Selected.Result, ID), Value: DoctypeSubtypeArchief_DataCard1.Selected.Result }
Hope this can help.
Best regards,
Sik
Thanks for your answer, if i look at the autopopulate option, i can select result or value, etc.
See below:
Hi @Anonymous ,
There is something wrong with your formula. You should use combo box control name to call the selected value, instead of data card name.
So you should modify your formula as below:
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: LookUp('DoctypeSubtypeArchiefopzoeken', DoctypeSubtypeArchief = DataCardValue1.Selected.Result, ID),
Value: DataCardValue1.Selected.Result
}
Please replace the DataCardValue1 to the similar name of combo box in the data card, and check if your issue is fixed.
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.
Thanks for your answer, still an invalid argument type...
Here is the error, i got the update on the datacardvalue instead of the combo card.
Very frustrering, the solution works but can't update my card.
Hi @Anonymous ,
I want to confirm if the 'DoctypeSubtypeArchief' is the field of 'DoctypeSubtypeArchiefopzoeken'.
@Anonymous wrote:Here is the distinct filter
Distinct(Filter( Choices(Testlijstje.DoctypeSubtypeArchief), Value in First(collArchief).DoctypeSubtypeArchiefopzoeken.Title ),Value)
From the formulas above, DoctypeSubtypeArchief seems to be the column of 'Testlijstje'.
What is the column name that 'DoctypeSubtypeArchief' lookup to?
BR
Sik
Yes! It works now! I changed the internal name and now the Distinct and filters works perfect! Awesome, how can i thank you 🙂
Hi..
I have tried but its not works .
I have applied below formula
Distinct(PMMASTER,FormulaDescription) data not capture to sharepoint .
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
183 | |
76 | |
46 | |
37 |
User | Count |
---|---|
325 | |
258 | |
123 | |
72 | |
58 |