InfoPath Dev

Hi-- just a heads up, I only have InfoPath, SharePoint OTB w/no access to SPD. Is it possible to use a People Picker field to return the work email address and use that email address in your Email Submit connection. Example-- I have a 'Task' SP site. The user that submitted the request uses a People Picker field, and I would like for ...

What does your formula look like? Be sure to tick the edit XPath box so I can see the whole thing....

 Thanks Hilary! I got most of this to work. I get the intended concatenation for each repeating data entry, but it always grabs the first piece of data, for instance if my first input was 1111 and I added another row as 2222 the destination field would display 1111, 1111. I can't seem to get the right combination.

Thanks Hilary, I see now that SharePoint makes it easy to add months to a date, and integrates it even for leap years in a calculated column: =DATE(YEAR(originalDate),MONTH(originalDate)+6,DAY(originalDate)) More on formulas ...

Dates are formatted yyyy-mm-dd in XML. Date time fields are formatted yyyy-mm-ddTHH:MM:SS. So if you are populating a date field, you'd use a concat formula to put your numbers in, separated by hyphens, like 2020-01-23. If you need a date time, because your field is a date time field, you can use 0s for the time, like 2020-01-23T00:00:00.

Update: I got extracting year (and month) as numbers: YEAR(dateField), leaving datatype as number. After I do my math, how do I insert the new number into a date field?

Yeah, you can use a double eval for this: http://tinkerersjournal.blogspot.com/2013/01/codeless-double-eval.html

Hi, Here's a question that should be fun. I want to set a date field to a date 6 months in the future. I see posts about subtracting date/times that look extremely hard and complicated. I only need the number of months. I suppose it will involve extracting the year and the month separately and using a formula. Does the extration have to be ...

These steps worked perfect - thank you!

We're dropping IE soon.  SharePoint 2013 form libraries and SharePoint 2019 form libraries in Edge or Chrome do not open SharePoint Form Library form templates in the client application, InfoPath, for users to fill out.  Both browsers give an error that the form cannot be opened in the web browser.  Form library is set ...