-
SharePoint Online? What about using Power Automate? There is a SharePoint HTTP Request action that I've used in the past for modifying permissions.... This sample is a bit old (so the screenshots / steps may not match what is currently available), but may get you started: ...
-
I wouldn't think so - if you are just summing by Field Office from the same data source. I'd probably drag the data fields from the data connection onto the form and take a look at the raw data to get a better idea of how to group it.
-
Perhaps try this one. You want to get the "brand" from the same data source as the initial dropdown is using for its data - so that's the main change I made. You need to right click the linked file and select save as to save the file locally. Then you can right click the saved file and select Design to open in design mode.
-
Maybe try: sum(../d:SharePointListItem_RW/d:Total_x0020_Contract_x0020_Value[../d:FieldOffice = current()])
-
So - your filter looks right. But what is providing the values for the "brand" drop down?
-
What would help most would be a copy of the form. :)
-
Hi! So - you need to add a receive data connection to the Campaign Master List to your form. You will likely want to sort it by campaign name - that is one of the options on the screen where you select the list fields in the data connection wizard. On your dropdown field in your form, you'll add rules to set other field's values. When you ...
-
With your form open in Design mode, under the data tab, if you click the "refresh fields" button, what happens?
-
I'd create a new blank test form. Add a data connection to the user profile service. Don't query on load. Add a calculated value to your form that shows the userName() function. Put the query and data fields from the user profile service data connection on the form and a button that runs the query. Publish as a browser enabled form to a ...
-
Happy to help. I used InfoPath for something like ... 5 years? 7 years? before I found that dropdown. ¯\_(ツ)_/¯