InfoPath Dev

 Perfecto...!! Thank you, that worked as described :)

Hello, I'm working on an dynamic stock system on sharepoint with Infopath, but I cannot figure out the cascading fields in Infopath. ( i tought cascading fields was also possible within sharepoint but this area is grey, i cannot select tables?). Anyway, I created 5 tables on sharepoint: - locations - products - users (there is a lookup ...

I see - you are talking about a validation rule. If you use a field in the data source and use your formula for the default value, you can add a validation rule. But if you are just displaying the results of a calculated value, no, you can't add validation rules to that. I'm attaching a simple sample with a validation rule on a field. Save ...

 PWR Annual Fire and Life Safety System ITM Compliance List.

It is a calculated InfoPath field. By notify I just mean a prompt or whatever that says "This needs to be at least 50K." I can do this easily on any other field type but it does not work on a calculated field. That type of rule Is not available, Make sense?

What is the name of the data connection with the "status" column?

What do you mean by user is notified? Something is displayed on the form? And is this a field with a default value that is calculated, or an expression box on the form?

I think the User Profile service does work in Office 365. All you have to do is not run the query on form open, and in a form load rule, set the query field to the username function and execute the query.....

Hi Hilary The data connection is using a SQL login and password and not using integrated auth. I'm not sure what the message is when the details button is clicked. I will contact the client next week when I back at work and see if there is anything in the message that can identify. I will also double check the firewalls are allowing SQL ...

 Posted here: http://www.infopathdev.com/blogs/hilary/archive/2017/04/14/powerapps-user-research-panel.aspx And I've put this post on my list for our social media person to tweet in the near future, so hopefully that will also help with traffic. Off to take the survey now, so glad you are reaching out to our ...