web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / dataverse table details
Power Automate
Answered

dataverse table details

(4) ShareShare
ReportReport
Posted on by 2,249
We have below custom prompt where we used dataverse details for data input and we have also used powerautomate to shortlist the candidates based on the custom prompt inputs.
 
Here are my questions:
 
1.whenever  job description table in dataverse gets created, and lets say we have 300 job postings  items and few job status were closed ,inactive ,and few records seems to be active so how to ensure below custom prompt filters the data based on the status and is there a way we can filter only active or in progress statuses in the below prompt 
2Everytime it should not iterate the entire job postings dataverse tables where its inactive and outdated job postings but we are not capturing job statuses and there is no status columns for job descriptions.
3.How we can filter based on Job descriptions for the respective candidates in the below custom prompt
 
How to handle this one?
 
Kindly help
 
 
 
 
 
 
Categories:
I have the same question (0)
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at
    Hi,
     
    Answers to your questions
     
    1.whenever  job description table in dataverse gets created, and lets say we have 300 job postings  items and few job status were closed ,inactive ,and few records seems to be active so how to ensure below custom prompt filters the data based on the status and is there a way we can filter only active or in progress statuses in the below prompt 
     
    Answer- I see there is an option to filter the dataverse table by attribute /column value, so we can filter out the status column accordingly and get that rows/records from that dataverse table.
     
    2. Everytime it should not iterate the entire job postings dataverse tables where its inactive and outdated job postings but we are not capturing job statuses and there is no status columns for job descriptions.
     
    Answer- I didn't understand by this question, in the first question, you have mentioned there is a status column where you need to filter the dataverse tables in first question, so need more clarification over this.
     
    3.How we can filter based on Job descriptions for the respective candidates in the below custom prompt
     
    I think you can re-design the prompt as shown below
     
    Hi,
    
    Based on data present in dataverse table having details of job posting under Job description attribute, could you help me to find the job description which suits the below candidate's experience and skills as shared below
    
    Experience : {{Experience}}
    
    Skills: {{skills}}
    
    If you find any suitable job description matching experience and above skillsets, provide the job description value as output in following format shared below
    Shortlisted for given job description.
    
    if no such job description were found, provide output as not shortlisted.
    
     
    See whether this can help you !
     
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     
     
     
     
  • Veblitz Profile Picture
    2,249 on at
    Thanks a lot for your inputs
     
    here are some details for your queries
     
     
    1.whenever  job description table in dataverse gets created, and lets say we have 300 job postings  items and few job status were closed ,inactive ,and few records seems to be active so how to ensure below custom prompt filters the data based on the status and is there a way we can filter only active or in progress statuses in the below prompt 
     
    Answer- I see there is an option to filter the dataverse table by attribute /column value, so we can filter out the status column accordingly and get that rows/records from that dataverse table.
    2. Everytime it should not iterate the entire job postings dataverse tables where its inactive and outdated job postings but we are not capturing job statuses and there is no status columns for job descriptions.
     
    Answer- I didn't understand by this question, in the first question, you have mentioned there is a status column where you need to filter the dataverse tables in first question, so need more clarification over this.
     
    Additional Details: We dont have status column as such but what i mean by status here is that job postings were not in use or latest openings etc so in this case for shortlisting scenario we have built powerapps screen we have upload candidates document processing AI and it extracts the data and stores in sp list then we use dataverse for migrating data into dataaverse inorder to custom prompt confidence score accuracy of data,so in simple words,i mean that if we want to shortlist candidate for respective job postings and respective candidates i would need some right solution 
     
     
    3.How we can filter based on Job descriptions for the respective candidates in the below custom prompt
     
    I think you can re-design the prompt as shown below
     
    Additional details:  If we going to redesign as per your below custom prompt details then how are we check the confidence level in the context of accuracy of data then in this context how we check in powerautomate that if its shortlist or not shortlisted and i hope you know that the custom prompt text for shortlist is not same always and we cannot check  output is equal to shortlist as condition in the powerautomate(i.e.below screenshot condition)
     
                                                                                
     
  • Verified answer
    codeninja.sj Profile Picture
    115 on at
    Hi again:)

    1.whenever  job description table in dataverse gets created, and lets say we have 300 job postings  items and few job status were closed ,inactive ,and few records seems to be active so how to ensure below custom prompt filters the data based on the status and is there a way we can filter only active or in progress statuses in the below prompt 
     
    As @Nived mentioned, you can apply the filter on the dataverse table. Alternatively, you can instruct GPT to look for only active jobs, which would also work.

    2Everytime it should not iterate the entire job postings dataverse tables where its inactive and outdated job postings but we are not capturing job statuses and there is no status columns for job descriptions.
     
    Since there is no Status column in the table, consider adding one to extend the logic further. To achieve this, create a flow to sync the status updates from sharepoint to dataverse, assuming that sharepoint is the source of truth for your job listings.

    Alternatively, if the status is based on record creation or modification time, then instruct GPT to search jobs that are created or modified in the last X days.

     
    3.How we can filter based on Job descriptions for the respective candidates in the below custom prompt
     
    Since you already have a flow to shortlist candidates, you can use the same flow for this use case. When inserting candidate details into the shortlisted candidates table, include the job number or title as well. This change will help you to filter shortlisted candidates for a specific job directly on the sharepoint table without any new custom prompt again.
  • Veblitz Profile Picture
    2,249 on at
    I have defined the below highlighted thing in custom prompt but im not sure sometimes it generate pure html code, otherwise it is displaying unnecessary '''html  text codes etc as below in email notification
     
  • Suggested answer
    CU-19080006-4 Profile Picture
    2 on at
    .
  • Verified answer
    codeninja.sj Profile Picture
    115 on at
    Try this prompt instead: Generate the output in pure HTML, without any additional texts, comments, or code blocks


    p.s. if it's still not working, instruct GPT to remove the HTML code blocks from the response; or, include a sample HTML response to illustrate the expected format in the custom prompt.
  • Veblitz Profile Picture
    2,249 on at
    I used dataverse table for data accuracy but still its shortlisting on its own,kindly check the below example
     
    Dataverse Table Items
     
    Candidates List
     
    Selected candidate list -below data is inaccurate based on above details for candidates and job details table
     
     
    Custom Prompt:
     
     
     
    Flow to create item in selected candidates list
     
     
  • Verified answer
    codeninja.sj Profile Picture
    115 on at

    First and foremost, ask new questions in a separate post so that it will help others find solutions to similar problems more easily in the future.

    Now, to answer your question: The GPT generates responses based on the prompts you provide. If the results aren't accurate, try rephrasing vague instructions and making everything explicit for GPT to understand. Clear and precise instructions will yield better results. In the following prompt, I've made everything explicit, and it can be refined further. This is just an example of how to give clear instructions to GPT.



    Refer to the following AI Builder prompt engineering guide; it will help you create effective prompts: https://go.microsoft.com/fwlink/?linkid=2255775

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 535

Last 30 days Overall leaderboard