Trying to add one more query to my Flow

(0) Share

Report

Posted on by bobgodin

380

I have a Flow that joins 3 Sharepoint lists and is attempting to email a subset of data based on:

the date of a trip being equal to Today and less than 5 days in the future
where tripid in the Trips List equals tripid in the TripDetails List
and where the first officers name in the Trips List equals the firstname space surname in the MyDetails List

I build an HTML table containing data from all 3 Lists and then the intent is to email that to certain people

I have only recently added the GetMyDetails action - prior to adding it my Flow was working but was missing a column I needed from the 3rd List

When I run the Flow it fails with Action GetMyDetails failed but doesn't really tell me what is incorrect about my flow

My complete Flow is attached below - can anyone see what mistakes I am making - I am a newbie to Power Automate by the way - thanks

flow-problem.docx

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bobgodin Remove single quotes from left site of filter query.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15 thanks I did try that earlier - it comes up with Action Apply to each 2 failed and An action failed. No dependent actions succeeded.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bobgodin Use length() in compose after each get items action to check what no of items return by action

Pls share output.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15 if I run the Flow without the GetMyDetails action in it then I do get a report in my email - its about 20 records...

Was this reply helpful? Yes No
bobgodin 380 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15 the problem is - because I'm new to Flow I am not sure where I should put the GetMyDetails action - I have a feeling it could be embedded in an Apply to each action when it shouldn't be but as I said I am new to this...the report is about 10 records actually and I have attached a screenshot - so, the Flow without the GetMyDetails action works perfectly; I am just trying to filter the MyDetails List where the firstname and surname is equal to the officers column

activity-report.docx

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bobgodin Firstname and surname is a single column? or multiple column?

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
bobgodin 380 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hardesh15 they are separate columns

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bobgodin So how filter query will work? This should be something like this- Column1 eq '' OR Cloumn2 ne ''

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Verified answer

bobgodin 380 on at

Like
a
(0)

Report
Copy link

Link copied!
For reference and in case anyone else might be helped by this - I solved the problem by doing the following:
I had to filter on firstname being equal to the first part of the officers name and then filter surname on the last part:
first(split(first(split(items('Apply_to_each_2')?['officers'],';')),' '))
that got me the firstname

split(first(split(items('Apply_to_each_2')?['officers'],';')),' ')[1]
and that got me the surname
and then in my next Get Items action I filtered it like this:
firstname eq '@{outputs('firstname')}' and surname eq '@{outputs('lastname')}'

Was this reply helpful? Yes No