Hi everyone,
I 'm a beginner on PowerApps (no background as developer) and I have a problem with the application I'm trying to create.
The purpose of the application is to manage investment fund. For Each fund, several reports can be attached. This app is based on a Dynamics CRM (There is a one-to-many relationship between the fund entity and the report entity).
The workflow is:
I have two problems:
Gallery_report.Items : Gallery_Funds.selected.Rapports
Do you have an idea to solve my problem?
P.S. : I hope to have been clear. As you have probably noticed, English isn't my native language.
Screenshots :
Solved! Go to Solution.
Hi @v-yutliu-msft !
I have been able to get this worked by using Common Data Service as the data source instead of using Dynamics 365 as the data source.
Hi @F4b ,
1)I suggest you try this formula: (set the Gallery_report's Items):
Filter(report, look up column name.reportID=Gallery_Funds.selected.reportID)
Please replace the look up column name and reportID with the field name that you use.
Look up column is one column in report entity.
reportID is one column in fund entity.
2)Please add the look up field in the edit form. (it will be a combo box by default)
Set the look up field's combo box 's DefaultSelectedItems: Gallery_Funds.selected
Then, the look up field will be automatically filled with the data of the selected fund.
Best regards,
Community Support Team _ Phoebe Liu
Hi @v-yutliu-msft ,
Thanks a lot for your quick answer. It really helped me !
However, I still have a problem on the second point : I can't link the report submitted to the fund.
DisplayFields : [createdby_type] SearchFields : [createdby_type]So, I modified Datafield and DisplayName (screenshot 2) and the combobox displays the GUID. Then I tried to Display the fund name but it didn't worked.
Fonds_DataCard13.Update : LookUp([@Fonds_1];Fonds = ThisItem.Fonds;Nom))
Screenshot 1 :
screenshot 2 :
Hi @F4b ,
I've made a similar test for your reference:
Please not firstly inset the lookup field to the edit form.
Firstly set the edit form's Item.
Then, insert the lookup field to the edit form.
If you want to display fund name in the combo box, set the combo box's DispalyName, SearchName to "crb4c_fieldname" . The fieldname is the field that you wat to display(fund name).
Here's my test:
testone is my look up name, Name is the fieldname in the other entity that I want to display
Best regards,
Community Support Team _ Phoebe Liu
Hi @v-yutliu-msft ,
Thanks you for your answer, it really help me again !
however, I still have an error. This time, the error is on my submit button. Code :
Icon3_5.OnSelect : SubmitForm(Form_Reports)
The error is : "the requested operation is not valid. Server response: a value must be provided for the element"
The only required field is the field "Nom" (the report name). I tested and it works if I don't have the Fund lookup in Form_Reports. So I think the problem comes from there.
I saw that there were several posts about it on the forum but I didn't find a solution to my problem.
If you have an idea... 🙂
(Thanks a lot again)
Hi @F4b ,
Do you mean that you can not update successfully because the look up field?
Here's my test:
The LookUp field's control is a combo box
The Combo box's Items: Choices(testmanies.crb4c_testone)
One your side you could try: Choices(report.crb4c_fund) (the red part is the "many" entity name, green is the "one" entity name) (many-to-one relationship: report-to-fund)
The Data Card's Update: DataCardValue9.Selected (DataCardValue9 is the combo box's name)
Best regards,
Community Support Team _ Phoebe Liu
Hi @v-yutliu-msft ,
Yes, I think I can't submit the report's form because of the lookup field (because the submitting worked whithout it).
The combo box and the datacard are already configure as you indicated.
Hi @F4b ,
Please check whether you have required field.
I've found a similar issue for your reference:
Best regards,
Community Support Team _ Phoebe Liu
Hi, @v-yutliu-msft,
I don't think it's same issue.
Hi @v-yutliu-msft !
I have been able to get this worked by using Common Data Service as the data source instead of using Dynamics 365 as the data source.
User | Count |
---|---|
247 | |
106 | |
82 | |
50 | |
43 |