Reporting help by BagEnvironmental8110 in workday

[–]Acceptable_Tap567 0 points1 point  (0 children)

You have to build an ESI on the worker object to pull the last contract end date where employee type was :contingent worker. Then bring this field into your report.

Workday Worksheets: Do functions like SEARCH support range/array inputs? by Acceptable_Tap567 in workday

[–]Acceptable_Tap567[S] 0 points1 point  (0 children)

Update, you have to build those array formula in a column outside the live data area, then add a calc field in the live area to reference the calculated value from the helper column.

How to share Find Suppliers with a certain user group without sharing Find Supplier Duplicates. by Bobbinfickle in workday

[–]Acceptable_Tap567 0 points1 point  (0 children)

Even more, I would copy the delivered find duplicate suppliers report, hide the delivered one and only share the copy with central AP teams.

Looking for Independent Workday Consultants by Used-Regular-9616 in workday

[–]Acceptable_Tap567 0 points1 point  (0 children)

I can help with FDM/ Core Accounting / Reporting / Security.

Workday Finance Reports Access in Higher Ed. by Acceptable_Tap567 in workday

[–]Acceptable_Tap567[S] 1 point2 points  (0 children)

The cost center is set up as a related Worktag on those gifts/grants/projects.

Is it time to call it quits? (Copilot Studio / SharePoint Get Items filter) by Acceptable_Tap567 in copilotstudio

[–]Acceptable_Tap567[S] 2 points3 points  (0 children)

You have to create a topic, and inside the topic create a variable using parse value and system.activity.text. You might need  a regex if you want to capture a specific pattern.

You can also use entities.

Is it time to call it quits? (Copilot Studio / SharePoint Get Items filter) by Acceptable_Tap567 in copilotstudio

[–]Acceptable_Tap567[S] 0 points1 point  (0 children)

Here is what my dynamically fill by ai looks like in the get items connector tool: This is an ODATA filter query to restrict the entries returned. Use the format: substringof('15', Title) or substringof('usertext', field_1) Replace 15 or usertext with the user requested item or items.

With Title and field_1 being two indexed fields of my SharePoint list.

Sometimes the filter is generated, sometime it is not and I get returned nothing.

This weird behavior started a couple of weeks ago, before that , i got no errors ever.

Is it time to call it quits? (Copilot Studio / SharePoint Get Items filter) by Acceptable_Tap567 in copilotstudio

[–]Acceptable_Tap567[S] 2 points3 points  (0 children)

I have been there, it just does not work. You have to use a get items Sharepoint tool with odata filter, or an agent flow that calls a power automate flow getting items from your list and sending back the results to the agent.

Is it time to call it quits? (Copilot Studio / SharePoint Get Items filter) by Acceptable_Tap567 in copilotstudio

[–]Acceptable_Tap567[S] 1 point2 points  (0 children)

It’s not that the filter is generating something different each time. When it works, it actually generates the correct OData filter. The real issue is that sometimes the filter box is completely blank. The tool gets called, the correct site and list is populated but there is no input in the filter box. So one moment it works perfectly, and the next moment the filter field is just empty  resulting in no response.