General

Re: SharePoint List form look up values

Brocante — Thu, 28 Nov 2019 20:40:42 GMT

Also the thing I want to incorporate onto my list is actually this image below the "1" is the main list and the "2" is when you actually click on a name, you see more information, i'm trying to find how to incorporate this, maybe in a more minimalistic way (or not) onto my own list. Should i keep looking how to connect web parts? I want to know if i'm looking for the right information online haha

Re: SharePoint List form look up values

Brocante — Thu, 28 Nov 2019 19:16:31 GMT

Thanks! I'll have a look at it! I'm using the 2016 SharePoint version by the way.

If i may ask another question, this list is made as a form that we need to send, it sends an email to an email box for the managers. When an employee fills the form and he's ready to send it, the actual "button" to send it is named "save" and looks like a classic floppy disc button. Do you know if there's any way to modify this so it shows "Send" instead of "Save"? and maybe a different image instead of the floppy disk.

Thanks again for all the help

Re: SharePoint List form look up values

Hilary Stoupa — Tue, 26 Nov 2019 17:54:10 GMT

You might be able to set something up on a web part page - I think there are ways to connect the web parts. I'm not sure what version of SharePoint you are using - so take that into account when searching for info. Here's a link for SharePoint online: https://support.office.com/en-us/article/connect-web-parts-in-sharepoint-online-b457668c-d843-4b1b-8977-a6f9228a1dec

Re: SharePoint List form look up values

Brocante — Tue, 26 Nov 2019 17:28:42 GMT

Thank you very much again, I can see now which filter you used, as it was really confusing to me too. I didn't know which one to pick as i'm quite new to InfoPath too, and i'm working with lists created by colleagues no longer working for us.

You've been really helpful, but I got another question for you! Would it be possible, on the list itself or maybe to the right of it, to have a sort of compilation of all the demands that were made (This is a list created so we can send emergency situtations to adjusters) on that day, where you could select, for exemple, a province and it would show the last demands made in the last 24h for that province? (depending on the adjuster also)It would be possible to backtrack i guess for all the requests made but the main option would be to see the last 24h requests.

I know i'm asking for alot here, and you helped me so much already, so tell me if it's possible at all, or otherwise where to get the information myself to be able to do it :)

Thanks again

Re: SharePoint List form look up values

Hilary Stoupa — Tue, 26 Nov 2019 15:46:17 GMT

For the UI question with the screenshot - yes, just delete that off the form. It was only there so you could see what data is returned and can be deleted. For the first part... for the filter on the Hibou dropdown - the dropdown values are provided by the Hiboux data connection. The repeating data node in that connection is filtered to only include items where the ID of the item (in the Hiboux data connection) is equal to an ID in the Hiboux3 data connection where there is a Disponibilité Value that is equal to the Province selected in the main data source. And the reason it took so many attempts to figure out was that I didn't really understand what data was being stored in the Disponibilité field in SharePoint - it just took me a few rounds to grok it. :)

Re: SharePoint List form look up values

Brocante — Tue, 26 Nov 2019 13:45:01 GMT

Ms. Stoupa thank you so much, from the bottom of my heart, i believe it now works!! When i pick a province and see the adjuster's availability, it shows the correct ones!! That's so great!

I have two questions for you :)

Which filter did you pick? I'd like to know which one, so I don't have to bother you again with this!

Also can i remove the last part on the list, or even if I publish the list it wont show?

I'v added a picture of what I mean.

Thanks again!!

Re: SharePoint List form look up values

Hilary Stoupa — Fri, 22 Nov 2019 15:53:03 GMT

Let's see if this one is any closer.... I seem to keep confusing myself. :)

Re: SharePoint List form look up values

Hilary Stoupa — Thu, 21 Nov 2019 23:56:00 GMT

Sorry - didn't have a chance today - I'll try to take a look tomorrow. :)

Re: SharePoint List form look up values

Brocante — Thu, 21 Nov 2019 17:37:08 GMT

Thank you very much for your time

Re: SharePoint List form look up values

Hilary Stoupa — Thu, 21 Nov 2019 17:36:30 GMT

Ok. I'll try to take another look later today and see if I can make a better guess at the right filter.

Re: SharePoint List form look up values

Brocante — Thu, 21 Nov 2019 17:26:21 GMT

here's what it looks like if we go and fetch marc's info on the list, see he has nothing Under "disponiblité"

Re: SharePoint List form look up values

Brocante — Thu, 21 Nov 2019 17:23:10 GMT

What's weird is that it's showing one of the adjusters, for QC (seen in the screenshot) but he's not even available today (Under "disponiblité) When i pick Québec Under provinces on the list, it should show the three persons on the post above (Jean-Pierre Lapres, Pascale Leclerc, Martine Brisson)

Re: SharePoint List form look up values

Hilary Stoupa — Thu, 21 Nov 2019 17:05:13 GMT

OH! So the availability in the list is updated every day, with the users having the province(s) they are available for entered into that field? Maybe try this one. I changed the filter on the dropdown.

Re: SharePoint List form look up values

Brocante — Thu, 21 Nov 2019 16:56:51 GMT

Another exemple

Re: SharePoint List form look up values

Brocante — Thu, 21 Nov 2019 16:55:02 GMT

Hahah in fact you didnt misunderstand at all! I clicked on "disponibilité" which is the availability, and it shows now the values, I believe the other names on the screenwshot werent available for today that's why we couldnt see anything :)