InfoPath Dev

This is a huge form and it has been previously designed with Rest calls. When dropdown value is changed, Using the Change the Rest URL functionality - Second dropdown Rest URL is changed to something like this - concat(URL, Listname?, "$filter=(Company_Value%20eq%20'", ., "') and (EnvironmentValue%20eq%20'", ...

 Sorry but our network prohibit us to upload anything but your understanding is correct. I just need to check if the coupon is already exist from other data source list  my logic here is like this  xdXDocument:GetDOM("random ...

You can use XPath to check and see if an item from one data source is present in another data source, sure. Perhaps if you attach your template on a reply (under the options tab) I'll better understand what you are trying to do.

would it be possible to compare two secondary data if the items is not equal to 1st data and 2nd data then the coupon code will show

I'm not sure how you are going to get a random item without some kind of logic to create a pseudo-random number.

Thanks for the attachment. I saw your logic but that was not the one I need and also its not based on the time. New items - check the coupon secondary data to get the list of coupon. For example it gets coupon123 before it will show the coupon123 it needs to check again the Main list (Secondary data) if the coupon123 exist already or not. If ...

Is there a complex filter here that requires you to use REST instead of a normal list connection with query fields? Have you verified anon access is disabled for SharePoint in IIS as per the replies here: https://www.infopathdev.com/forums/p/39193/123489.aspx#123489

So - here is a rough sample that uses the last three digits of the date time and the count of the "coupons" in my XML file to randomly select one. Save the file locally, right click and select design, then you can preview.

well it depends on how many lets say I have 200 different codes coupon. The logic would be everytime they add new items it will get automatically in that 200 list of coupons but before it will show it should check if that coupon exist in main list if not then it can select that coupon. Can you give me an example on how to do this? I added 2 ...

Hi, yes, in my case, I disabled anonymous access and it worked. I hope you manage as well.