You’re offline. This is a read only version of the page.
559
Hi all,
I have a SharePoint list called consumption where two columns are there planned competency and planned asset (both are multi line of text). In PowerApps I have three combo boxes project name, Competency and asset name. When value is selected in combo box I am displaying it in the gallery below. My requirement is when project name, competency and asset name (multi-selected) is selected it must display in gallery and save to SharePoint list also. It must be displayed as I have shared the sample excel screenshot for the same. It must be displayed the same way in gallery and saved to SharePoint in the same way. On change of the asset name combo box, I have the code attached below. Variable gallery is the variable I have used to concat the asset names and wstring to display in the same line. Gallery details is the collection variable I have given in the items property of gallery.
Any help or suggestions on this, whether it can be done?
Thanks in advance.
So you are suggesting to save without data source? But my requirement is with SharePoint only. They need it to be saved in SharePoint and the data must be retrieved from there only because few flows are getting triggered from there.
SharePoint is my data source being used. My requirement is with SharePoint only save and display must happen.
If it's not possible with a single gallery can we try multiple galleries?
Thanks, that does help.
However, these 2 requirements are conflicting in your current app/data setup:
1. My requirement is when project name, competency and asset name (multi-selected) is selected it must display in gallery and save to SharePoint list also.
2. It must be displayed as I have shared the sample excel screenshot for the same.
This is because with your current app setup, a user selects
1. A Project (single select)
2. A Competency (single select)
3. Assets (multi select)
So, if we save the above using requirement No.1, a single save/record would look like
Yet, your second requirement would mean a single save/record looks like
These are conflicting was of doing what you are trying to achieve.
Can I ask why you need SharePoint to display like the above? This is much easier inside an app, because MultiLine of text column 'Compentency' needs to know how many 'rows of data' the column 'Assets' has for the 'record' above it so it can be visually appealing to the SP user. Personally, I'd scrap that requirement and just have users interact with an app.
To get the number of 'records' related to the previous 'Competency' record you would need something like a text column holding numbers separated by commas eg 2,1,3 ... etc
Could you please explain further.
As I said before I have three Combo box in PowerApps Project Name, Competency and Asset name. The Project name combo box filters all the Project names from Master list. Competency combo box it filters all the values from Competency master list. When Competency is selected from Competency combo box it filters the Asset name which is applicable to the competency from a list called Contribution list. To get all these values from different list I have added 3 combo box in a form control which is the screenshot I have attached before so why I don't want to use choice columns as column data type.
I have not used any data table. I have only gallery and form control. Form control has the 3 combo boxes and the gallery must display the values selected from the combo box and after saving to the SharePoint list it must display the saved values from list too.
The 3 values which must display from SharePoint list in the gallery is consuming Project name (single line of text), Planned asset (multiple lines of text) and Planned Competency (multiple lines of text).
For saving and displaying in the gallery should be of the same format as i have mentioned earlier.
I hope you get the scenario now.
Based on the competency selected what all asset name is available for that data analytics competency only will be loaded in the combo box. So user can select either single or multiple asset names from the combo. I have this code to get the combo selected asset names and wstring to display in the single line: Set(variablegallery,Concat(Self.SelectedItems, Knowledge_Asset_Name& ", "));
Set(wString,Left(variablegallery,Len(variablegallery)-2));
What to be done to display both ways in gallery?
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
Share
Report
All responses (
Answers (
