The requested operation is invalid. SharePoint Form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

So i have tried to make a form with cascading dropdowns based on sharepoint list.

Lets say we have Category: Item=

Choices('Tasks'.Category)

And custom Subcategory: Item=

Distinct(Filter(Ref_Cat,Title = DataCardValue2.Selected.Value),Subcategory)

Which works perfectly. It shows result from reference tbale where the subcategories are placed with category. Only one little issue is here and this is that the form can not be saved as its missing the original Subcategory column value. (Resulting in err. The requested operation is invalid. Server Response: A value must be provided for item)

I am sure its doable I have only forgot how and now I am completely lost.

Any Help please?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Shanescows 2,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't exactly follow but I think what you are looking for is Update property of your card. Each data card has an update property that is tied back to the data source. Fixing it will probably fix your error if my guess is correct.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Ok I'll try 🙂 @Shanescows

More specifications.

I have 2 list on SharePoint Online. 1. is live list called "tasks". Second list is only reference table for Category and Subcategory.
Eg.:

Category Subcategory
1                      2
1                      3
1                      4
1                      5
etc.

I have made custom powerapps form for the live list, where I made a new dropdown under card corresponding to Subcategory. Where I placed the function from 1st comment. (even If I change the default one it produce the same error)

Hope it is more clear.

Still not working as its operates with new item 😕

Filter(Choices('Tasks'.Subcategory),(Distinct(Filter(CCS_Ref_Cat,Title = DataCardValue2.Selected.Value),Ref_Subcategory_Col).Result))
So I thought it would be working but this produce table record insted of Boolean...

Or maybe a better question - How do I make Lookup Cascading Dropdown able to be saved within SharePoint List? No tutorials I have found does not include that.

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Still not completely following. I stink. 🙂

Can you watch this video on PowerApps Cascading Dropdowns and then tell me what you want to do based on this video? Is it just to save what I show in Job Titile (Dropdown2) back to SharePoint? So you would Patch(SharePointDataSource,YourRecord,Dropdown2.Selected.Value)

Is that the answer?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Shanescows thank you for your reply.

That way of making cascading dropdown is clear to me. And also its how I made it.

The issue is that my source is SharePoint online form. When I am making custom dropdown menu dependant on Reference table (in sharepoint its list) when There is Attribute A and Attribute B. Parallely by your scenario its Attribute A = Department Attribute B = Job Title. I load "Department" from the target list meanwhile the Job Title is loaded from Reference table, secondary list. So we are aspeaking about 2 data sources.

The dependant dropdown is able to lookup all possible selections based on "Department". But as I am selecting it, I am physically selecting choices from data source 2. Which means that when I am triing to save all the columns selections inside data source 1, I am unable to save it, because the field in data source 1 is not selected.

Department - Default choices from Data Source 1
Job Title - LookUped selections from Data Source 2, originally there is also Job Title in Data Source 1 with predefined same values as it is in the table in Data Source 2.
Other fields from source 1

So my Issue is to transform the selection from Data Source 2 inside Data Source 1.

I hope it is more clear now.

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Cool. You are moving in the right direction. So now watch this video. PowerApps SharePoint LookUp Columns

I think that is what you want here. I recreate the look up column functionality without using those evil columns. But it does pull from two lists and put everything back together.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Shanescows,
So I have done everything and there is another issue 🙂 Viz printscreen.

Until I change the items in the dropdown everything works, autoredirection to sharepoint is done, Item is saved. After lookup is in place, this occurs. And its occurs after second click on save button as for the first one it does nothing.

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What does your Update property for the datacard that is broke look like?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thats the default one DataCardValue3.SelectedDate
Settings of DataCard
...

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

That makes no sense. 😞

What I would do is create another similar list and see if going through the process that you have been causes the same issue. My guess is somewhere in trying to figure things out you got some wires crossed. Walking through it again my be the best next step.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Shanescows,

we are thinking the same way. The posted image is from second replication of the same list 🙂 Thats unfortunate 😞

Was this reply helpful? Yes No