Skip to main content

#Flow150 diskutieren mit

Hi Tableau Community! I am looking to create a License Matrix for my org. We are currently going through a merger and acquisition, and we want to do an inventory of both environments.  

I have data prepped through Tableau Prep. Attached Excel file is the dummy data of the Output. 

I have also attached the Tableau .twbx of a WIP file.

 

Below is the License Matrix we want to create (numbers are not accurate. This is just a mock of what we want to recreate).

How to Create a Matrix?

 

Much appreciate the help! Any tips would be great. Please note I can use Tableau Prep to massage the data if required. 

 

#Tableau Desktop & Web Authoring  #Flow  #Reports & Dashboards

2 Antworten
  1. Heute 12:13

    Hi @David Wong. You can create two Level of Detail expressions that check the east and west access for each user. The access count field in your data seems redundant with the access level. 

     

    East Privileges

    { FIXED [User]: MAX(IF [Environment]="East" THEN [Environment] + " " + [Access] END) }

     

    West Privileges

    { FIXED [User]: MAX (IF [Environment]="West" THEN [Environment] + " " + [Access] END) }

     

    Then you can create the matrix, first showing the user names for debugging, then counting them for your final output. TWBX attached. 

     

    debuggingHi . You can create two Level of Detail expressions that check the east and west access for each user. The access count field in your data seems redundant with the access level.

     

    final outputimage.png

0/9000

I complete all the steps, and my end result is working as expected (screenshot below), but it still doesn't pass me: "The 'Translate Survey Input' action is either missing, named incorrectly, or not positioned after the existing Get elements in the 'Translate Fitness Survey Input' flow. Review the 'Work with the Prompt Template in a Flow' scenario and related Help article for element configuration."

 

Agentblazer Innovator | Superbadge: Translate Text with a Prompt Template and Record-Triggered Flow

 

I've started from scratch a few times and used a new org, but no luck. Can anyone help? Am I missing something? 

 

Screenshots from my setup: 

 

Screenshot 2026-10-02 at 4.02.40 PM.png

 

 

Screenshot 2026-10-02 at 4.02.57 PM.png

 

 

Screenshot 2026-10-02 at 4.03.50 PM.png

 

 

 

 

 

 

#Trailhead Challenges  #AgentblazerInnovator  #Trailhead Superbadges  #Prompt Builder  #Flow

0/9000

I have a screen flow on a campaign page that a user can run to tag all related opportunities (Donations actually, this is NPSP) for further processing, which will be thank-you letters in Apsona. It basically just un-checks a checkbox on all donation records that are checked from last time, then checks the same checkbox for all donations related to the current campaign. 

 

I have an on-update flow that normally runs when a donation record is updated, but I DON'T want it to run when that screen flow causes all those updates. 

 

When the number of donations gets too large, I end up with

Apex CPU time limit exceeded

errors. 

 

Any thoughts? Thank you!

4 Antworten
  1. Heute 15:47

    I wanted to come back and close the loop on this (one of my pet peeves is when people leave issues open, or worse, close it out with "I figured it out" and NOT provide details for others who come along!). 

    Because that particular checkbox field is used exclusively for this purpose, I added the following entry condition to the "big flow" that typically runs every time a donation (opportunity) record is created or updated. 

     

    Condition: Formula Evaluates to True 

    NOT( ISCHANGED({!$Record.For_Apsona_Merge__c})) 

     

    #Apsona

0/9000

I have a flow that creates a Conversion Event record (custom object) whenever a Campaign Line (CLN) record (related custom object) is created (via the Clone button). Typically, there are multiple Conversion Events, which are auto-numbered, related to a CLN. The intention of the flow is to clone/copy over those Conversion Events from the old CLN to the new cloned CLN without the user having to recreate them.  

In the flow, I use a Get Records to pull all the Conversion Event info from the previous CLNs and then loop through all the records and use an Assignment to assign the values to the field variables and a Collection to hold all of the newly created records. However, I have one field, a picklist that is just a list of numbers 1-20, that doesn't always pull the number from the looped records and populate in the new Conversion Event record. 

Does anyone know why this would happen and how it can be fixed? I'm wondering if there is something nuanced about using numbers in a picklist that I don't know about? 

Thanks! 

 

#Flow  #Flows

3 Antworten
  1. Heute 05:33

     Hii Lisa,

     

    The 1–20 picklist values are not the issue. I would check the Flow’s loop or assignment

    pattern first.

    Make sure the picklist is assigned directly from Current Item from Loop to the new record variable, then add that record variable to the collection. Create the records after the loop, not inside it. Salesforce specifically recommends this pattern because the Current Item is reset on each iteration.

    Also verify that the picklist values are "Active" and available for the target "Record Type"

     (and controlling value, if it’s dependent). 

     

    Check this for references: 

     https://trailhead.salesforce.com/content/learn/modules/loops-in-flow-builder/build-a-loop

     

    https://help.salesforce.com/s/articleView?id=platform.troubleshoot_picklist_values.htm&type=5

