Get Items/Query Flow

(0) Share

Report

Posted on by RJF61

1,265

Hello,

I am new to Power Apps and am having trouble with the "Get Items" process. At this point, I'm not sure if the "Get Items" is the best method for what I am trying to accomplish.

I have two lists 'EmployeeShort' and 'Assessment'. When an individual enters a record in 'Assessment', I want a process to lookup their "Supervisor" from the 'EmployeeShort' list and update the "SupervisorLU" field in the 'Assessment' list. At this point I am using Get Items in a Flow but am receiving the error shown.

The item blacked out is an accurate value and is the result of the "Update Item" portion of the Flow (field is a 255 character text that is the DisplayName value of Created By) and is located in the 'Assessment' list. The "FullName" field is located in the 'EmployeeShort' list multiple times.

The Flow I have created is below.

I assume my issue is related to the relationship for obtaining the Get Items but need some assistance. As shown above, the Flow currently fails at the Get Items Step.

Thanks for any assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @RJF61 ,
You did not include the Advanced Options to show the actual filter, but you would normally need

FullName eq 'Homer Simpson'

Have you used single or double quotes ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

Hello @WarrenBelz

Thanks for your response. Following is the Advance Options portion. I did use single quotes but it did not appear to make a difference if I entered FullName eq 'CreatedByDN' or FullName eq 'CreatedByDN. Not sure if this is an issue; however, CreatedByDN is the result of a previous Flow.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @RJF61 ,

The first one is correct (enclosed in single quotes). It is also necessary that CreatedByDN is a string and (obviously) that FullName is also a string (have you looked at the Flow output to see what is returned?) The error appears to be that one is not a valid string.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @RJF61 ,

You are getting Items from the list EmployeeShort where the field Fullname in this list (which we have established is a Text field) matches the output of the previous Flow in the field CreatedByDN. You have shown that the original field is also Text, but how are you outputting this from the other Flow - I would suspect that it coming out as something else.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

Hello @WarrenBelz
So, again new to the Flow process, that is some of my concern. The first Flow is updating CreatedByDN with the CreatedBy DisplayName when a new record is created. Does the 2nd Flow need to run after the CreatedByDN is updated (otherwise no information would be available)?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @RJF61 ,

How is the first flow linked to the one you have posted (or a better question how and when is it run)? The data certainly needs to exist at the time the one in your post is run. I suspect the field is blank at the time.

Was this reply helpful? Yes No