MS Form (Checkboxes List) data - Search for Users (V2) - Get Display Name then Create Different Rows for each Checkbox item with their DisplayName

(0) Share

Report

Posted on by berebel

Dear Community,

I have an MS Form (Checkboxes)

I am trying to Automate this process - if I check Jhon, Jack or Nick, or All of them

It should create (say you ticked/checked 4 people in the MS Form) - it should create 4x Rows for 4 people - with their Office 365 Display Name

The problem with this is - it only finds the first item i.e. first item from the MS Form

E.g. It only finds Saunders, Jack but for the rest it gives error -

If I replace Jack with John - find Joh but not Jack!

Please can you advise - what am I doing wrong?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@berebel Pls share your flow screens. It will help us to diagnose your issue.

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
berebel 45 on at

Like (0)

Report

Dear Hardesh,

Thank you very much for offering me your help.

I thought I deleted this post - but looks like it did not go through.

I was making a mistake in the form itself - while copy-pasting DisplayName - from GAL to Form - one extra space was getting added in the form after the first name... silly me!

Once I rectified that - it started resolving all names to their relevant display name.

Here's one problem - which I am not able to solve - i.e. if you have 4 Smith, John in your organization - it makes 4 entries in SharePoint List - if you are creating item after ... You cant actually tell Flow - which John Smith you need.

Is there a way .. do you know?

Was this reply helpful? Yes No
berebel 45 on at

Like (0)

Report

Dear Hardesh,

Thank you very much for offering me your help.

I thought I deleted this post - but looks like it did not go through.

I was making a mistake in the form itself - while copy-pasting DisplayName - from GAL to Form - one extra space was getting added in the form after the first name... silly me!

Once I rectified that - it started resolving all names to their relevant display name.

Here's one problem - which I am not able to solve - i.e. if you have 4 Smith, John in your organization - it makes 4 entries in SharePoint List - if you are creating item after ... You cant actually tell Flow - which John Smith you need.

Is there a way .. do you know?

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

Like (0)

Report

@berebel In such cases you need to make choices like- Hardesh(hkuamr@gmail.com) this in your MS Form. The advantage of it you can directly take email from choices using split().

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
berebel 45 on at

Like (0)

Report

@Hardesh15

Not sure how to proceed...

Can you please advice?

Was this reply helpful? Yes No
berebel 45 on at

Like (0)

Report

@Hardesh15

I have fixed this problem - by using Condition Branching -

But now the only problem is - Date entry in SharePoint List -

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DueDate' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

If you can please advice me on this - it will be a big help...

Thanks

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@berebel Check your Due date value is it blank? check this solution for blank date-Solved: Flow failing due to blank date field - Power Platform Community (microsoft.com)

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
berebel 45 on at

Like (0)

Report

@Hardesh15
Thank you very much for your help and advice. I really appreciate your help.

Yes - I accept your solution.

What I did was - I went to the SharePoint List - clicked on Edit Column - although it was on Date&Time format - I changed it to a single line of text - saved - then changed it to date&time again - the saved ...

And it worked!! 😀

Was this reply helpful? Yes No