0/9000

Hello! 

 

I want to create a flow that launches a case, but only on a quarterly basis.  I am not seeing where I can do that in the flow. 

 

BB 

 

#Salesforce Admin  #Salesforce Developer  #Flow

4 Antworten
0/9000

For a Template-Triggered Prompt Flow using the 'Service Email Summary Template Capability,' the only input available is plain Email Content text — no Case ID or record reference. Is there any way to also pass in a Case record or its fields with this specific flow type and capability, or is that a hard limitation?

 

#Trailhead Support  #Flow  #Prompt Builder  #Einstein For Service

1 Antwort
  1. 30. Sept., 18:12

    @Tugba Salis

    your read is correct here - this is a hard limitation, not something that you are missing in the config.  

     

    Standard capability templates have a fixed input defined by the feature that invokes them. Einstein Email Summaries fires against the email itself, so the capability hands the template the email content and nothing else. 

     

    So the way I see it you have two options here:  

     

    Option 1 - you may be able to parse the Case Id from the email text. If your org uses ref ID threading for Email-to-Case, then the case id would be in the email body, and you can use the prompt flow to parse it out.  

     

    Option 2 - build a Flex template instead. Flex templates let you define your own inputs, so you can pass the Case record and use it how you please. You can use this through a quick action / screen flow / agent action / apex - whatever works for you. 

     

    Let me know if that makes sense  

     

    Thanks 

    Steve 

     

     

0/9000

🎉 Big shoutout to our incredible Forum Ambassador & Salesforce MVP @Ajaypreet Singh Saini for an awesome deep dive on "Display Record URL as a hyperlink in Chatter post using flow"!📘 Check out the article here >> https://help.salesforce.com/s/articleView?id=005460491&type=1

 

 

🔍 Found it helpful? Have thoughts to share?

 Let us know by clicking the "Yes" or "No"  button at the bottom of the article—your feedback helps us improve!🎉 Big shoutout to our incredible Forum Ambassador & Salesforce MVP for an awesome deep dive on> 🔍 Found" style="display: block;" /> #Flow

 

 

1 Kommentar
0/9000

I'm working on a Flow that needs to update a large batch of related records (a few thousand) triggered from a record update on the parent object. I've read that Record-Triggered Flows can run into governor limits or performance issues at scale, and I'm trying to figure out the right pattern before I build this out further.

For those who've dealt with bulk updates like this — is it better to handle this with a Scheduled Flow / batch approach instead of a real-time Record-Triggered Flow, or is there a cleaner declarative pattern I'm missing? Trying to avoid needing an Apex trigger if possible, but open to it if that's genuinely the better path here. 

 

#Flow  #Automation@Salesforce Flow Automation

1 Antwort
  1. Gestern 13:59

    The limit for number of records to be updated before hitting a limit is 10k across all DML statements (see documentation) so you should be able to use an assignment and a collection variable to update the value(s) needed and then do the update DML on the collection without an issue based solely on what is described here. I personally don't like scheduled flows as I've encountered some unexpected/unexplained behavior with them. Hope this helps!

0/9000

Hi All, 

 

We have an  Invoice and We need to remove the comment.

I tried to remove the comments using Salesforce Inspector, but the Edit button is disabled. This could be because the invoice has already been approved and the ProcessInstanceStep object, ,which  is read-only.

Could you please advise on how we can remove these comments?  

 

 

Request to Remove Approval Comment from Invoices

 

Thank you in advance  

 

#Salesforce Developer #Sales Cloud #Trailhead Challenges #Salesforce Admin #Agentforce #Flow #Agentforce

1 Antwort
  1. 30. Sept., 15:27

    Hi @Roopa Sharma -  ProcessInstanceStep is read-only, and the approver comment cannot be edited or deleted after the approval step is created. Salesforce Inspector won't be able to update it. If the comment must be removed, you'll need to consider resetting/recreating the approval 

0/9000

Hello everyone

I need help to complete a unit in a trailmix set up case esclation project

Unit :create an automation with flow builder

I created the automation flow process but while I create the case to taste the flow

It gives me this message

And I tried to delete the flow , but it can't be deleted too!

Any help, please?

Thanks

#Trailhead#Flow #Automation
3 Antworten
  1. Eric Burté (DEVOTEAM) Forum Ambassador
    29. Sept., 22:49

    Hello @Mohamed Magdy

    make sure you have well set up all lines with ID in your flow configuration items. See for example the note from within the trailhead unit : "Note: Make sure you select the Account ID option that has a Record data type, signified by a > in its row. Could you please also provide us a debug trace of your flow, or screenshots of your configured elements from within your flow ? 

    Eric 

     

     

0/9000