-
See attached. I also added some screenshots to help you with creating this type of formatting rule. :)
-
I think your post got cut off. Let me know if there is an issue I can help you with.
-
In the new section, you only want the rows where the SO Number is blank, is that right? I'm sorry - I'm getting confused as to what you want displayed where. At any rate, I made that change in this version. The preceding-sibling rule is so each vendor only shows once? Since I don't know what your list data looks like, I don't know ...
-
Did you copy the formatting rules from the other table to this one? Right now, there is a formatting rule checking if the SO Numbers match. I think instead you just want to check if the SO Number (in the secondary data source, that the repeating section is bound to) is blank, right? Want to give that a try?
-
It looks like the first condition on the new table to only show each vendor once might have been causing the issue - I changed that. The vendor name in this case is the "title" field.
-
Flow is the same thing as Power Automate - Microsoft rebranded it a year or so ago. I'm guessing you'll have a transition phase where you'll be able to get your form published to SharePoint Online, do some testing and add the Flow to populate your list prior to your users starting to use it in the new environment? You'll want to ...
-
Ah, perfect, problem solved! Glad you got it published. :)
-
Ok - so if in my environment words don't break in half and in yours they do - that likely comes down to SharePoint updates, which, of course, is then a matter for your SharePoint admins....
-
Ok, thanks - so the options in field8 are unique, regardless of what is selected in 103? Are there a lot of list items that would match on field8 in the list? Is the data you are seeing in your calculated fields just entirely wrong, or earlier data, or blank? Because your XPath looks right for selecting items that match on field8, but if there are ...
-
Here's a screenshot of the SharePoint Column settings for the control that is working well in my environment (from my earlier screenshot) in case that helps. You might want to create a test list for yourself with columns of the different data types and a customized form - then you'd have a reference.